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 | 🟡 Beta |
| 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.