Skip to content

About the DB2 connector plugins

The DB2 connector (a Sidra plugin of type connector) enable seamless integration with IBM powerful enterprise relational database.

You can see more details of what is a Data Intake Process in this page.

Sidra's connector for DB2 allows to configure a Data Intake Process from a DB2 data source in a fast and easy way. The resulting configured Data Intake Process extracts data from any table and view in the source database and loads it into the specified Data Storage Unit at regular intervals. It relies on the Sidra Metadata Model for mapping source data structures to Sidra as destination and uses Azure Data Factory as underlying data integration mechanism within Sidra.

When configuring and executing this plugin of type connector, several underlying steps are involved to achieve the following:

  • The necessary metadata and data governance structures are created and populated in Sidra: Data Intake Process, Provider, Entities, Attributes and needed relations among these.
  • The actual data integration infrastructure (ADF Pipeline) is created, configured, and deployed.

The resulting Data Intake Process is configured in less than five-minutes. Once the settings are configured and the deployment process is started, the actual duration of the data ingestion from the created pipelines may vary from few minutes to few hours, depending on the data volumes.

After starting the Data Intake Process creation, users will receive a message that the process has started and will continue in the background. Users will be able to navigate through Sidra Web as usual while this process happens.

Once the whole deployment process is finished, users will receive a notification in Sidra Web Notifications widget. If this process went successfully, the new data structures (new Entities) will appear in the Data Catalog automatically, and the Data Intake Process will appear in the Data Intake section including this new data source.

Supported DB2 server versions

The following list includes the following DB2 services and versions supported by this connector plugin:

  • IBM DB2 for LUW (version 11.XX)