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.
N/A
SnapLogic
Score 7.1 out of 10
N/A
SnapLogic is a cloud integration platform with a self-service capacity supported by over 450 prebuilt modifiable connectors. SnapLogic also offers real-time and batch integration processes for interfacing with external data sources, a drag-and-drop interface, and use of the vendors’ Iris AI.
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.
Snaplogic is unique from other IPASS tools if you're very sensitive about data security as they have an on-premise option where your data never needs to leave your data center. And data pipelines can be quickly created if Snaplogic has the requisite connector to your data sources. On the downside, if you're transforming a large amount of data for example in training machine learning models, a tool with elastic compute capability is more appropriate.
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.
This has been hands down the BEST software company I have ever used and dealt with. I am a 25 year IT veteran at this college. They go above and beyond in soliciting our feedback/input and proactively follow up about bugs, issues, etc. I have given multiple potential clients my thoughts and after seeing the SL demo they all sign up. I appreciate their support model, it's REFRESHING!
They can be prompt but they have not been as useful as I've wanted. We had a bug that affected many of our customers through an API connection between SnapLogic and our platform. Eventually they were able to figure it out, but it took a long time of negotiating between our engineering team and theirs. Additionally, we installed the SnapLogic groundplex for our customers and we've run into a bunch of problems of connectivity. If SnapLogic offered to be on those calls with our clients to troubleshoot how to fix these problems, I would give them a better grade here.
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.
We opted for SnapLogic due its ease of use and the flexibility it offers, it was the platform that was strongest in both application integration and data integration and both were use cases we wanted to be able to cover.