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."The scalability is excellent."
"The user interface and user experience are perfectly all right."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"Provides a significant amount of control over the landscape and overall implementation."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"Mainstream integration and real-time integration are the best features."
"The product’s flexibility is valuable."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It has the ability to easily load slowly changing dimensions."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Integration with the largest number of databases and other systems would be important."
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The product's high costs can be an area of concern where improvements are required."
"The product is not suitable for application integration."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"Should diversify more, maybe with a reporting and visualization utility,"
"The stability of the software could be improved. Sometimes, the software just crashes. "
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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."
"It needs easier security."
"The resource management aspect of the solution could be improved."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The initial setup is complex, especially if you also have to install a console."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Informatica PowerExchange is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica PowerExchange writes "Comprehensive, capable of handling large volumes, and helpful for fast-paced movement of data". 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, Qlik Replicate, Azure Data Factory and Informatica Cloud Data Integration, 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.