IBM Db2 on Cloud Setup Guide PRIVATE PREVIEWlink

Follow these instructions to replicate your IBM Db2 on Cloud database to your destination using Fivetran.

Prerequisiteslink

To connect your IBM Db2 on Cloud database to Fivetran, you need:

IBM Db2 on Cloud 11.1 or above
IP (e.g. 1.2.3.4) or host (your.server.com)
Port (usually 50000 for non-TLS connections or 50001 for TLS connections)

Choose a connection methodlink

Decide whether to connect to your destination directly or connect using an SSH tunnel.

To connect using an SSH tunnel, follow these instructions.
To connect directly, configure your firewall and/or other access control systems to allow incoming connections to your IBM Db2 on Cloud database host and port from Fivetran's IP.

Create userlink

Create an operating system user named FIVETRAN.
Connect to your database as an admin user.
Execute the following SQL command to grant the FIVETRAN user permission to connect to your database's transaction log:

GRANT DBADM ON DATABASE TO USER FIVETRAN;

Grant read-only accesslink

Once you've created the FIVETRAN user, grant it SELECT permission for each schema and table you would like to sync:

GRANT SELECT ON <schemaA>.<tableA> TO USER FIVETRAN;
GRANT SELECT ON <schemaA>.<tableB> TO USER FIVETRAN;
GRANT SELECT ON <schemaB>.<tableC> TO USER FIVETRAN;

Enable data capture changelink

Execute the following command to enable "data capture change" on the tables that you would like to sync:

ALTER TABLE <schemaA>.<tableA> DATA CAPTURE CHANGES;
ALTER TABLE <schemaA>.<tableB> DATA CAPTURE CHANGES;
ALTER TABLE <schemaB>.<tableC> DATA CAPTURE CHANGES;

Adblock Detection