DB2 Table
Last updated
Last updated
DB2 (Formerly Db2 for LUW) is a relational database that delivers advanced data management and analytics capabilities for transactional workloads.
Prior to setting up your data sync destination, ensure that you've configured your Source.
The DB2 Table destination supports batch and real-time syncs.
The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).
The following parameters will help to define your data sync destination and how it functions.
Destination
Mandatory. Select your destination from the drop down menu.
DB2 Table
Connection String
Mandatory. The encrypted Connection String used to connect to your DB2 database. The Connections UI will automatically encrypt this value for you.
You can find an example Connection String here.
Table
Mandatory. The name of the DB2 table that you want to sync your data to, including the schema
dbo.employees
ID Column
The name of the identity column that exists in the destination (or a single column that is guaranteed to be unique and automatically populated for every new record)
ID Column Data Type
The data type of the above ID Column.
Define your Sync Behaviour.
Add in your Post Sync Scripts, if required.
Define your Permissions.
If you are running a real-time sync, set up your Listener Config and enable it to begin your sync.
If you are running a batch sync, click Jobs > Start a Job to begin your sync.