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](https://docs.cloud.google.com/data-fusion/docs/how-to/using-jdbc-drivers#upload-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

- Learn about [configuring plugins](https://docs.cloud.google.com/data-fusion/docs/concepts/plugins).