MySQL is an open source relational database that is behind many applications, being one of the most popular databases in the world. The data integration from MySQL to the Data Warehouse created by Kondado allows you to replicate your tables and views to your analytical cloud, in a comprehensive or incremental way (capturing only new and updated data).

Adding the data source

To automate the ETL from MySQL with Kondado to your database, follow the steps below:

1. Whitelist the Kondado IPs on the database server (and on your VPC) for the port that will be used to connect with MySQL (usually 3306)
2. On the Kondado platform, go to the page to add data sources and select the MySQL data source
3. Give a name to your data source and fill in your database information

Now just save the data source and start integrating your MySQL data into the Data Lake or Data Warehouse.

Tables and Views

With our integration, you will be able to integrate tables and also views

If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your integration can be incremental

It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique

The table created will have a similar format to the one below:

Field   Type
col_x   text
col_y   float
col_z   date