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 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 would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"It has very good monitoring and process monitoring."
"I like the automated scheduling feature."
"The setup is straightforward."
"Informatica PowerCenter is a very good ETL tool."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It's robust. It has the ability to handle massive amounts. After reporting has been developed, there is an ease of use or a user-friendly interface for a trained workforce."
"It plays a crucial role in facilitating decision-making for various organizational stakeholders."
"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."
"Oracle Analytics Cloud's most valuable feature is its visualization."
"The technical support is excellent, and they respond quickly."
"The most valuable features of the solution are dashboarding and data visualization."
"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."
"Data preparation is fantastic and fast. We were able to use multiple data sources and prepare the data quickly."
"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."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"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."
"This product is going to decommission in the next couple of years."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"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."
"Oracle Analytics Cloud is lacking in charts. They should add more charts to it."
"The price of the solution could be lower."
"Sharing dataflows is not possible at this time, and the custom chart functionality is not available."
"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 product should be improved in terms of connectors; right now the top twenty connectors are available, but OneDrive and Teradata are missing."
"It should simplify data connectivity and modeling, making data extraction more streamlined and adaptable for diverse use cases."
Informatica PowerCenter is ranked 5th in Data Visualization with 78 reviews while Oracle Analytics Cloud is ranked 6th in Data Visualization with 25 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, Microsoft Power BI, Tableau 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.