DB2 UDB

Overview

With the IBM DB2 component, you can produce fully customized DB2 UDB data flows in Semarchy xDI.

The database structure can be fully reverse-engineered and stored in xDI Metadata. You can then use it when designing mappings and processes to adapt your business rules according to your requirements.

Third-party libraries

Due to licensing restrictions, we cannot distribute the Java libraries for this database. You must obtain them yourself.

After you have the necessary IBM DB2 libraries, create a IBM DB2 module for your project, and add the libraries to the module.

Supported features

Common features

Feature Description

Reverse

This technology can be reverse-engineered to xDI Metadata.

DDL/DML Operations

Supports DML/DDL operations, such as Insert, Update, Select, Delete, Create or Drop.

Integration Methods

  • Append

  • Incremental Update

Load Methods

  • Generic Load

Staging Methods

Can be used as a stage for data transformation, mutualization, and more. The following methods are supported:

  • Staging as Sub-Query

  • Staging as View

  • Staging as Table

Rejects

Supports defining Reject rules to detect or filter out specific data during integrations.

Replication

Supports replicating data to or from this technology using Replicators.

Sub-metadata support

The IBM DB2 component lets you create Sub-Metadata on DB2 UDB schema and query folder Metadata nodes.

To learn more about Sub-Metadata, see Work with Sub-metadata.

Additional information

For the reverse to work, the DB2 user must have read access on the SYSCAT schema: