CData Sync vs. IBM DataStage

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

Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.

Incentivized

• Effortless use of no-code interfaces on data pipelining on.
• High demand numbers of sources and destinations.
• Works with even snowflake, with no error occurrence.
• It uses ETL - (Extract / Transfer / Load).
• It enhances data extraction and database support.

Incentivized

• Very reliable in handling data extraction, data transformation and loading
• Flexibility in connecting to different type of databases, relational or non-relational
• Great features such as parallel processing, hash handling, etc.
• You can also take advantage of its FTP functions, and scheduling features if you need to.

Incentivized

• 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

• You must understand and know the algorithms, since the wrong use of them generates more time in processing.
• Metadata. You need to develop with connectors, and taking all the Metadata from the menu, all the data that you complete manually, you can't track it.

Incentivized

Because it is a flexible tool that can manage many flows and create a strong solution with a interesting use of variables. Easy to scale up as you can copy jobs arleady build and modify them. SQL queries allow to be fast in development and have the pushdown feature, but you loose a little of user friendly look. Metadata management is not strong as a visual feature, but can be determine by job codes.

Incentivized

It could load thousands of records in seconds. But in the Parallel version, you need to understand how to particionate the data. If you use the algorithms erroneously, or the functionalities that it gives for the parsing of data, the performance can fall drastically, even with few records. It is necessary to have people with experience to be able to determine which algorithm to use and understand why.

Incentivized

IBM offers different levels of support but in my experience being and IBM shop helps to get direct support from more knowledgeable technicians from IBM. Not sure on the cost of having this kind of support, but I know there's also general support and community blogs and websites on the Internet make it easy to troubleshoot issues whenever there's need for that.

Incentivized

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

No, it wasn’t my decision to use such an ETL product. I’m just the administrator at this point. I’ve heard there are other products there that are even on cloud support. That is much easier to use, more agile, and user-friendly. That doesn’t have that barrier from user to administrator to the developer standpoint.

• Reserves resources by covering human power via its automated sync method.
• Saves time: on launching data collectively into a compatible domain.

Incentivized

• Not directly related to ROI or cost figures. Only comment here is that IBM tools tend to be more costly than average ETL tools, but it depends on if the company is an IBM shop.
• One positive aspect is the company has had not a need to switch ETL tool for years.
• Upgrading to newer versions of the tool brings flexibility in the tool and up-to-date features in relation to other applications.

Incentivized