Build X-Cart-Connected ETL Processes in Google Data Fusion

Ready to get started?

Download for a free trial:

Download Now

Learn more:

X-Cart JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with X-Cart.



Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live X-Cart data.

Google Data Fusion allows users to perform self-service data integration to consolidate disparate data. Uploading the CData JDBC Driver for X-Cart enables users to access live X-Cart data from within their Google Data Fusion pipelines. While the CData JDBC Driver enables piping X-Cart data to any data source natively supported in Google Data Fusion, this article walks through piping data from X-Cart to Google BigQuery,

Upload the CData JDBC Driver for X-Cart to Google Data Fusion

Upload the CData JDBC Driver for X-Cart to your Google Data Fusion instance to work with live X-Cart data. Due to the naming restrictions for JDBC drivers in Google Data Fusion, create a copy or rename the JAR file to match the following format driver-version.jar. For example: cdataxcart-2020.jar

  1. Open your Google Data Fusion instance
  2. Click the to add an entity and upload a driver
  3. On the "Upload driver" tab, drag or browse to the renamed JAR file.
  4. On the "Driver configuration" tab:
    • Name: Create a name for the driver (cdata.jdbc.xcart) and make note of the name
    • Class name: Set the JDBC class name: (cdata.jdbc.xcart.XCartDriver)
  5. Click "Finish"

Connect to X-Cart Data in Google Data Fusion

With the JDBC Driver uploaded, you are ready to work with live X-Cart data in Google Data Fusion Pipelines.

  1. Navigate to the Pipeline Studio to create a new Pipeline
  2. From the "Source" options, click "Database" to add a source for the JDBC Driver
  3. Click "Properties" on the Database source to edit the properties

    NOTE: To use the JDBC Driver in Google Data Fusion, you will need a license (full or trial) and a Runtime Key (RTK). For more information on obtaining this license (or a trial), contact our sales team.

    • Set the Label
    • Set Reference Name to a value for any future references (i.e.: cdata-xcart)
    • Set Plugin Type to "jdbc"
    • Set Connection String to the JDBC URL for X-Cart. For example:

      jdbc:xcart:RTK=5246...;Url=https://example.com/shop;ApiKey=MyApiKey;

      An API Key must be created for your XCart Installation. In order to obtain the API Key, you need to install and configure the REST API Module for your X-Cart installation.

      • Login to your X-Cart Installation. Click on My addons on the bottom of the left side-bar navigation panel.
      • Search for REST API Module. Install the Module.
      • After the module has been installed, you need to set it up.
        • Go to the Settings section for the REST API Module.
        • On the settings page specify the API Key (only read)
      • Set the ApiKey and Url to the connection property to connect to data.

      Built-in Connection String Designer

      For assistance in constructing the JDBC URL, use the connection string designer built into the X-Cart JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

      java -jar cdata.jdbc.xcart.jar

      Fill in the connection properties and copy the connection string to the clipboard.

    • Set Import Query to a SQL query that will extract the data you want from X-Cart, i.e.:
      SELECT * FROM PROFILES
  4. From the "Sink" tab, click to add a destination sink (we use Google BigQuery in this example)
  5. Click "Properties" on the BigQuery sink to edit the properties
    • Set the Label
    • Set Reference Name to a value like xcart-bigquery
    • Set Project ID to a specific Google BigQuery Project ID (or leave as the default, "auto-detect")
    • Set Dataset to a specific Google BigQuery dataset
    • Set Table to the name of the table you wish to insert X-Cart data into

With the Source and Sink configured, you are ready to pipe X-Cart data into Google BigQuery. Save and deploy the pipeline. When you run the pipeline, Google Data Fusion will request live data from X-Cart and import it into Google BigQuery.

While this is a simple pipeline, you can create more complex X-Cart pipelines with transforms, analytics, conditions, and more. Download a free, 30-day trial of the CData JDBC Driver for X-Cart and start working with your live X-Cart data in Google Data Fusion today.