IBM Db2 for z/OS support (Custom Connector)

Data Lineage (manual only)ER Diagrams AI Autodocumentation Data Classification Schema Change Tracking Data Quality Data Profiling Foreign Key Testing Reference Data Extended Properties Metadata Sync Scheduling tasks Execution Flows

Custom connector for IBM Db2 for z/OS 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.

Connector features

Data Catalog

Dataedo will document the following objects from IBM Db2 for z/OS:

Tables,
Views
Procedures,
Functions

How to connect

To connect to IBM Db2 for z/OS, create new documentation by clicking Add and choosing New connection.

On the connection screen, choose IBM z/OS (Local Custom Connector) or IBM z/OS (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​