SnapLogic
SnapLogic
Note: Before you can configure and use SnapLogic with Connect AI, you must first connect a data source to your Connect AI account. See Sources for more information.
You must also generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.
-
Download and install the Connect AI JDBC driver.
- Open the Integrations page of Connect AI.
- In the Dev Tools section, click JDBC.
- Download and run the setup file.
- When the installation is complete, the JAR file can be found in the installation directory. The default directory is
C:/Program Files/CData/CData Connect JDBC driver/lib
.
-
Log in to SnapLogic.
-
Click the Manager tab.
-
Select a folder on the left to add the JDBC JAR file to.
-
Click the Files tab.
-
Click the “+” button in the top right to upload the Connect AI JDBC JAR file. It appears as a file once uploaded.
-
Click the Designer tab.
-
Click JDBC to expand the options for snaps.
-
Click and drag a Generic JDBC - Select snap onto the designer.
-
Click Add Account > Continue.
-
Enter the JDBC connection properties.
-
JDBC driver—add the Connect AI JAR file
-
JDBC driver Class—enter cdata.jdbc.connect.ConnectDriver
-
JDBC Url—enter a JDBC connection string for the JDBC driver. The connection string is formatted like
jdbc:connect:AuthScheme=[AuthScheme];User=[User];Password=[PAT];
. -
Username—enter your Connect AI username. This is displayed in the top-right corner of the Connect AI interface. For example, test@cdata.com.
-
Password—enter the PAT you generated on the Settings page.
-
-
Click Validate. If the connection succeeds, the snap is ready to use.
-
Click Apply.