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."Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It's very easy to use it to develop mappings and workflows."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"Deployment was simple and straightforward."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"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 solution could have better documentation on basic steps or blocks that specify what to do."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"Integrating new tools can be tricky and challenging."
"The pricing could be improved."
"The solution does not scale."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"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.