Guides
Start typing to search…

IBM DB2


Connector Details

Connector AttributesDetails
NameIBM DB2
DescriptionIBM 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 TypeClass A

Features

Feature NameFeature Details
Load StrategiesFull Load, Incremental Load
Metadata ExtractionSupported
Data AcquisitionSupported
Data PublishingNot Supported
Automated Schema Drift HandlingSupported

Source Connection Attributes

Connection ParametersData TypeExample
Connection NameStringIBM_DB2_Connection
Server NameStringServer Name/IP Address
Database NameStringmydatabase
User NameStringmyuser
PasswordStringmypassword
PortNumeric25000/50000
Bronze Schema (Optional)String
Silver Schema (Optional)String

Screenshot To Use Connector


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.

Updated 16 days ago