🔌Add a MySQL connector
Configuring a MySQL connection
Fill in the connection information:
Name (mandatory)
String
Use it to identify your connection
MySQLConnection
Host (mandatory)
String
The domain name or IP address of your database server
"db.example.com" or "192.168.1.100"
Port (mandatory)
String
The listening port of your database server
3306
User (mandatory)
String
Your login user
myuser
Password (mandatory)
String
Your login password (this value will be stored as a secret)
secretpassword123
Charset (optional)
String
Character encoding for the connection
"utf8mb4" (default value)
Charset Collation (optional)
String
The charset's collation for server connections
"utf8mb4_unicode_ci"
Connect Timeout (optional)
Integer
Connection timeout in seconds
30
SSL Mode (optional)
Enum
SSL Mode for MySQL server connection Options: VERIFY_IDENTITY, VERIFY_CA, REQUIRED
VERIFY_CA
SSL CA
String
CA certificate content in PEM format
-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----
SSL Cert
String
X509 certificate content in PEM format
-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----
SSL Key
String
X509 certificate key content in PEM format
-----BEGIN PRIVATE KEY-----\nMIIE...\n-----END PRIVATE KEY-----
Retry Policy (optional)
Boolean
Boolean allows to configure a retry policy if the connection is flaky.
max attempts: maximum number of retries before giving up
max_delay: in seconds, above the connection is dropped
wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)
Integer
Slow queries' cache expiration time in seconds
Click on the
TEST CONNECTION
button thenSAVE
the connectionAfter successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab
Create a dataset from a MySQL connection
To create a dataset from MySQL, click on the "create from icon", you will then be able to:
Select the
Database
Select the
Schema
Select
Table
orViews
Only keep columns you need
After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".
Last updated
Was this helpful?