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 | 🟡 Beta |
Setup
- Open the Data Connection application and select + New Source in the upper right corner of the screen.
- Select DB2 from the available connector types.
- Choose to use a direct connection over the Internet or to connect through an agent runtime.
- 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 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 ↗ 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 ↗ 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.
Table Exports
The DB2 source type supports 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 ↗ must be enabled for any target tables.
Change data capture
The DB2 connector supports change data capture (CDC) syncs. DB2 CDC syncs are implemented using the Debezium DB2 connector ↗. To enable CDC on your DB2 instance, follow the instructions outlined in the Debezium documentation ↗.
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 to proceed with creating a change data capture sync.