MySQL

How to set up MySQL metadata sources, configure permissions, and verify extracted files.

Tool Permissions Prerequisites

MySQL ODBC driver installed on the machine running the Octopai Client

Open Server Port for each MySQL Database Connection

Existing/New MySQL user (OCTOPAI_USER) for each connection with grant select permission for the following dictionary tables:

  • information_schema.tables;
  • information_schema.columns;
  • information_schema.key_column_usage;
  • information_schema.table_constraints;
  • information_schema.routines;

Setting up MySQL Metadata Source

Metadata Sources are set on the Octopai Client

How to set up the permissions

MySQL :: Download Connector/ODBC

Verify extraction results

After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.

Troubleshoot

If an error occurs during the extraction, see Troubleshoot connector extraction failures.