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."The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"I like the automated scheduling feature."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"It's a complete package, which is why we use this solution."
"In the end, you have structured, proper data for use in an integrated BI solution."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The interface is very clean and clear."
"The AI/ML enablement is useful, as many reporting tools do not offer machine learning models as of now, without writing customized code."
"The ability to quickly search for and access relevant data is crucial."
"It plays a crucial role in facilitating decision-making for various organizational stakeholders."
"The features that I find to be the most valuable are the BAS (Business Analytics), the Narrate feature, and the auto-visualization."
"Data preparation is fantastic and fast. We were able to use multiple data sources and prepare the data quickly."
"The solution can scale."
"A valuable feature is the speed of the solution."
"This is a stable and scalable solution."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The initial setup is not straightforward. You need expertise to do it."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"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."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The solution does not scale."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"Support could be better."
"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."
"The solution could be more flexible."
"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 scalability has room for improvement."
"At this time, dataflows cannot be shared, but I think that this should be enhanced."
"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."
"Sharing dataflows is not possible at this time, and the custom chart functionality is not available."
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.