IBM DB2
Overview
The IBM Db2 source connector allows data synchronization from a Db2 database, supporting both Full Refresh and Incremental sync options.
Prerequisites
To configure this connector, the following details are required:
- Host
- Port
- Database Name
- Username
- Password
It is strongly advised (though not mandatory) to create a dedicated read-only user and role with access permissions across all relevant schemas to ensure controlled and secure replication.
Configuration Steps
- Provide Connection Information
- Enter the host, port number, and database name in the connector’s setup interface.
- Create a Read-Only User (Recommended)
- Enhances security and makes it easier to track access and changes.
- Enable SSL (Optional but Recommended)
- To secure the connection, upload a client certificate under the “SSL PEM file” field.
- The connector will automatically store it in the secret keystore.
- You can either input a custom keystore password or allow the system to generate one.