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 (18th)
 

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

"The most valuable feature is connectivity to data sources."
"The user interface and user experience are perfectly all right."
"The data transformation is the solution's most valuable feature."
"In terms of the return on investment, the tool is very helpful in the digital transformation process since multiple systems are available."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"It is a scalable and versatile solution."
"It is easy to integrate the solution with other tools."
"Mainstream integration and real-time integration are the best features."
"This solution can maintain a large volume of data and is flexible to what data it can handle. The performance is very good."
"The user interface is really user-friendly and intuitive."
 

Cons

"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The major challenge associated with the tool is on the infrastructure side."
"The solution needs better integration with other tools."
"Technical support can be improved with respect to delays in ticket response time."
"I would like the stability to improve."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"Should diversify more, maybe with a reporting and visualization utility,"
"The solution could improve by adding more advanced features."
"There is room for improvement in the pricing."
 

Pricing and Cost Advice

"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."
"The product is not very expensive."
"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."
"There are licensing and connector costs. Basically, Informatica is pay-as-you-use."
"An annual package license fee is required."
"Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."
Information not available
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
869,566 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise3
Large Enterprise12
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: September 2025.
869,566 professionals have used our research since 2012.