We performed a comparison between Informatica PowerExchange and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a scalable and versatile solution."
"The data transformation is the solution's most valuable feature."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"Provides a significant amount of control over the landscape and overall implementation."
"This product is easy to install and it can be done in a few hours."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"It is easy to integrate the solution with other tools."
"The scalability is excellent."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Besides loading data, we do most of our transformations in ODI."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"It has the ability to easily load slowly changing dimensions."
"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."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"The solution needs better integration with other tools."
"The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"Integration with the largest number of databases and other systems would be important."
"The connectivity with T24 core banking could be improved."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Pushdown optimization could be improved."
"We used a third party to do the implementation of ODI."
"Stability could be improved because some operators have issues."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"Oracle support services are not up to the mark."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
Informatica PowerExchange is ranked 20th in Data Integration with 19 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews. Informatica PowerExchange is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Informatica Cloud Data Integration, Qlik Replicate and Azure Data Factory, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate. See our Informatica PowerExchange vs. Oracle Data Integrator (ODI) report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.