Compare Informatica PowerExchange vs. Oracle Data Integrator (ODI)

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Informatica PowerExchange vs. Oracle Data Integrator (ODI) and other solutions. Updated: January 2021.
456,719 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The data transformation is the solution's most valuable feature.""The most valuable feature is connectivity to data sources.""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.""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 user interface and user experience are perfectly all right.""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."

More Informatica PowerExchange Pros »

"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.""It's completely user-friendly.""The most valuable feature that we use is the Knowledge Modules.""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 scalability is great. It's one of the reasons we chose the solution."

More Oracle Data Integrator (ODI) Pros »

Cons
"The solution needs better integration with other tools.""Technical support can be improved with respect to delays in ticket response time.""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.""Integration with the largest number of databases and other systems would be important.""Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before.""Informatica is very expensive in all aspects, so the pricing is something that could be improved.""Should diversify more, maybe with a reporting and visualization utility,""I would like to have easier integration with cloud platforms."

More Informatica PowerExchange Cons »

"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons""Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.""The performance of the user interface is in need of improvement.""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.""The resource management aspect of the solution could be improved."

More Oracle Data Integrator (ODI) Cons »

Pricing and Cost Advice
Information Not Available
"We found that the cost compared to other integration tools is a little high, but the solution works great."

More Oracle Data Integrator (ODI) Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
456,719 professionals have used our research since 2012.
Questions from the Community
Top Answer: This product is easy to install and it can be done in a few hours.
Top Answer: With Informatica PowerExchange it's all about capacity. If you are increasing the processing power, you need to buy additional licenses. So, for example, if you have traffic to be integrated and you… more »
Top Answer: I would like to have easier integration with cloud platforms.
Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution. The other question is how up to date do you want your… more »
Top Answer: But I never had been a specialist in ODI since we focussed on OWB and possible DevOps enhancements, But together with IKAN we worked on migration projects from OWB to ODI with Databtech (i.e Angelo… more »
Ranking
12th
Views
4,833
Comparisons
4,206
Reviews
8
Average Words per Review
411
Rating
8.1
6th
Views
20,918
Comparisons
13,662
Reviews
9
Average Words per Review
555
Rating
8.7
Popular Comparisons
Compared 8% of the time.
Compared 14% of the time.
Also Known As
PowerExchange, ConnectorsODI
Learn
Informatica
Oracle
Overview

Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Offer
Learn more about Informatica PowerExchange
Learn more about Oracle Data Integrator (ODI)
Sample Customers
ACH Food, BNSF Railway Company, Illinois State UniversityGriffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Top Industries
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider12%
Financial Services Firm9%
Government7%
REVIEWERS
Financial Services Firm33%
Retailer10%
University10%
Hospitality Company10%
VISITORS READING REVIEWS
Computer Software Company47%
Comms Service Provider14%
Financial Services Firm5%
Retailer5%
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise13%
Large Enterprise63%
REVIEWERS
Small Business33%
Midsize Enterprise13%
Large Enterprise54%
Find out what your peers are saying about Informatica PowerExchange vs. Oracle Data Integrator (ODI) and other solutions. Updated: January 2021.
456,719 professionals have used our research since 2012.

Informatica PowerExchange is ranked 12th in Data Integration Tools with 8 reviews while Oracle Data Integrator (ODI) is ranked 6th in Data Integration Tools with 9 reviews. Informatica PowerExchange is rated 8.2, while Oracle Data Integrator (ODI) is rated 8.6. The top reviewer of Informatica PowerExchange writes "Offers data in real-time using CDC concepts but it should be more flexible ". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, SSIS, Qlik Replicate and Matillion ETL, whereas Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, Oracle Integration Cloud Service, SSIS, Oracle GoldenGate and IBM InfoSphere DataStage. See our Informatica PowerExchange vs. Oracle Data Integrator (ODI) report.

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools 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.