We performed a comparison between Informatica PowerCenter and Oracle Big Data SQL based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."The ability to scale through partitions helped us to improve the performance."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"The technical support is excellent."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"Good product if you are trying implement data quality, data integration, and data management projects."
"PowerCenter performs well during data transformation and optimization."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"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."
"The UI is a little outdated."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"Lacks ability to calculate cost of the product."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Integrating new tools can be tricky and challenging."
"I would like to see an improvement in the digital adoption."
"There is room for improvement in the pricing."
"The solution could improve by adding more advanced features."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Big Data SQL is ranked 17th in Cloud Data Integration with 2 reviews. Informatica PowerCenter is rated 8.0, while Oracle Big Data SQL is rated 8.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Oracle Big Data SQL writes "Offers good scalability, strong stability and seamless integration ". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Oracle Big Data SQL is most compared with Palantir Foundry and Oracle Data Integrator (ODI).
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.