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:

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

  1. Provide Connection Information
    • Enter the host, port number, and database name in the connector’s setup interface.
  2. Create a Read-Only User (Recommended)
    • Enhances security and makes it easier to track access and changes.
  3. 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.