🔌Setting up a MySQL connector

Configuring the MySQL connector in Toucan

Fill in the mandatory connection information:

• Host/ server name

• Username

• Password

• Port

Then we can finally hit the 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".