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.