CData Sync vs. Oracle Data Integration Platform Cloud (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

For daily transactional information and customer data needs it has been an extremely fast and reliable system. Several thousand users are able to connect many third party tools and run a large number of extracts while still experiencing great performance. For smaller systems in use with limited user accounts this system is less appropriate due to maintenance resources required.

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

• ODI uses ELT architecture, which enhances the load performance and is very scalable.
• ODI is platform independent. It supports all platforms, hardware and operating systems.
• It comes with pre-built integration, allowing immediate data replication, transformation, and data governance while ensuring data quality.

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

• Training and ramping up to learn all the Oracle specific intricacies.
• Security concerns with administering some of the tools to end users.

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

We are longtime ODI on-premise users. So, it was easy for us to migrate to the ODI cloud rather than implementing another solution.

Incentivized

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

Incentivized

• Ability to setup reliable disaster recovery.
• Upgrades and performance monitoring tools are readily available.

Incentivized