We performed a comparison between Informatica PowerCenter, Jitterbit Harmony , and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has good standard features for ETL development."
"Has a good visual tool for data mapping."
"We can scale the product."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The number of docs has been reduced drastically, which is very good."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"The most valuable features are the metadata repository and the data warehouse application console."
"It is very easy to build integrations and processes to pull and push data."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It runs like an appliance and has tremendous throughput."
"The Cloud Console for monitoring and troubleshooting data operations."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It is a scalable solution."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"The scalability is great. It's one of the reasons we chose the solution."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"Besides loading data, we do most of our transformations in ODI."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"It is an ETL tool, which does the extract, transform, and load."
"The installation of the client ODI Studio is easy."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"This product is going to decommission in the next couple of years."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"There is some room for improvement in terms of pricing."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"The initial setup can be a little bit difficult."
"Its API management capabilities need improvement."
"I would like the ability to offer a dedicated cloud version for security."
"Looping through complex data structures can be difficult."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The initial setup is a bit complex compared to other tools."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"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 solution lacks some functions and features."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."