#1 most frequent
United States of America
65.0%13 installations of 20
What is CData Sync?
CData's Sync is a data pipeline tool able to connect data sources to the user's database or data warehouse, supporting at present over 200 possible sources, and a range of destinations (e.g. Snowflake, S3, Redshift), connecting on-premise or SaaS sources and destinations.
Categories & Use Cases
Product Demos
Top Performing Features
Connect to traditional data sources
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Category average: 8.9
Collaboration
Collaboration is enabled by a shared repository of project information and metadata
Category average: 7.9
Testing and debugging
Tool to debug and tune for optimal performance
Category average: 7.2
Areas for Improvement
Who Buys & Uses CData Sync
#2 most frequent
Japan
10.0%2 installations of 20
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
10.0%2 installations of 20
CData Sync Review
Use Cases and Deployment Scope
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
Return on Investment
- Positive: Easy way to bring data for our DWH
- Negative: Frequent issue in CData Sync Server
Usability
Alternatives Considered
Hevo Data and Dataddo
Other Software Used
Hevo Data, Dataddo, Microsoft Power BI
A middleware that replicates & syncs, just as you want.
Use Cases and Deployment Scope
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.
Most Important Features
- Integer-based incremental check column.
- A syncing system that is log-based replication.
- Equipped with hard, soft, and skip delete systems.
- Variation in multiple-choice data types.
- Built-in REST API access
- The 250+ connection sources.
Return on Investment
- Reserves resources by covering human power via its automated sync method.
- Saves time: on launching data collectively into a compatible domain.
Alternatives Considered
Tableau CRM
Other Software Used
Tableau CRM, IBM SPSS, Sisense for Cloud Data Teams