Sync data from MySQL to MySQL
.svg)
Sync your data from MySQL to MySQL with DataChannel in minutes without writing any code or scripts. Select and map the fields you want to load and retain complete control over the data you are moving.
MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability.
Learn more about MySQL.
This sync can be used to request and retrieve data from a user specified datawarehouse to the MySQL.
Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a MySQL Warehouse.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
3. Configure your Data Destination - Navigate to Destinations tab and select MySQL.
.png)
