TrustRadius Insights for CData Sync are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Flexible and Easy to Use: Users have found that CData Sync software is flexible and easy to use, allowing for quick and fast data processing and manipulation. Several reviewers have mentioned this as a major advantage of the software.
Handle UPSERT Operations with Zero Code: The ability of CData Sync to handle UPSERT operations with zero code has been highly appreciated by users. This feature saves time in ETL developments, according to multiple reviewers.
User-Friendly Syncing Process: Users find it easy to set up the syncing process between multiple connections using CData Sync. They appreciate that technical knowledge or coding is not required, making the syncing process user-friendly. Several reviewers have praised this aspect of the software.
We are using CData Sync as a first stage to bring data for our DWH (Data Warehouse). That solve the problem that we need a quick upsert of our data. Our scope is mainly for Ads data from Faceboook Ads API
Pros
UPSERT
Friendly interface
Cons
Better support to Facebook Ads data
Zero service interruption with Facebook Ads data
Likelihood to Recommend
Well: Upsert Less: Critical data with no interruption of the service
VU
Verified User
Engineer in Information Technology (51-200 employees)
CData Sync is the automated data replication software used across different operational teams in my organization, for synchronization and replication. In previous years, we had issues with connecting to some destination databases when working with B2B companies and MNCs (Multinational Corporations). However, the software CData is an effective tool that has liberated our data replication from failed attempts, giving us successful enterprise and organizational data replicate to on-premise and cloud base databases. We use CData Sync on supported integrations as; DB2, MySQL, SQL server, and also snowflake - CData Sync complements well with these domains. We have expanded use when dealing with 10 or more sources.
Pros
Effortless use of no-code interfaces on data pipelining on.
High demand numbers of sources and destinations.
Works with even snowflake, with no error occurrence.
It uses ETL - (Extract / Transfer / Load).
It enhances data extraction and database support.
Cons
Although efficient for SQL servers and MySQL, as well as Snowflake. It is not strong for other database engines, and an upgrade on this would do a lot.
The installation process is manual as opposed to the cloud installation it should be.
A feature of syncing auto increment ID key, that will help in existing data management.
Likelihood to Recommend
Evidently, CData Sync is an excellent middleware tool that is perfect for syncing data between systems. It is especially suitable and works well on SQL servers, DB2, MySQL, and Snowflake, and some of their brothering domains. However, it is a limitation in working with Sage 50 API. But if it is extracted with ODBC, it works well.