MySQL Connector: Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Applies from release 2021.4

Overview

The OCF Connector for MySQL was developed by Alation and is available as a zip file, which can be uploaded in Manage Connectors and installed.

To download the MySQL OCF connector package, go to the Alation Connector Hub available from the Customer Portal. Go to Customer Portal > Connectors > Alation Connector Hub. Only Alation users with access to the Customer Portal can access the Alation Connector Hub. If you don’t have access to the Customer Portal, contact Alation Support.

This connector should be used to catalog MySQL as a data source in Alation. The connector catalogs MySQL objects such as tables, columns, views, primary keys, foreign keys, functions, and function def fields. It enables end-users to search, find, and curate MySQL objects from the Alation user interface.

Team

The following administrators are required to install this connector:

  • Alation Administrator:

    • Installs the connector

    • Creates and configures a MySQL data source in the Catalog

  • MySQL Objects Administrator:

    • Creates a Service Account with the Enterprise authentication type

    • Provides the JDBC URI to access metadata

    • Provides access to public schemas to extract metadata.

Scope

The table below shows what features are covered by the connector. For version support information, refer to Support Matrix.