This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
The scenario I needed to accomplish was to pull data from SQL server, group the data sets together based on different fields and then dynamically define the file name based on those groupings.
Performance was the #1 consideration and competitive tool...
The post below was designed for the BLOB data type in SQL Server (2014) but similar concepts should work for other data sources as well.
Setup:
in SQL Server Mgmt Studio
CREATE TABLE [BLOBS](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Data] var...
Using ServiceNow (SNOW) Outbound REST and Business Rules with SnapLogic.
This document defines the steps required to create a Business Rule and REST Endpoint in ServiceNow that will call a SnapLogic pipeline. Business rules allow the user to define c...
The topic of "providing windows ID / Password to SQL Server has come up a few different times so below is a solution that I found to work in most instances.
Scenario:
Service accounts with Native SQL Server authentication is NOT supported (internal s...
Arun,
I have confirmed with with our PM organization that customization (installing client utilities etc.) to CloudPlex enviroment is not possible. Previously I thought this was an option and I apologize for leading you down the wrong path.
You may ...
Arun,
To use the BCP utility (BULK LOAD) for SQL Server, it does require the SQL Server client tools (or command line utilities) to be installed on the SnapLogic Execute Node. You mention a cloud-plex in your post so please reach out to SnapLogic Su...
The accdb file must be somewhere that can be accessed from the groundplex execution (not within the SnapLogic Database). In your example, it’s looking for a file in the folder /tmp.
Hope that helps.
Eric B.
If you are using the UcanAccessDriver, that JDBC URL doesn’t look correct since it won’t know the SLDB enviroment. That should be close to what the original stated but pointing to the file location on the node.
