MySQL Integration Requirements

MySQL Scanner is in the MVP version, currently supporting only Extractor, Dictionary Mapping, and Dataflow Query Service scenarios.

The following are the prerequisites necessary for IBM Manta Data Lineage to connect to the third-party system, which you may choose to do at your sole discretion. Note that these are usually sufficient to connect to this third-party system; we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including their performance.

MySQL on-premises or cloud versions from AWS, Azure, or GCP
MariaDB on-premises or cloud versions from AWS, Azure, or GCP
SingleStoreDB Self-Managed or SingleStoreDB Cloud
JDBC Driver
- To use the MySQL scanner, you must provide a JDBC driver able to connect to the MySQL, MariaDB, or SingleStoreDB database you wish to scan. To do this, download and copy the JDBC driver JAR file to <MANTA_DIR_HOME\>/agent/manta-flow-agent-dir/lib-ext. We recommend using the MariaDB JDBC driver ( https://mariadb.com/kb/en/about-mariadb-connector-j/) since this driver is compatible with all MySQL-based databases. Other drivers may be used, but this will require bypassing the default settings on the scanner configuration page.
User having the SELECT privilege for each of the following tables in the information_schema:
- MySQL
  - TABLES
  - VIEWS
  - ROUTINES
  - TRIGGERS
  - EVENTS
  - PARAMETERS
  - COLUMNS
  - TABLE_CONSTRAINTS
  - KEY_COLUMN_USAGE
  - REFERENTIAL_CONTRAINTS
- MariaDB
  - TABLES
  - VIEWS
  - ROUTINES
  - TRIGGERS
  - EVENTS
  - PARAMETERS
  - COLUMNS
  - TABLE_CONSTRAINTS
  - KEY_COLUMN_USAGE
  - REFERENTIAL_CONTRAINTS
- SingleStoreDB
  - TABLES
  - VIEWS
  - ROUTINES
  - PIPELINES
  - AGGREGATE_FUNCTIONS
  - PARAMETERS
  - COLUMNS
  - TABLE_CONSTRAINTS
  - KEY_COLUMN_USAGE
  - REFERENTIAL_CONTRAINTS
Connection Parameters
- Name or IP address of the database
- Port on which the database listens for JDBC connections
- User name
- User password
Database must be accessible via network

Supported Features

The MySQL scanner distributed in R42.1 is in the MVP version and supports the following scenarios:

Extraction dictionary metadata (list of tables, columns, etc.)
Extraction via Agent only
Lineage stitching of dictionary entries to other tools (ETL and Reporting in particular) including automapping.

Known Unsupported Features

IBM Manta Data Lineage does not support the following MySQL features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

JDBC driver is not included allowing configuration for other types of JDBC drivers such as MySQL Connector/J or SingleStore JDBC driver.
Lineage through SQL code, procedures, views, etc.