MySQL Connector - Catalog, Transform, Query, Visualize

The MySQL connector allows data to be cataloged, queried, transformed and to create tables in MySQL. This can be used to quickly and easily join data between different systems like MySQL and Hive, or between different MySQL instances.


The MySQL connector is available for the Promethium Enterprise edition. The MySQL connector is currently not available for the Free or Professional editions.


If you don't have a Promethium account, get your free account now

Jump to the how to video.


Connect MySQL

Connecting to MySQL is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select MySQL and enter the information for your MySQL.

Image of MySQL connection in Promethium
MySQL Connection

MySQL connection details can be case sensitive. Ensure that data is entered with the correct case for your MySQL.

Field

Description

Data Source Name

Give the MySQL connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Data Source Topic

Optional. Categorize the MySQL connection. For example, Marketing.

Host Name

Enter the host name for your MySQL database. For example: db.company.com

DB Port

Enter the port number for your MySQL database.

User Name

​Enter the username associated with your MySQL account.

Password

Enter the password associated with your MySQL account.

Database Name

Enter the database containing the data you want to retrieve.


What Happens Next - Finish MySQL Connection

Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your MySQL, then make the data easily searchable and usable.


Click Data Explorer from the menu and begin exploring the data in your MySQL Data Cloud.

Screenshot of MySQL data in Promethium
MySQL Data Catalog Promethium

FAQs

Is my data moved or copied out of MySQL?

No. Your data stays in MySQL and isn't moved to Promethium.


What options are available for publishing datasets?

Datasets can be published as a view, as a table in MySQL or as a dbt model.


Is this a Production-level connector?

Yes. The MySQL connector is designed for all-sized Datasets.


Watch how to video


14 views