Samuel Chmiel
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 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 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 |