CData Sync Enterprise - CDC Replication for Cloud and On-Prem Data

The main use case is that the stack is MongoDB, with the main data source from Mongo. CData Sync comes as a third party that is layered on Mongo.

Power BI is directly connected to CData Sync, so we can stream the data from Mongo and visualize it.

The other unique thing about our use case is that aside from streaming live transactional data for informed decisions, we are in multiple markets at the moment in several African countries. This has been challenging because streaming data for different currencies and different local currencies, then accumulating everything in USD, makes everything look muddled up. However, it has been good with CData Sync since we can have everything in one currency.

The beautiful thing about CData Sync is that you can preview the data directly on their UI. The data that is settled in the database can be previewed on CData Sync before actually ingesting it into the BI tool.

That is one feature I appreciate. You can actually pick a particular column or drop a particular column. CData Sync's preview feature speeds up my workflow because at that layer of preview, I already know what I want into my pipeline and what I don't want. The SQL query at that level would also help to filter whatever I don't want.

There are times when you are streaming and trying to connect that CData Sync fails. However, the team has been very helpful. There is a particular technical support person that has usually come to my aid whenever there are issues. For improvement, I think the turnaround time for support can increase, especially on weekends.

I want to discuss the security of CData Sync. It is not something I actually have visibility to, but I think if CData Sync could give users the opportunity to put their own security layer on this, that would be beneficial. If CData Sync is compromised, who do we hold responsible? So security is an area for improvement.

CData Sync's interface is good. For integration with other tools, I think CData Sync could do well by integrating with other providers, especially AI agents so that one can easily integrate CData Sync to more agents out there.

I have been using CData Sync for about four months.

CData Sync is stable. Our transactional data is not a lot so far, so I can say CData Sync is stable.

For CData Sync data scalability regarding the increasing amount of data, our data is not a lot right now, so I think CData Sync handles it perfectly. Maybe later when transactional data grows significantly, we might be able to ask for better plans, especially regarding a scalable plan.

Customer support is great. Sonja is a great helper. Technical support from David has been helpful. I can tell you that CData Sync is stable and their customer support is trying.

For customer support at CData Sync, I would give them an eight. I would not give them a ten because on weekends the reply is slow. Another thing I thought about is they need to consider users that are not in their region. I think it is a time difference issue.

I did not purchase CData Sync through the AWS Marketplace. I saw CData Sync's ad on LinkedIn. I then reached out to a particular agent. That agent put me through their customer support team. That agent sent me an email and copied their team members. Since then, we have been discussing.

We had been doing everything manually. We saw that the manual way was not scalable. We then had to go the automation route.

I think the startup cost is fine for us.

I was able to integrate CData Sync easily with the help of CData Sync's technical staff.

Money has been saved with CData Sync. If we had gone through the route of a larger engineering effort for our pipeline, we would have spent more. In spending more, we might also have needed to employ a data engineer. So we have saved money on the technical side and on the staffing side. As an analyst, I was able to handle the integration.

For startup cost, I think it is still fair. Although we are a startup with a lean budget, if the startup cost was expensive, we might not have considered CData Sync at all.

We thought about using Zapier or other automation tools. We could have automatically used Selenium to download and scrape web pages and then store them in Google Drive. That is how we did it before.

I gave CData Sync a rating of seven because I have weighed the downsides and the upsides. CData Sync is solving my use case and I am able to use it, which already puts it past five. The usefulness and the simplicity in the technicality are things I also love about CData Sync, so that adds one to the five, making six. Looking at everything overall, including the support, the cost, and everything else, that makes it seven. I think seven is a good rating for me.

Private Cloud

Amazon Web Services (AWS)

What do you like best about the product?

ease of use and compatibility with multiple platforms

What do you dislike about the product?

pricing model has jumped over the years.

What problems is the product solving and how is that benefiting you?

need to sync our cloud data locally to keep our apps running efficiently

What do you like best about the product?

The most helpful thing is that easy access and Data backup

What do you dislike about the product?

There are performance issues when it has larger volume of data

What problems is the product solving and how is that benefiting you?

As it has larger data pool it will be useful when when don't have resources

What do you like best about the product?

I like Cdata Sync's massive data integration with more than 200+ sources in a database.

What do you dislike about the product?

The description in Cdata Sync could be simplified to make it more accessible to non-technical users which helps non-IT people to understand it more easily.

What problems is the product solving and how is that benefiting you?

Cdata Sync will simplify operational data management by automating the data replication process. This doesn't need to manual intervention to check the complex code for the data loading.

What do you like best about the product?

I can use it with many platforms symplifying reports and their analysis.

What do you dislike about the product?

Very heavy with the resources it uses, making it difficult to use with large data transfers.

What problems is the product solving and how is that benefiting you?

Centralizes databases measuring the impact of my marketing campaigns and providing valuable insights that I later use to funnel my decisions.

What do you like best about the product?

I have experience with many of their products. For the most part, they deliver on what they advertise from a functionality perspective. They are generally easy to use.

What do you dislike about the product?

Beware of pricing and contract negotiations. They hook you the first year with a reasonable price that goes up exponentially every year thereafter. We are seeing product price increases of 100 to 150% year over year.

What problems is the product solving and how is that benefiting you?

Data connectivity to various data sources.

What do you like best about the product?

CDATA has a large number of tools and plugins that facilitate the process for data processing and manipulation.

What do you dislike about the product?

The prices of the plugins are quite high, they do not allow small companies to take advantage of the potential that each of their tools has.

What problems is the product solving and how is that benefiting you?

Through the components for SAP, it allows queries to be carried out in a much simpler way during the preparation and transformation in the ETL processes.

What do you like best about the product?

I liked ETL automation that provides various integration like APIs and application with high good performance

What do you dislike about the product?

Till I have not found any bug and issue during my work

What problems is the product solving and how is that benefiting you?

It is very beneficial for me. It is a good fit for business that need to transfer data between multiple systems, and provides a user-friendly interface that makes it easy to set up and manage synchronization processes.

What do you like best about the product?

Support is more efficient, In my previous experience the support didn't fix the issue

What do you dislike about the product?

That the interface allows sorting the Jobs by Folders/Custom Category

What problems is the product solving and how is that benefiting you?

Replica DB for Reporting Purposes

What do you like best about the product?

It's easy to set up the syncing process between multiple connections. Also, not much technical knowledge is needed, and no coding required so the syncing process can be quite user friendly.

What do you dislike about the product?

The security of the platform is not very high. It is still using traditional username and password login, with no ability to set up different login to the admin portal and no SSO support.

What problems is the product solving and how is that benefiting you?

It simplifies the process of syncing data between various systems. Traditionally, doing so means having to export data from one system, modify them to be compatible and then importing back to other systems, which is difficult and time consuming. CData Sync makes it straightforward and totally opaque to end users like me.