We performed a comparison between Informatica PowerCenter and Oracle Data Integrator ODI based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: The two solutions received similar ratings. However, users of Informatica PowerCenter report a better experience with technical support.
"It reduces a lot of legacy coding."
"We have found the PowerCenter and B2B data transformation most valuable."
"It is UI friendly and has all the advantages of an ETL tool."
"Informatica PowerCenter is a very good ETL tool."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"Can manage a huge quantity of data and provide reliability."
"It has a Data Catalog that uses the Model repository."
"It has the ability to easily load slowly changing dimensions."
"It is an ETL tool, which does the extract, transform, and load."
"The scalability is great. It's one of the reasons we chose the solution."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"The product has an ELT approach."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"I would like to see it be able to import data from NoSQL."
"The initial setup is not straightforward. You need expertise to do it."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Oracle support services are not up to the mark."
"Reverse engineering is complicated and challenging to manage."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"We used a third party to do the implementation of ODI."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The performance of the user interface is in need of improvement."
Informatica PowerCenter is ranked 3rd in Data Integration with 80 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 reviews. Informatica PowerCenter is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". 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 PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Informatica PowerExchange, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Azure Data Factory, Oracle GoldenGate and Talend Open Studio. See our Informatica PowerCenter 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.