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

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.

Connector features

Data Catalog

Dataedo will document the 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.

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

Choose the ODBC driver configured earlier.

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

ODBC Driver​

Connector features​

Data Catalog​

How to connect​

Connector specification​

Imported objects​

Tables metadata​

Views metadata​

Procedures metadata​

Functions metadata​