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 product’s flexibility is valuable."
"Mainstream integration and real-time integration are the best features."
"The user interface and user experience are perfectly all right."
"I rate Informatica PowerExchange a ten out of ten."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"This product is easy to install and it can be done in a few hours."
"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 most valuable feature is connectivity to data sources."
"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 solution needs better integration with other tools."
"The major challenge associated with the tool is on the infrastructure side."
"One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"The product's high costs can be an area of concern where improvements are required."
"Technical support can be improved with respect to delays in ticket response time."
"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 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."
"There is room for improvement in the pricing."
"The solution could improve by adding more advanced features."
 

Pricing and Cost Advice

"The product is not very expensive."
"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."
"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 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 is a need to pay towards the licensing cost of the product. It is an expensive product."
Information not available
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
25%
Insurance Company
8%
Computer Software Company
8%
Government
8%
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: July 2025.
865,384 professionals have used our research since 2012.