How to Set up Your MySQL Database as a Destination in Daton

This subtopic provides step-by-step instructions to integrate your MySQL database as a destination in Daton, detailing the prerequisites, the integration process, and important notes.

Pre-requisites

Before attempting to integrate your MySQL database as a destination in Daton, ensure you have the following:

• Active Daton account

• Performed the required configuration as outlined in the subtopic How to Set up a MySQL Database for Integrating with Daton

Steps to Add MySQL Database as a Destination in Daton

1. Log in to your Daton account and navigate to the Destinations page.

2. Click the Add New Destination button and select MySQL from the list of options.

3. Enter the Integration Name and click Next. A unique name for your MySQL integration. This name will be used to create tables in the data warehouse and cannot be modified later.

   
4. Enter the following details to configure the connection to your MySQL database and click Next.

   • MySQL Host: The IP address or hostname of the MySQL server.

   • MySQL Port: The port number of your MySQL server. The default port is 3306.

   • MySQL User: The username provided for the dedicated user with access to the database.

   • MySQL Password: The password provided for the MySQL user.

   • MySQL Database: The name of the MySQL database you want to connect to.

     
5. Select the Schema of your choice and click Submit. A message will confirm successful integration.

   

The MySQL database is now configured as a destination in Daton.

Note: Once the integration is complete, you can query your MySQL database in Daton to create additional schemas and tables as needed.