YouPrep documentationHelp centerGet a demo

🔌Setting up a MySQL connector

Configuring the MySQL connector in Toucan

Fill in the connection information:

Basic Connection Options

Host (mandatory)

  • Format: String

  • Description: The domain name or IP address of your database server

  • Example: "db.example.com" or "192.168.1.100"

Port (mandatory)

  • Format: Integer

  • Description: The listening port of your database server

  • Example: 3306

User (mandatory)

  • Format: String

  • Description: Your login username

  • Example: "myuser"

Password (mandatory)

  • Format: String

  • Description: Your login password

  • Example: "secretpassword123"

Character Encoding Options

Charset (optional)

  • Format: String

  • Description: Character encoding for the connection

  • Default: "utf8mb4"

  • Example: "utf8mb4"

Charset Collation (optional)

  • Format: String

  • Description: The charset's collation for server connections

  • Example: "utf8mb4_unicode_ci"

Connection Timeout

Connect Timeout (optional)

  • Format: Integer

  • Description: Connection timeout in seconds

  • Example: 30

SSL Options (optional)

SSL Mode

  • Format: Enum

  • Options: VERIFY_IDENTITY, VERIFY_CA, REQUIRED

  • Description: SSL Mode for MySQL server connection

  • Example: VERIFY_CA

SSL CA

  • Format: String

  • Description: CA certificate content in PEM format

  • Example: "-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----"

SSL Cert

  • Format: String

  • Description: X509 certificate content in PEM format

  • Example: "-----BEGIN CERTIFICATE-----\nMIID...\n-----END CERTIFICATE-----"

SSL Key

  • Format: String

  • Description: X509 certificate key content in PEM format

  • Example: "-----BEGIN PRIVATE KEY-----\nMIIE...\n-----END PRIVATE KEY-----"

Then click on TEST CONNECTION and SAVE the connection

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Selecting data from MySQL

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 or Views

  • Only keep columns you need

For more info, see the dedicated section Creating datasets

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