IBM Db2 for iSeries (DB2 for IBM i) support (Custom Connector)

Samuel Chmiel - Dataedo Team Samuel Chmiel 8th April, 2024
Applies to: Dataedo 23.x (current) versions, Article available also for: 24.x

Custom connector for IBM Db2 for iSeries utilizes an ODBC connection for executing custom queries and retrieves metadata using specific queries tailored to this data source.

ODBC Driver

Before importing, using the custom connector requires the installation and configuration of the ODBC driver.

We have tested the import using the official IBM i Access for Windows ODBC Driver available here https://www.ibm.com/support/pages/odbc-driver-ibm-i-access-client-solutions.

Image title

Connector features

Data Catalog

Dataedo will document following objects from IBM Db2 for iSeries:

  • Tables,
  • Views
  • Procedures,
  • Functions

How to connect

To connect to IBM Db2 for iSeries create new documentation by clicking Add and choosing New connection.

Image title

On the connection screen choose IBM iSeries (Local Custom Connector) or IBM iSeries (Shared Custom Connector)

Image title

Choose ODBC driver configured earlier

Image title

Click Connect

Connector specification

Imported objects

Object Imported as
Table Table
View View
Function Function
Procedure Procedure

Tables metadata

Metadata Imported as
Schema Schema
Name Name
Comment Description
Columns Table columns
   Name Name
   Data type Data type
   Null/Not null Nullable
   Comment Description

Views metadata

Metadata Imported as
Schema Schema
Name Name
Comment Description
Script Script
Columns View columns
   Name Name
   Data type Data type
   Null/Not null Nullable
   Comment Description

Procedures metadata

Metadata Imported as
Schema Schema
Name Name
Comment Description
Script Script
Parameters Function parameters
   Name Name
   Data type Data type
   Mode Mode

Functions metadata

Metadata Imported as
Schema Schema
Name Name
Comment Description
Script Script
Parameters Function parameters
   Name Name
   Data type Data type
   Mode Mode
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.