Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs Oracle Integration Cloud Service comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica PowerCenter
Average Rating
8.0
Number of Reviews
80
Ranking in other categories
Data Integration (2nd), Data Visualization (8th)
Oracle Integration Cloud Se...
Average Rating
7.8
Number of Reviews
36
Ranking in other categories
Integration Platform as a Service (iPaaS) (3rd)
 

Mindshare comparison

Informatica PowerCenter and Oracle Integration Cloud Service aren’t in the same category and serve different purposes. Informatica PowerCenter is designed for Data Integration and holds a mindshare of 10.9%, up 10.1% compared to last year.
Oracle Integration Cloud Service, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 9.6% mindshare, down 11.2% since last year.
Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
Jul 4, 2023
A stable and reliable product that provides a variety of features for data integration
We use the product for everything that's possible in data integration. We have a data warehouse, and we load each stage. We use the product for data exchange and API services. We also use it to load data into cloud platforms and generate Customer Letters The reliability of the product and the way…
Divya Prakash - PeerSpot reviewer
Jun 15, 2023
An integration tool that is highly compatible and easy to maintain
Dealing with the large file sizes has occasionally been a challenge, though we have found workarounds. But dealing with large file sizes could be easy in integrations. I have also come across schema files where headers, footers, and bodies are there, but it's not a valid schema. None of the MSCAs are defined properly. In such cases, we have to think of multiple workarounds, such as splitting or merging. But this is a standard requirement for organizations, so custom solutions should be provided. There are cases when the systems don't expect additional MSCAs, or they expect headers, footers, or tags with different values. But this is not a proper XML. So if we are dealing with XML conversions, mapping, and integrations, we have to do some custom work. These are solutions that Oracle can provide.

Quotes from Members

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

Pros

"The product's initial setup phase is very easy."
"UI-based ability to create data mapping."
"It has good standard features for ETL development."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Has a good visual tool for data mapping."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The setup is straightforward."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"People are able to scale up, learn it quickly, and start delivering."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"In our customers' organizations, Oracle Integration Cloud Service mainly integrates their other applications with the Oracle Fusion stack. It's very handy in scenarios where they want to seamlessly maintain data flow between applications, with business tools and logic validations in place."
"It's easy to build an integration and make changes to it."
"We mainly use the solution's ICS component."
"The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding."
"Technical support responds quickly."
 

Cons

"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"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."
"I would like to see it be able to import data from NoSQL."
"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."
"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."
"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."
"The solution should improve its support."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"There is a payload size limit and we're unable to integrate some legacy applications."
"It has lengthy documentation, making the process of building applications more time-consuming."
"I have faced situations where the solution has gone down for five to seven minutes, which is an issue if it happens in the live production environment."
"The solution is expensive."
"Oracle needs to ensure that some of the most commonly used types of consumption or services are bundled—for every industry."
"Our client was quite concerned about the cost, which is something that could be reduced."
 

Pricing and Cost Advice

"The price of this solution is high."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"Its licensing is expensive in terms of scaling."
"I consider this to be an expensive product."
"The price is mostly reasonable."
"Cost could be improved."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"We are satisfied with the pricing."
"The price is cheaper than all other cloud integration providers."
"The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."
"It specifies how much data you use and how much storage you require, among other things."
"The price is fair."
"Its pricing is relatively lower than other vendors."
"The solution is less expensive than other products."
"In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."
"The price of Oracle Integration Cloud Service is reasonable to start with, but when you scale it becomes expensive."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,649 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
7%
Insurance Company
7%
Educational Organization
41%
Computer Software Company
9%
Financial Services Firm
7%
Manufacturing Company
5%
 

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 Integration Cloud Service?
Oracle Integration Cloud Service offers a lot of adaptors.
What is your experience regarding pricing and costs for Oracle Integration Cloud Service?
It is not really a high price for the value it gives. However, when you start doing the customization, it’s a bit expensive because I need to start provisioning other services before deployment. So...
 

Also Known As

PowerCenter
Oracle ICS
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Calix, Avaya, Land Lakes, Leader, PWC, Vale
Find out what your peers are saying about Informatica PowerCenter vs. Oracle Integration Cloud Service and other solutions. Updated: May 2023.
814,649 professionals have used our research since 2012.