Plugin drivers

This page explains how to use Java Database Connectivity (JDBC) drivers with Cloud Data Fusion pipelines.

Some plugins in Cloud Data Fusion require a JDBC driver to be added to the namespace. For example, before you can run a pipeline with a MySQL batch source plugin, you must add the supported MySQL driver to the namespace. You can add JDBC drivers to a namespace from the Cloud Data Fusion Hub, the Namespace admin page, or the Add entity page. You can also delete unneeded JDBC drivers from the Namespace admin page.

Add a JDBC driver

Hub

To add a JDBC driver from the Cloud Data Fusion Hub, follow these steps:

  1. In the Cloud Data Fusion Studio, click Hub > Drivers, and click a driver.
  2. Optional: To get information about where to download the JAR file, click Download.
  3. Click Deploy, upload the JAR file, and click Next.
  4. Verify the class name and version of the driver.
  5. Click Finish.

Cloud Data Fusion adds the driver to the namespace.

Namespace admin page

To add a JDBC driver from the Namespace administrator page, follow these steps:

  1. Download a driver. For example, to download the JDBC driver for MySQL, go to dev.mysql.com and download the JAR file.
  2. In Cloud Data Fusion, click Menu > Namespace Admin.
  3. On the Namespace page, click Drivers.
  4. Upload your JAR file and click Next.
  5. Enter the name and class of the driver.
  6. Click Finish.

The driver is added to the namespace.

Add entity page

To add a JDBC driver from the Add entity page, follow these steps:

  1. Download a driver. For example, to download the JDBC driver for MySQL, go to dev.mysql.com and download the JAR file.
  2. On the Pipeline page, click the green plus sign.
  3. On the Add entity page that appears, go to Driver and click Upload.
  4. Upload the JAR file and click Next.
  5. Enter the name and class of the driver.
  6. Click Finish.

The driver is added to the namespace.

Use a JDBC driver

  1. On the Pipeline page in the Cloud Data Fusion Studio, choose a plugin from the Source or Sink list. The node for the source or sink appears in your pipeline.
  2. Hold the pointer over the node in the pipeline and click Properties.
  3. In the Reference name field, enter the name you defined for the driver in the preceding Add a JDBC driver step.
  4. Click Close.

Delete a JDBC driver

To delete a JDBC driver from a namespace, follow these steps:

  1. In Cloud Data Fusion, click Menu > Namespace Admin.
  2. On the Namespace page, click Drivers.
  3. Choose a driver and click More.
  4. Click Delete.

What's next