CData Sync

Pros: easy to use to integrate apis and data services

Cons: nothing really, it is very easy to use......

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

Pros: Easy to integrate and setup, yeasy to use

Cons: uses a lot of RAM memory resources, the sync is unstable

Pros: It's a great tool when implementing new data pull since it has large number of Data Connectors ,Easy to use and Pull data in fraction of seconds.

Cons: It's completly slow when pulling Entire data set and Works well only for incremental loads.In few cases it is completly slow for lesser dataset.Logs capturing should give more infomation on Load Progress

Pros: Integration was seamless. The business owners at Open Text that use CData are very happy with how the product works

Cons: I am not aware of any missing product features

Pros: The Ability to integrate all APIs into our core DB system

Cons: Nothing so far, all current features meet our requirements

Pros: Easy to set up and run through testing !

Cons: Expensive, although you get a lot for the money.

Pros: Set it up once and requires minimal maintenance. Pricing based on the number of connections makes CData better than competitors.

Cons: It may be a QBO API issue, but we are not retrieving all the data we require. Support was helpful but did not resolve the issue

Pros: The product is very fast, provides a wide range of connectors, both as source and destination, and has top-notch user support.

Cons: For some more advanced features, concerning some connectors, such as incremental update, the documentation is not very up to date

Pros: The ease with which cdata sync connects to our platforms and recognizes entities is great!

Cons: The notifications regarding upgrades are not great.

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.

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!!

Pros: $8b

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.