CData Sync

RATING:

4.1

(16)

About CData Sync

CData Sync is a data warehouse management platform that helps businesses create and maintain a replicate of cloud data to any database. The application supports various databases such as SQL Server, MySQL, DB2, Mongo, Cassandra, Redshift, S3, Snowflake, BigQuery and more. Features of CData Sync include reporting, data capture and transfer, data extraction, analytics, transaction monitoring, archive and more. Professionals can use the application to schedule data backups by setting up replication intervals. Additionally, it lets administrators manage full and partial replication scenarios and store critical data in a centralized repository. CData Sync facilitates integration with various third-party applications such as HubSpot, Sage Intacct, QuickBooks Online, Microso...

CData Sync Pricing

Starting price: 

$3,999.00 per year

Free trial: 

Available

Free version: 

Not Available

CData Sync data set creation

CData Sync Reviews

Overall Rating

4.1

Ratings Breakdown

Secondary Ratings

Ease-of-use

4.5

Customer Support

4.5

Value for money

4

Functionality

4

Most Helpful Reviews for CData Sync

1 - 5 of 13 Reviews

User Profile

Iain

Verified reviewer

Consumer Services, 2-10 employees

Used daily for less than 12 months

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

4

Reviewed July 2020

Simple & effective way to load data into our Azure SQL data warehouse

It's a powerful data load tool for organisations that don't want more complicated ETL tools. Customer service is great and I recommend CData Sync.

PROS

CData sync has proved itself to be a simple & reliable tool for loading data into Azure SQL. It has got a lot of flexibility in terms of how and when the data is loaded. It supports incremental loads. It's powerful and simple at the same time

CONS

We wanted to use the Sage50 UK integration but the driver does not expose all the data we needed. I think that is more a limitation of the Sage50 UK API. We now extract our Sage50 UK data with ODBC and then run an incremental load using CData Sync every 15 minutes. It works well.

Brig

Computer Software, 51-200 employees

Used daily for less than 12 months

Review Source: Capterra

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed May 2020

Intuitive, intelligent, powerful.

I've only had positive experiences with the product and company - these guys stand behind what they do.

PROS

This application is incredible. I used to think that syncing a cloud-based application into a local SQL server had to be addressed on a case by case basis. Then I found CData, which allows you to set up connections from multiple popular data sources to various destinations in a flexible and intuitive manner. Selecting tables/fields, scheduling sync jobs, etc. - all of it is very easy! Our needs are limited to syncing a few sources into a local SQL server database, primarily so we can report on it using Tableau. However, the application allows for many more data sources and destinations than we are using. It's clear the product team has made great strides for their app to meet the needs of many. Additionally, the support team is fantastic. They are not only knowledgeable and helpful, but the company has been shown to be very customer-centric by mobilizing development resources as needed to meet our needs through updates to the application on multiple occasions. If you are looking for middleware to sync data between systems - look no further!

CONS

The application is locally installed on a machine, as opposed to being cloud-based. Would be nice to access it from anywhere. That said, this hasn't ever really been a hindrance. We have it installed on a server machine which I can remote access from various workstations.

Reason for choosing CData Sync

I don't recall all of the details, but the other products were ruled out pretty quickly in comparison. CData just seemed so intuitive.

Ravinder

Health, Wellness and Fitness, 10,000+ employees

Used daily for more than 2 years

Review Source: Capterra

OVERALL RATING:

3

EASE OF USE

4

VALUE FOR MONEY

1

CUSTOMER SUPPORT

1

FUNCTIONALITY

3

Reviewed August 2023

Cross platform data transfer becomes easy

Not happy with the support.Not happy with bugs on SQL, snowflake and Postgres integrations. Same platform data sync works great but struggles with cross platform sync

PROS

Incremental methodology works great if the table has PK and a record modified date

CONS

Syncing to snowflake is a challenge for us. Buggy, We were unable to handle the data move in and out to snowflake. Support is not great in fixing the issue. Response time too long.All date columns are messed up, it adds/removes hours arbitralali

John

Construction, 501-1,000 employees

Used daily for more than 2 years

Review Source: Capterra

OVERALL RATING:

4

EASE OF USE

4

FUNCTIONALITY

4

Reviewed October 2023

Facilitates Access to CRM in SQL Server

We use this every day, and it's very helpful to have data in SQL Server for business critical reporting

PROS

Better than SSIS, copy and paste SQL Statements

CONS

Some issues encountered with upgrades. Would like a better status dashboard

Reasons for switching to CData Sync

More simple to maintain

William

Consumer Goods, 51-200 employees

Used daily for less than 12 months

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

4

Reviewed June 2020

Simple to use and very powerful for building your data warehouse

Before decided to go with CData Sycn I spent 6 months to trial on many different options and tools. Taking into accounts cost and maintenance, CData Sycn provided the most effective way to bring the Saas database into our on premises Data Warehouse. Setting up trail is very easy as well, you have access to the full feature but limited number of rows to proof the concept.

PROS

We use this bring multiple Saas database into our on premises data warehouse (SQL Server). This software is so powerful and easy to use. It does not require deep technical knowledge on how to deploy this. The support team was very helpful during deployment. The documentation of this software is very comprehensive.

CONS

The only downside to this is for all the connectors I setup there is no increamental upload which will make the data sync so much more efficient. having to sync the entire table can take a while especially once database grow biggest over the years. I hope CData Sync developer team will bring this feature soon!!