Use MySQL database tables as Data Platform sources
MySQL is an open-source relational database management system. The Platform allows you to use the tables in a MySQL database as sources for your
Objective
MySQL is an open-source relational database management system. The Platform allows you to use the tables in a MySQL database as sources for your application.
Add a MySQL source on the Platform
Configure your connection
When creating the source, you will be required to input the following information :
- Host: the host name of the MySQL database.
- Port: the port address of the MySQL database.
- Database: the name of the MySQL database.
- Username: the user name for the MySQL database.
- Password: the password for the Username you are using.
- SSL: if activated, encrypts the information exchanged between the Data Platform and the database.
Select the tables you want
After establishing a connection with your MySQL database your tables will be fetched and displayed :
Select which tables you want to be included in the source by checking the boxes to the left of the table name, as indicated in the image above.
If the state of the database changes, you can use the Fetch button to refresh the tables displayed and include them in your source.
Once you follow the steps above, click on the Create button on the top right-hand corner.
Don't forget to name your source before creating it. The technical name cannot be changed after creating the source and will be used when trying to open the source using the SDK.
Go further
If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.
Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated Discord channel.
If you need support with your OVHcloud services, create a request in our Help Centre.
Join our community of users.