Search

Google Data Fusion

Google Data Fusion

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

Prerequisites

Before you can configure and use Google Data Fusion with CData Connect, you must first connect a data source to your CData Connect 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 Google Data Fusion to CData Connect, follow these steps.

  1. Download and install the CData Connect JDBC driver.

    1. Open the Client Tools page of CData Connect.
    2. Search for JDBC or Google 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 Google Data Fusion.

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

  4. Under Driver, click Upload.

  5. Upload the CData Connect 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 username. This is displayed in the top-right corner of the CData Connect 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 Google Data Fusion where int types from source data are automatically cast as long.