🔌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

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

Last updated

Was this helpful?