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.
"Good interface, reasonable documentation."
"Has a good visual tool for data mapping."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"Good product if you are trying implement data quality, data integration, and data management projects."
"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."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"Once you have learned Informatica, it is very easy to use."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"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 tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"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."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use 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."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"The licensing is difficult."
"The performance of Informatica PowerCenter could improve."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It needs easier security."
"The performance of the user interface is in need of improvement."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 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.