Cloudera Docs

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 Cloudera 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 Cloudera Octopai Client

How to set up the permissions

MySQL :: Download Connector/ODBC

How to verify the extracted Metadata File

Access the Cloudera Octopai Target Folder (TGT)

  1. Go to the TGT Folder located on the Server where the Cloudera Octopai Client is installed. By default: C:\Program Files (x86)\Octopai\Service\TGT
  2. Open the zip file having the Connector Name. Example:
  3. Verify its content: Quantity & Quality of inner files

Troubleshoot

Error during the extraction:

  • Check the permissions
  • Send the log with the connector number and name to Cloudera Support - C:\Program Files (x86)\Octopai\Service\log