Note：CData Connect Cloud でSnapLogic を設定して使用する前に、データソースをCData Connect Cloud アカウントに接続する必要があります。詳細は、Connections を参照してください。

You must also generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

1. Download and install the CData Connect Cloud JDBC driver.

   1. Open the Client Tools page of CData Connect Cloud.
   2. In the Dev Tools section, click JDBC.
   3. Download and run the setup file.
   4. 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.

2. Log in to SnapLogic.

3. Click the Manager tab.

4. Select a folder on the left to add the JDBC JAR file to.

   

5. Click the Files tab.

   

6. Click the “+” button in the top right to upload the CData Connect Cloud JDBC JAR file. It appears as a file once uploaded.

   

7. Click the Designer tab.

8. Click JDBC to expand the options for snaps.

9. Click and drag a Generic JDBC - Select snap onto the designer.

   

10. Click Add Account > Continue.

11. Enter the JDBC connection properties.

    • JDBC driver—add the CData Connect Cloud 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—CData Connect Cloud のユーザー名を入力します。ユーザー名は、CData Connect Cloud の画面の右上に表示されています。例：test@cdata.co.jp

    • Password—Settings ページで生成したPAT を入力します。

    

12. Click Validate. If the connection succeeds, the snap is ready to use.

13. Click Apply.