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

Informatica PowerExchange vs Oracle Big Data SQL comparison

 

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 PowerExchange
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
23
Ranking in other categories
Data Integration (13th)
Oracle Big Data SQL
Average Rating
8.6
Reviews Sentiment
7.6
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (16th)
 

Featured Reviews

Mohammad Faizan Ahmad - PeerSpot reviewer
Helpful in handling areas like complex data sources and data processing but needs improved support services
The major challenge with the tool stems from the fact that if you are implementing it in the cloud, then it has to be within the framework. Another challenge is the large volume of data. Informatica PowerExchange is a product through which we enable connectivity, so it is not an application product or a stand-alone tool, but Informatica's core systems or IICS uses it to connect to multiple systems. The major challenge associated with the tool is on the infrastructure side. The tool's features could be something faster with more connectors. A number of connectors can help connect to a wide variety of applications. The tool should focus on reducing the resilient time, like, if any network disconnectivity happens, then auto-reconnection and the retry method should be more robust so that manual intervention is not required. We communicate with the tool's support team as we need to raise our issues with them. I have already worked with Informatica and have a total experience of around eight to nine years; the one problem with the tool is its support team since they take a lot of time to address a particular issue. If one time you schedule a call and explain the situation to them about the issue, the support team will raise tickets and take notes. They will ask you to share the logs or screenshots of the errors, and you will get no resolution. The support team will randomly give you some documents and expect you to go through them, and if you get back to them with questions, a new person will be allocated, and you will have to start explaining everything again. I would not say it is a pleasant experience.
Mohamed Moustafa - PeerSpot reviewer
Offers good scalability, strong stability and seamless integration
The user interface is really user-friendly and intuitive. It was a major plus. The integration process was smooth. Oracle's security is good and significantly better than that of other solutions I've encountered. Previously, we had separate data interfaces for 15 concrete mixing plants, requiring manual document creation in Oracle. Now, with integrated automation, production has become much easier and more efficient over the past three years.

Quotes from Members

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

Pros

"PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products."
"Mainstream integration and real-time integration are the best features."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The user interface and user experience are perfectly all right."
"This product is easy to install and it can be done in a few hours."
"The product’s flexibility is valuable."
"The user interface is really user-friendly and intuitive."
"This solution can maintain a large volume of data and is flexible to what data it can handle. The performance is very good."
 

Cons

"Should diversify more, maybe with a reporting and visualization utility,"
"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."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"Pushdown optimization could be improved."
"The solution needs better integration with other tools."
"The major challenge associated with the tool is on the infrastructure side."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The product's high costs can be an area of concern where improvements are required."
"The solution could improve by adding more advanced features."
"There is room for improvement in the pricing."
 

Pricing and Cost Advice

"An annual package license fee is required."
"There is a need to pay towards the licensing cost of the product. It is an expensive product."
"The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability."
"Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."
"The product is not very expensive."
"It's expensive. In fact, nobody would buy any product of Informatica if the price was the only consideration. It costs money, and it doesn't come cheap, but it provides value for money in many ways."
"There are licensing and connector costs. Basically, Informatica is pay-as-you-use."
Information not available
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
860,592 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Computer Software Company
10%
Government
7%
Insurance Company
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for Informatica PowerExchange?
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed, enabling re-utilization of existing channels, cutting down on development and training costs.
What needs improvement with Informatica PowerExchange?
It would be helpful to have more metadata provided, which is useful for engaging more users in data exchange. The addition of data quality dashboards or measures would also help in profiling data t...
What do you like most about Oracle Big Data SQL?
The user interface is really user-friendly and intuitive.
What needs improvement with Oracle Big Data SQL?
There is room for improvement in the pricing.
What is your primary use case for Oracle Big Data SQL?
With Oracle Big Data SQL, I primarily managed data organization and structure. It helped streamline data within the system. I integrated Oracle with other systems. I worked with Oracle integrations...
 

Also Known As

PowerExchange, Connectors
No data available
 

Overview

 

Sample Customers

ACH Food, BNSF Railway Company, Illinois State University
Information Not Available
Find out what your peers are saying about Informatica PowerExchange vs. Oracle Big Data SQL and other solutions. Updated: June 2025.
860,592 professionals have used our research since 2012.