Catalog Source Configuration > MySQL
  

MySQL

MySQL is an open-source relational database management system (RDBMS) to store and structure data.

Objects extracted

The metadata extraction service extracts the following objects from a MySQL source system:

Prerequisites for configuring the MySQL catalog source

Configure permissions or access to MySQL

Permissions to extract metadata
This section addresses permissions for configuring an MySQL connection.
Grant permissions that allow you to perform the following operations:
Permissions to run data profiles
To perform data profiling, grant Select permission on tables and views that you want to profile.

Data profiling for MySQL objects

Configure data profiling to run profiles on the metadata extracted from a MySQL source system. You can run data profiles on the following MySQL objects:
Sampling type
Determine the sample rows on which you want to run the data profiling task. You can choose one of the following sampling types for a MySQL catalog source:

Data classification for MySQL objects

Configure data classification for MySQL catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.

Connection properties

When you configure a connection to the MySQL source system in Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the MySQL connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Type
Type of connection. Select MySQL from the list.
Runtime Environment
The execution platform that run tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
User Name
User name for the database login.
The user name can't contain a semicolon.
Password
Password for the database login.
The password can't contain a semicolon.
Host
Name of the machine that hosts the database server.
Port
Network port number used to connect to the database server. Default is 3306.
Database Name
Name of the MySQL database that you want to connect to.
Code Page
The code page of the database server.
Use SSL
SSL attribute. Determines whether the Secure Agent establishes a secure connection to the MySQL database.
When you select this option and the database server supports SSL, the Secure Agent establishes an encrypted connection. If the MySQL database server cannot configure SSL, the connection either fails or the Secure Agent establishes an unencrypted connection depending on whether you select Require SSL.
If you do not select Use SSL, the Secure Agent attempts to establish an unencrypted connection.
Verify Server Certificate
SSL attribute. If you select both Use SSL and Verify Server Certificate, the client validates the server certificate that the database server sends.
Require SSL
SSL attribute. Applicable only if you selected Use SSL.
If you select the Require SSL checkbox, and the MySQL database supports SSL, the Secure Agent establishes an SSL connection.
If you select the Require SSL checkbox, and the MySQL database cannot configure SSL, the Secure Agent attempts to establish an SSL connection but fails.
If you clear the Require SSL checkbox, and the MySQL database cannot configure SSL, the Secure Agent establishes an unencrypted connection.
TLS Protocols
SSL attribute. Applicable only if you selected Use SSL. The TLS protocols used for secure communication.
You can select the following protocols:
  • - TLSv1
  • - TLSv1.1
  • - TLSv1.2
Trust Certificate Key Store
JDBC attribute. The path and file name of the truststore file. You must prefix the file path with file colon (file:).
For example, file:C:\SSL\mysql_new\truststore
Trust Certificate Key Store Password
JDBC attribute. The password for the truststore file.
Client Certificate Key Store
JDBC attribute. The path and file name of the keystore file. You must prefix the file path with file colon (file:).
For example, file:C:\SSL\mysql_new\keystore
Client Certificate Key Store Password
JDBC attribute. The password to access the keystore file.