IBM DB2
Connector Details
Connector Attributes | 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
Feature Name | Feature Details |
---|---|
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 |
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.
-
Full Load: select
Full
as value forLoad Strategy
in metadata catalog of Data source. -
Incremental Load:
Load Strategy
andWatermark Type
defines the various types of incremental loads.
OnlyTIMESTAMP
is supported as Merge Strategy from UI. For other type of Merge strategies updating theWaterMarkType
ofObjectList
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
TheWatermark Date
will be updated inObject 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
TheWatermarkId
(Object Extract) will be updated during extraction process.
Updated 17 days ago