IBM DB2

Connector Details

Name	IBM DB2
Description	IBM Db2 is a relational database management system (RDBMS) developed by IBM. It is designed to efficiently store, retrieve, and manage structured data and is widely used in enterprise applications. Db2 supports SQL (Structured Query Language) and provides robust features for transaction processing, analytics, and AI-driven insights.
Connector Type	Class A

Features

Load Strategies	Full Load, Incremental Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Supported

Source Connection Attributes

Connection Parameters	Data Type	Example
Connection Name	String	IBM_DB2_Connection
Server Name	String	Server Name/IP Address
Database Name	String	mydatabase
User Name	String	myuser
Password	String	mypassword
Port	Numeric	25000/50000
Bronze Schema (Optional)	String
Silver Schema (Optional)	String

Connector Specific Configuration Details

Supported load strategies

Load strategies can be configured in the Metadata Catalog View of the DataSource through the User Interface (UI), or manually in the Object List state DB table for features that are not accessible via the UI.

1. Full Load: select Full as value for Load Strategy in metadata catalog of Data source.

2. Incremental Load: Load Strategy and Watermark Type defines the various types of incremental loads.
   Only TIMESTAMP is supported as Merge Strategy from UI. For other type of Merge strategies updating the WaterMarkType of ObjectList table is required manually.

   a. Timestamp based extraction:
   Select the following fields in metadata catalog

   1. LoadIncremental = 1
   2. WaterMarkType = TIMESTAMP/ DATE
   3. Watermark Column The Watermark Date will be updated in Object Extract table during the extraction process.

   b. Identity Tracking extraction:
   In [state].[ObjectList] table set the following in order to use the Identity tracking

   1. LoadIncremental = 1
   2. WaterMarkType = 'IDENTITY'
   3. Watermark Column
      The WatermarkId (Object Extract) will be updated during extraction process.

Screenshot To Use Connector