Cloud Data Fusion


Cloud Data Fusion


This page outlines the steps to install and configure the CData Connect Cloud connector for Cloud Data Fusion. After installation, Cloud Data Fusion can pull data from sources that you have connected to your CData Connect Cloud account.

Prerequisites

Before you can configure and use Cloud Data Fusion with CData Connect Cloud, you must first connect a data source to your CData Connect Cloud account. See Connections 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.

Connecting to CData Connect Cloud

To establish a connection from Cloud Data Fusion to CData Connect Cloud, follow these steps.

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

    1. Open the Client Tools page of CData Connect Cloud.
    2. Search for JDBC or Cloud Data Fusion.
    3. Click Download and select your operating system.
    4. When the download is complete, run the setup file.
    5. When the installation is complete, the JAR file can be found in the installation directory.
  2. Log into Cloud Data Fusion.

  3. Click the green “+” in the top right to add an entity.

  4. Under Driver, click Upload.

  5. Upload the CData Connect Cloud JDBC driver.

  6. Enter the driver settings.

    • Name—the name of the driver
    • Class name—enter cdata.jdbc.connect.ConnectDriver
    • Version—the driver version
    • Description—(optional) a description for the driver

  7. Click Finish.

  8. Enter source configuration settings.

    • Label—to identify the connection
    • JDBC driver name—enter the JDBC driver name. This is to identify the driver configured in Step 6.
    • Connection string—the JDBC connection string. It is formatted like jdbc:connect:AuthScheme=Basic;User=[User];Password=[Password];. Fill in this string with the following parameters.
    • User—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud interface. For example, test@cdata.com.
    • Password—enter the PAT you generated on the Settings page.

  9. Click Validate in the top right.

  10. If the connection succeeds, you can manage the pipeline by editing it through the UI.

Troubleshooting

Please be aware that there is a known issue with Cloud Data Fusion where int types from source data are automatically cast as long.