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.
Browser |
MySQL (EC2) |
MySQL (RDS) |
|---|---|---|
Core Capabilities |
||
Automated Metadata Extraction (MDE) |
✔ |
✔ |
Query-based MDE |
✔ |
✔ |
Search |
✔ |
✔ |
Catalog page curation |
✔ |
✔ |
Catalog Sets |
✔ |
✔ |
Propagation of Data Quality Flags |
✔ |
✔ |
Popularity |
✔ |
✔ |
Compose |
||
On-prem Alation instances |
✔ |
✔ |
Alation Cloud Service instances* |
✔ |
✔ |
* Compose for data sources connected via Alation Agent is supported from connector version 11.2.7.2455. |
||
QLI |
||
Query based |
✔ |
✔ |
Filters |
✔ |
✔ |
Lineage |
✔ |
✔ |
Sampling and Profiling |
||
Table Sampling |
✔ |
✔ |
Custom Query Based Table Sampling |
✔ |
|
Custom Query Based Column Profiling |
✔ |
✔ |
Dynamic Profiling |
✔ |
✔ |
Authentication |
||
Basic (username and password) |
✔ |
✔ |
SSL |
✔ |
✔ |
Kerberos |
✔ |
ㄨ |
Keytab |
ㄨ |
ㄨ |
LDAP |
✔ |
ㄨ |
Technical Metadata |
||
Tables |
✔ |
✔ |
Attributes |
✔ |
✔ |
Primary Key |
✔ |
✔ |
Foreign Key |
✔ |
✔ |
Views |
✔ |
✔ |
Schemas |
✔ |
✔ |
Source Comments |
✔ |
✔ |
Synonyms |
ㄨ |
ㄨ |