We performed a comparison between Informatica PowerCenter and Oracle Analytics Cloud based on real PeerSpot user reviews.
Find out in this report how the two Data Visualization solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."We can scale the product."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The interface is very clean and clear."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"Has a good visual tool for data mapping."
"What I like the most is that we have to deal with less while writing the queries."
"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."
"The product's initial setup phase is very easy."
"I've discovered that the new layout of this product makes Docker sharing, machine learning support, and data backups more efficient. Unlike the older method of linking physical, pre-logical, and presentation layers separately, the new interface simplifies this process. Additionally, the integration of databases and machine learning is seamless, with the new visualization approach being particularly beautiful and highly beneficial."
"The specific capability I find important in Oracle Analytics Cloud is that it allows the basic user to easily drag and drop data. I also like that the solution allows the user to decide what to measure and what to see in the reports."
"Oracle Analytics Cloud's most valuable feature is its visualization."
"The solution can scale."
"This is a stable and scalable solution."
"Mobility is the most valuable feature for us. All employees can access it from anywhere. It is a big advantage for us."
"It's great for consolidation and creating one source of truth."
"The features that I find to be the most valuable are the BAS (Business Analytics), the Narrate feature, and the auto-visualization."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"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."
"The product could benefit from increased flexibility compared to other vendors."
"It is less scalable than Snowflake."
"Its FAW feature has limitations in terms of usage."
"Analytics Cloud allows you to merge various data types and structure data from multiple sources."
"It is expensive."
"The migration of older dash tools from the classic interface of Oracle BI prior to OAS launch to the newer Data Visualization and Oracle Analytics Cloud interfaces, including dashboards and metadata, is currently a cumbersome process. Improvements in this area would be highly beneficial. Additionally, the administration of the cloud, particularly the startup of services and linking of the WebLogic server and integrated components, takes longer than desired. In today's enterprise landscape, waiting forty minutes for the server to be operational is quite lengthy; ideally, this process should take a maximum of four minutes. It would be excellent to incorporate metadata management as an integral part of the Oracle Analytics Cloud. When dealing with integrated data from various sources, tracking data lineage and the entire data life cycle, from sources to report development and the mapping of reports to specific dashboards, should be seamlessly managed within the Oracle Analytics Cloud. This would eliminate the need for additional tools. Drawing a comparison, tools like Tableau have a feature enabling metadata management, making it easier to trace the complete data lineage of reports. Managing over seven hundred and thirty-six business dashboards, the metadata management capability within Tableau simplified the process of understanding how reports were developed, including details like associated tables, users, linked views, materialized views, data segmentations, ETL jobs, and the data warehouse stages. Enhancing metadata tracking within the Oracle Analytics Cloud layout would facilitate easy and practical management of the complete data life cycle, encompassing user accessibility and report permissions."
"When you implement the product on a small scale, it doesn't generate any ROI."
"The price of the solution could be lower."
Informatica PowerCenter is ranked 5th in Data Visualization with 78 reviews while Oracle Analytics Cloud is ranked 6th in Data Visualization with 24 reviews. Informatica PowerCenter is rated 8.0, while Oracle Analytics Cloud is rated 8.0. 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 Analytics Cloud writes "Reliable, capable of handling massive amounts of data, and good value for money". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Oracle Analytics Cloud is most compared with Databricks, Oracle OBIEE, Tableau, Microsoft Power BI and Oracle Business Intelligence Cloud Service. See our Informatica PowerCenter vs. Oracle Analytics Cloud report.
See our list of best Data Visualization vendors.
We monitor all Data Visualization 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.