IBM Db2 LUW CDC with Gluesync: Triggers Setup Guide

Source data from IBM Db2 for LUW

Prerequisites

To have Gluesync working on your DB2 LUW instance you will need to have:

Valid user credentials with permission to read, and create triggers to the source tables.

Setup via Web UI

Hostname / IP Address: DNS record or IP Address of your server;
Port: Optional, defaults to 50000;
Database name: Name of your target database;
Username: Username with read & write access role to target Namespace;
Password: Password belonging to the given username.
Character encoding: Optional, defaults to UTF-8 to read data with different encoding.

Setup via Rest APIs

Here’s an example of calling the Core Hub’s REST API via curl to set up the connection for the IBM DB2 LUW agent:

curl --location --request PUT 'http://core-hub-ip-address:1717/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "myDB2LUWAgent",
        "host": "db2-server-address",
        "port": 50000,
        "databaseName": "your_database_name",
        "username": "db2admin",
        "password": "your_secure_password"
      },
      "specificConfiguration": {
        "characterEncoding": "UTF-8"
      },
}'