Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

To get the enhanced connector for IBM DB2 for iSeries, contact the Forward Deployed Engineering team at Alation.

The IBM DB2 for iSeries Enhanced Connector allows seamless extraction of metadata, query log ingestion, and lineage tracking for Db2 objects, enabling efficient data cataloging and exploration within Alation.

The IBM DB2 for iSeries provides several key benefits including :

  • Streamlined Metadata Management

  • Improved Data Visibility and Governance

  • Enhanced Data Profiling

  • Reduced Manual Effort

  • Cost-Effective Data Management

With the IBM DB2 for iSeries Enhanced Connector, you can capture key technical metadata, including:

  • Schemas

  • Tables

  • Columns

  • Keys

  • Functions

Team

The following administrators are required to install this connector:

  • IBM DB2 Admin:

    • Creates a service account for Alation

    • Provides the JDBC URI to access metadata

    • Provides access to schemas

    • Assists in configuring query log ingestion on the Db2 database.

  • Alation Server Admin:

    • Installs the connector

    • Creates and configures a DB2 data source in the catalog

Scope

The table below describes which metadata objects are extracted by this connector and which operations are supported.

Feature

Scope

Supported

Authentication

Basic

Authentication with a service account created on the database that uses a username and password

Yes

LDAP

Authentication with a database service account that is an LDAP account in an organization’s network

No

SSL

Database connection over SSL

No

Kerberos

Support for Kerberos authentication

No

Keytab

Support for Kerberos with keytabs

No

Metadata extraction

Default MDE

Extraction of metadata based on default extraction queries in the connector code

Yes

Custom Query-Based MDE

Extraction of metadata based on extraction queries provided by a user

Yes

Popularity

Indicator of the popularity (intensity of use) of a data object, such as a table or a column

Yes

Extracted metadata objects

Schema

Data source schema displayed

Yes

Table

All Tables displayed

Yes

Column

All Columns displayed

Yes

Column data types

All Columns data types are displayed

Yes

Views

All Views are displayed

Yes

Primary Keys

Primary keys can be identified

Yes

Foreign Keys

Foreign keys can be identified

Yes

Functions

Functions can be identified

Yes

Function definitions

Function definitions can be identified

Yes

Comments

Source comments

No

Sampling & Profiling

Table sampling

Retrieval of data samples from extracted tables

Yes

Column sampling

Retrieval of data samples from extracted columns

Yes

Deep column profiling

Profiling of columns with the calculation of value distribution stats

Yes

Dynamic profiling

Ability for individual users to connect with their own database accounts to retrieve table and column samples and profiles

Yes

Custom query-based table sampling

Ability to use custom queries for sampling specific tables

Yes

Custom query-based column sampling

Ability to use custom queries for profiling specific columns

Yes

Query Log Ingestion

Table-based QLI

Ingestion of query history based on a table or view that contains query history data

Yes

Query-based QLI

Ingestion of query history based on a custom query

Yes

JOINS and filters

Calculation of JOIN and filter information based on ingested query history

Yes

Predicates

Ability to parse predicates in ingested queries

Yes

Lineage

Automatic lineage generation

Auto-calculation of lineage based on query history ingested from QLI, MDE, and Compose queries For lineage to be generated for views, Alation expects fully qualified table names to be present in view definitions

Yes

Compose

Customer-managed (on-prem) Alation instances

Compose on on-prem Alation instances

Yes

Alation Cloud Service (ACS) Instances

Depending on your network configuration, you may be using Alation Agent to connect to your data source. Compose via Agent is supported from connector version 1.0.2.2405

Yes

Basic authentication in Compose

Authentication in Compose with username and password

Yes

SSO authentication in Compose

Authentication in Compose using an SSO flow through an IdP application

Yes

Object Mapping

The diagram and table below describe which metadata objects are extracted by this connector and how they are mapped to objects in Alation.

../../../_images/IBMDB2foriSeriesMappings.png