The generic SQL connector is now available in our Add System Wizard. Simply click on the '+SYSTEM' button at the top-right and choose 'Use wizard to create a system', then search for 'SQL'.
When you have added the 'SQL' system onto the canvas, select it and start adding and configuring endpoints from the right sidebar.
You will be able to define the table name from which you want to fetch data (source SQL) or to which you want to send updates (destination SQL), as well as define the data structure using our standard data layout functionality and build your own query via configurable WHERE clause.
The configured endpoint can then be linked to any other endpoint available in DSYNC (ie. RSS Feed, FTP, API, Excel file etc).
Integrate data between MySQL and other data sources. Use DSYNC to sync both APIs and data with your MySQL relational databases and cloud data sources. Data Integration makes the ETL design and mapping process simpler and faster no matter how diverse the data environment.
If you work with SQL at some point you'll probably need to access data from a MySQL database and integrate it with other SaaS applications like commerce, point of sale, accounting or even your choice of BI tool.
DSYNC can be used to integrate both mysql databases with any available rest API system. The DSYNC system is s graphical interface that helps developers with visually and operationally linking systems together.
Common Mysql Integrations
- Link custom made ERP (which uses MySQL) to Magento2, WooCommerce, Shopify, BigCommerce
- Extract daily sales data from POS systems and synchronize with Mysql Databases
- Extract Order data, Inventory data, Customer data, Product data to and from Mysql dbs
Connect Mysql with our other ready made systems. Fully configurable REST API Endpoint All HTTP methods (POST, PUT, GET, PATCH, DELETE) Dynamic URLs allow you to set run schedule (fetch only created/updated entities since datetime
- Custom software integration into DSYNC "custom software can be linked to your system such as a MySQL database integration"