Informatica PowerCenter vs Oracle Data Integrator (ODI) comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 1, 2022
 

Categories and Ranking

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Number of Reviews
80
Ranking in other categories
Data Visualization (7th)
Oracle Data Integrator (ODI)
Ranking in Data Integration
5th
Average Rating
8.2
Number of Reviews
69
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2024, in the Data Integration category, the mindshare of Informatica PowerCenter is 11.9%, up from 10.5% compared to the previous year. The mindshare of Oracle Data Integrator (ODI) is 5.6%, up from 5.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
Unique Categories:
Data Visualization
0.8%
No other categories found
 

Featured Reviews

NM
Jan 24, 2022
Easy to scale and stable ETL solution with a straightforward setup; can integrate with both structured and semi-structured systems
We are using these solutions: Oracle Data Integrator with different versions, Informatica PowerCenter, Informatica Cloud Data Integration, and Talend. Matillion, we explored, but we don't use it for our company. We are a consulting partner. We are an implementation partner, so our consultants use these to implement solutions to many of our customers. We are an indirect partner through Oracle, and not a direct partner of Informatica. Informatica PowerCenter is deployed both ways: on-premises and on cloud, but on cloud very recently. In the past two years, we have been using the cloud version. Deployment for this solution could take one to two days, if the person doing it is knowledgeable. We have a team of 70 members who are data engineers and data analysts, but for the actual installation, setup, and configuration, we have another team made up of system/application administrators. We have a shared service model with 50+ associates who take care of this service. They will take a day or two to complete the deployment. Given all the infrastructure details available from the customer, it wouldn't take more than a day or two, worst case two days on average to set up and start the system, for it to be ready for working on and developing the ETL. To maintain this solution, in a shared service model, e.g. not dedicated, it requires two to three people, but if it is dedicated, then one person can handle the maintenance. There are two ways we are using this ETL solution. Number one: as part of Oracle's prepackaged solution, and number two: as an independent solution. I don't deal with the licensing, but as part of Oracle's pre-packaged analytics solutions, we did use them. There's a one-time fee plus yearly support. That is their model, but I don't know the costs associated. My advice to new customers of this solution is that if they are looking for an enterprise scale data warehouse and data management solution, Informatica PowerCenter is one of the go-to proven tools. Its limitations are on these two areas: one is that it needs to enable the cloud-based version to do batch processing, e.g. heavy data loads, and two is that it needs to enable connectivity to the NoSQL compliant and unstructured data sources. Keeping the two product limitations out, e.g. the cloud version has limitations for batch processing and is unable to process unstructured and semi-structured data, my rating for Informatica PowerCenter is an eight out of ten.
Muharrem Iseri - PeerSpot reviewer
Nov 25, 2022
Stable, scalable, has a straightforward setup, and offers good technical support, but its package needs some editing or upgrading
My advice to anyone looking into using Oracle Data Integrator (ODI) is that it's easy if you have experience with Oracle technologies. Still, if your experience is with other technologies, you may find Oracle Data Integrator (ODI) challenging. I'd rate Oracle Data Integrator (ODI) as seven out of ten because it's not as user-friendly as Informatica. It's not as cheap as Microsoft SSIS, but it's an Oracle product, and Oracle is well-known, so that you can search for information about Oracle products on Google. You can find support for Oracle products, so Oracle Data Integrator (ODI) is a seven for me. I'm an Oracle customer.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"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."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It reduces a lot of legacy coding."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The product's initial setup phase is very easy."
"Informatica PowerCenter is a very good ETL tool."
"The product has an ELT approach."
"It is an ETL tool, which does the extract, transform, and load."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The CAEM is very useful in its modularity and portability."
"The most valuable feature that we use is the Knowledge Modules."
 

Cons

"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."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"I would like to see it be able to import data from NoSQL."
"They should release new versions for the solution's on-premises setup."
"When I deal with very large amounts of data, there have been performance issues."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"It needs easier security."
"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."
"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."
"We used a third party to do the implementation of ODI."
"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."
"The resource management aspect of the solution could be improved."
"The solution lacks some functions and features."
"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."
 

Pricing and Cost Advice

"Cost could be improved."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
"We have a site license, but we do pay by the division."
"The licensing fees are paid on a yearly basis."
"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"Its licensing is expensive in terms of scaling."
"The solution is very expensive."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"ODI comes included when buying the cloud version of the Oracle database license."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
792,098 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
13%
Manufacturing Company
8%
Insurance Company
7%
Financial Services Firm
16%
Computer Software Company
14%
Government
8%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Data Integrator (ODI)?
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.
 

Also Known As

PowerCenter
ODI
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Informatica PowerCenter vs. Oracle Data Integrator (ODI) and other solutions. Updated: June 2024.
792,098 professionals have used our research since 2012.