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."Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"I like the completeness of the way I can build ETL workflows."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"Informatica PowerCenter is a very good ETL tool."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"Can manage a huge quantity of data and provide reliability."
"It's really an enterprise solution. It has a dashboard, like standard dashboarding functionality. It also has reporting capabilities for producing pixel-perfect reports, bursting large volumes of a document if you need to. It has interactive data discovery functionality, which you would use to explore your data, bring your own data, and merge it with maybe the data from an enterprise data warehouse to get new insights from the pre-existing data. It has machine learning embedded in the solution. If you're new to machine learning, it's a really good way to get into it, because it's all within this platform, and it's really easy to use."
"The product is easily customized."
"It plays a crucial role in facilitating decision-making for various organizational stakeholders."
"The technical support is excellent, and they respond quickly."
"The most valuable features of the solution are dashboarding and data visualization."
"The best feature may be data flow, which is used to prepare and clean data."
"A valuable feature is the speed of the solution."
"It's valuable feature is that it is user-friendly and doesn't require much time for understanding. The solution is stable. The initial setup was straightforward."
"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."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Requires an established data center because there is no option for software as a service."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"It should be more cloud-centric than on-prem-centric."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"There is some room for improvement in terms of pricing."
"Analytics Cloud allows you to merge various data types and structure data from multiple sources."
"The product could benefit from increased flexibility compared to other vendors."
"The solution could be more flexible."
"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."
"One area of improvement is associated with more connectors needing to be added such as Microsoft OneDrive, Teradata and a few others. I think the list is limited to the top ones now."
"As with most BI tools, the visualizations can be made much nicer. Currently, it has standard visualizations. They've been adding new visualizations, but we see animated visualizations from other vendors. It would be nice to have similar visualizations, such as the swarming visualizations, which are fairly new and very popular at the moment. I haven't seen that with Oracle. That would be nice."
"The product should improve its user interface. It should be welcoming and modern. Developers should also find it easier to build data models. Oracle Analytics Cloud needs to have better visualizations and more options in the marketplace."
"They could improve the ease of developing the dashboard and interacting with it."
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.