TrustRadius: an HG Insights company

CData Sync

Score7 out of 10

2 Reviews and Ratings

Get a Demo

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

Key Features

Learn about the best (and worst!) features CData Sync has to offer, as determined by TrustRadius' reviewers.
Based on 2 ratings of CData Sync's features
View all features

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.8

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 7.2

Areas for Improvement

Reviews

What users are saying about CData Sync.
View all reviews

CData Sync Review

Incentivized
Verified User
Engineer in Information Technology (51-200 employees employees)

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.

Incentivized
Jamie SmithView profile
Chief Computer Analyst and Product Manager in Information Technology at RSA Security (1001-5000 employees employees)

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