No more typing reviews! Try our Samantha, our new voice AI agent.

Informatica PowerCenter vs Oracle Data Integrator Cloud Service comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Integration (4th), Data Visualization (13th)
Oracle Data Integrator Clou...
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (31st)
 

Featured Reviews

Hemanthreddy Vakiti - PeerSpot reviewer
Data Engineer at a tech vendor with 10,001+ employees
Streamlined daily sales workflows have reduced team size and enabled earlier, accurate reporting
One of the best features I appreciate about Informatica PowerCenter is that anyone with minimal knowledge of ETL can easily use it. It has four different interfaces: Monitor, Repository, Designer, and Workflow Manager. With our use case, we can easily go to that particular interface and use it. Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload. Informatica PowerCenter has positively impacted my organization because, as I mentioned previously, the development team has been reduced to half since we moved to it due to its easy interface and the reusability of Mapplets. It has also saved us a lot of time; for example, it has saved nearly one hour per day on monitoring and workflow tasks. Saving one hour a day is key because it has led us to report the data to business users one hour earlier than the usual time. If there are any anomalies or defects in the data, we can easily rectify them within that hour, which reduces the chance of errors in the data. Regarding cost, the number of people working on the project has been reduced to half, thus significantly decreasing costs for our organization since we moved to Informatica PowerCenter.
AD
Senior Solution Architect at a financial services firm with 10,001+ employees
A well-established product that meets all our specifications in terms of usability
In the initial stage when we went with Data Integrator Cloud Service it was primarily the nativity factor that was key for us. Having a single vendor supporting the entire suite of applications, and the ability to configure activities and direct integration with various other Oracle products, were the main attractive features within ODI. This is a well-established product that's good to have if you hold an Oracle suite of applications. It meets all our specifications in terms of usability.

Quotes from Members

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

Pros

"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline."
"The solution is stable."
"It's quite suitable for our needs."
"In summary, this is a good tool and I definitely recommend it."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"I like the completeness of the way I can build ETL workflows; it's not one feature that stands out, rather it's the way everything is working together."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"Having a single vendor supporting the entire suite of applications."
"This is a well-established product that's good to have if you hold an Oracle suite of applications."
"It's on the cloud, so it's scalable and quite easy to work with."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"Oracle integration cloud has got the adapters for all their products, which makes the integration a little faster and makes it easier to implement the integration quickly."
"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."
"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."
 

Cons

"With all these no code/low code platforms, Informatica still forces us to use the ANSI format of SQL for joins, especially left outer join."
"The solution does not scale."
"Improvement is needed in terms of some new transformation because API integration and all those things are very critical nowadays."
"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."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"I would like to see the inclusion of a tool that allows you to report performance metrics."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"As all ETL tools in general, it does not include a good data reporting feature."
"This is an expensive solution compared to other products on the market."
"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."
"Licensing costs for this Oracle solution are expensive. ODI forms an integral part of the overall PaaS solution and becomes a kind of backbone for that particular service, which is painful because from a PaaS perspective, the licensing costs just shoot off the roof."
"The pricing could be more competitive."
"The solution could be improved when it comes to bulk uploading; there are problems with it when you hit the upper limit."
"I've found technical support not very effective. They should work to improve their services."
"The solution is expensive."
"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."
 

Pricing and Cost Advice

"A basic setup can be from $100,000 and up annually."
"The license model is CPU based."
"Cost could be improved."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"The price of this solution is high."
"The price could be better. It's very expensive. On a scale from one to five, I would give Informatica PowerCenter's price a one."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"Its maintenance is expensive."
"The price is competitive compared to Boomi which is much higher."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
922,921 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
16%
Manufacturing Company
9%
Outsourcing Company
8%
Construction Company
6%
Outsourcing Company
24%
Construction Company
11%
Comms Service Provider
11%
Financial Services Firm
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
By reviewers
Company SizeCount
Small Business3
Large Enterprise4
 

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...
Ask a question
Earn 20 points
 

Also Known As

PowerCenter
No data available
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Amplifon
Find out what your peers are saying about Amazon Web Services (AWS), SnapLogic, Informatica and others in Cloud Data Integration. Updated: October 2026.
922,921 professionals have used our research since 2012.