How to Integrate MySQL with Daton
This subtopic provides step-by-step instructions to create MySQL integrations in Daton, detailing the prerequisites, the integration process, and important notes.
How to Integrate MySQL with Daton
This subtopic provides step-by-step instructions to create MySQL integrations in Daton, detailing the prerequisites, the integration process, and important notes.
IP Whitelisting
- Please ensure that Daton's IP addresses are whitelisted to enable the connection to be established.
-
Click Add Rule and white list the IP Addresses below.
- 35.238.200.205/32
Integrate MySQL with Daton
- Signin to Daton
- Select MySQL from the list of Integrations
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide MySQL database hostname, port, username, and password
- Post successful authentication, you will be prompted to choose from the list of available database schemas
- Select required tables from the list for each database schema
- Then select required fields for each table.
- Select replication field for each table. 'Select None' will lead to full table replication. Selection of any primary keys or dates will load data in incremental manner
- Submit the integration
Important Note
- Integrations would begin in the Pending state and change to the Active state once the first job successfully loaded data into the configured warehouse.
- Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.
- Users can Re-Authenticate, Edit, Clone, Pause, or Delete the integration at any moment by clicking on settings. You can also adjust the frequency and history of the integration.
- On the Sources page, click Integration to access each table in your integration. The page also shows the state of each table, the last replicated time, and the Reload access buttons.
