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
22
Ranking in other categories
Data Integration (18th)
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

"The most valuable feature is connectivity to data sources."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"This product is easy to install and it can be done in a few hours."
"It is a scalable and versatile solution."
"The data transformation is the solution's most valuable feature."
"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."
"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."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"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

"Technical support can be improved with respect to delays in ticket response time."
"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."
"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."
"I would like to have easier integration with cloud platforms."
"The major challenge associated with the tool is on the infrastructure side."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"Pushdown optimization could be improved."
"I would like the stability to improve."
"The solution could improve by adding more advanced features."
"There is room for improvement in the pricing."
 

Pricing and Cost Advice

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

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Computer Software Company
12%
Insurance Company
9%
Government
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?
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services. Informatica is seen as broader in integrations.
What needs improvement with Informatica PowerExchange?
I have minimal exposure to PowerExchange at this point. I will start working with it midyear, so I do not have much experience to suggest improvements.
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: April 2025.
847,646 professionals have used our research since 2012.