๐Ÿ”Œ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".

Last updated