We performed a comparison between JumpMind SymmetricDS, Oracle Data Integrator (ODI), and TIBCO BusinessWorks based on real PeerSpot user reviews.
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication."It is fully featured. It has allowed me to do everything I wanted to do."
"It is an ETL tool, which does the extract, transform, and load."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The initial setup is easy."
"The CAEM is very useful in its modularity and portability."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"The most valuable feature is Data movement."
"The most valuable features are the stability and the time to market."
"I work in operations, so I value BusinessWorks' performance the most."
"XML to JSON transformations, out-of-the-box, helps to build REST services."
"The OSGI console is available to debug different issues and get low level informations on the applications development, like bundle, dependencies, etc."
"BusinessWorks reduces development time, helping developers to focus on business logic."
"The high availability, tolerance, and load balancing features are top-notch. Its scalability features are also pretty cool."
"It is a seamless and sophisticated tool."
"The Business Studio interface based on SCA Standards helps to show the business logic at first look and improve code maintenance."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"The initial setup is complex, especially if you also have to install a console."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It needs easier security."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"Scaling with the solution is costly because if we need to scale up, we have to buy more memory. That means more money. Solutions like Camel or Pulsar come with built-in options to scale horizontally, vertically, region-wide or country-wide."
"TIBCO BusinessWorks could be improved with cloud support."
"The communication protocols could be improved."
"This solution's cloud could be improved. I don't know whether it was because we didn't have the internal expertise or if it was the product itself, but since they came later—I think only two or three years into the cloud—after many other iPaaS that had been in the cloud for longer, I feel that maybe they haven't matured in terms of the cloud."
"The cost has room for improvement."
"The technical support's turnaround time is an area where TIBCO needs to consider improvements...Getting support from TIBCO on a particular issue takes a lot of turnaround time."
"Could be more user friendly in the development area."
"The Business Studio tool can be improved, which is the tool for designing the processes. Improving the Business Studio tool will make this solution more stable. It has a steep learning curve, and it is pretty tough to learn."