CData Sync vs. CTERA Edge X Series (discontinued)

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.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

This is all about the selling you a "Device" and prices vary greatly between resellers. The devices work well, but the pure cloud solutions need a lot of work.

• UPSERT
• Friendly interface

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Standard File Backup

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

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• SQL Backups just don't work reliably. For us, we lost all of our SQL data backed up through the CTERA Application process. Although the logs indicated a success, that was really not the case. This came close to putting us out of business. Luckily I had taken a genuine SQL backup to a folder. Unfortunately it was a month old. We had to pick-up the pieces from there.
• Don't use it for file sync and share. There are better products out there i.e. anchorworks.com
• Support sucks. Good luck with response time and answers that are inconsistent between team members. For example I had to rebuild a VM from scratch. When I re-installed the CTERA client It obviously thought I was adding another device. When I inquired to tech support, one member said "copy the old Data folder" (I still had the old VHD. That did not work). The other directed me to the correct spot to just change the associated folder. The turn-around time was over 24 hours for this simple fix.
• Documentation, plenty of fodder but no real tech there.

It is easy to setup and use

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Tableau is another similar software tool, unlike CData Sync, rather transforms data into actionable insights. While CData Sync works with automation, Tableau uses a drag box on its AVA, which in turn slows the work speed on the syncing of data. Over the years, I enjoyed the friendly and customizable option of CData Sync over Tableau's.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Unfortunately CTERA does not stack up well if you want a pure cloud BDR. I have use iDrive and Asigra. iDrive has similar support and SQL backup issues. Asigra can vary widely in support and price, but the software is solid.

• Positive: Easy way to bring data for our DWH
• Negative: Frequent issue in CData Sync Server

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• NONE, it about put us out of business