# Db2

Connect Foundry to Db2 to read and sync data between Db2 databases and Foundry.

## Supported capabilities

| Capability | Status |
| --- |--- |
| Exploration | 🟢 Generally available |
| Batch syncs | 🟢 Generally available |
| Incremental | 🟢 Generally available |
| Change data capture syncs | 🟢 Generally available |
| [Table Exports](../../data-connection/export-overview/index.md#table-exports) | 🟢 Generally available |

## Setup

1. Open the [Data Connection](../../data-connection/overview/index.md) application and select **+ New Source** in the upper right corner of the screen.
2. Select **Db2** from the available connector types.
3. Follow the additional configuration prompts to continue the setup of your connector using the information in the sections below.

Learn more about [setting up a connector](../../data-connection/set-up-source/index.md) in Foundry.

## Configuration options

|Parameter	|Required?	|Description	|
|---	|---	|---	|
|`URL`	|Yes	|The JDBC URL that is used by the driver. Comes pre-populated with a template that may need to be modified to ensure correct behavior. Refer to the source system's documentation for the JDBC URL format, and review the [Java documentation ↗](https://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html) for additional information. 	|
|`JDBC properties`	|Yes	|Lists out all required and recommended properties that the driver needs. Hovering over a required or recommended property will allow you to navigate to the official documentation. You can add any additional properties by hitting the **+ Add property** button. 	|
|	|	|	|

### JDBC properties

You can add [properties ↗](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Properties.html) to your JDBC connection to configure behavior. Certain properties are mandatory for the Db2 driver. These mandatory properties are populated by default and must be set before you can save your source. You can also view recommended properties that you can add by selecting **+Add property** and viewing the **Recommended** section.

Hover over the name of a `Required` or `Recommended` property to visit the official documentation page for the Db2 driver.

## Configure Db2 syncs

### SQL queries

A single SQL query can be executed per sync. This query should produce a table of data as an output and should not perform operations like invoking stored procedures. The results of the query will be saved to the output dataset in Foundry.

![The SQL Query input on the Edit syncs page for a JDBC connector.](../../../assets/04c75d0706dc37d26b256af96f02909d1bf37cba9cf8d1be22af3ea608e27078.webp)

## Table Exports

The Db2 source type supports [table exports](../../data-connection/export-overview/index.md#table-exports). For Db2 databases running on z/OS or LUW (Linux, Unix, Windows), no additional configuration should be required. However, for Db2 databases running on the IBM iSeries or AS/400, [journaling ↗](https://www.ibm.com/docs/en/i/7.5?topic=integrity-journaling) must be enabled for any target tables.

## Change data capture

The Db2 connector supports [change data capture](../../data-integration/change-data-capture/index.md) (CDC) syncs. Db2 CDC syncs are implemented using the [Debezium Db2 connector ↗](https://debezium.io/documentation/reference/stable/connectors/db2.html). To enable CDC on your Db2 instance, follow the instructions outlined in the [Debezium documentation ↗](https://debezium.io/documentation/reference/stable/connectors/db2.html#setting-up-db2).

Once change data capture is enabled for the table(s) you wish to sync to Foundry, you can navigate to the **Overview** page and select **+ Create CDC sync** to start creating a new change data capture sync.

The exploration runtime must be working in order to create a change data capture sync. If the runtime is still initializing, you may need to wait a few seconds and refresh the page before creating the sync.