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."I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It's a complete package, which is why we use this solution."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The technical support for Informatica PowerCenter is good."
"Deployment was simple and straightforward."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"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."
"It's great for consolidation and creating one source of truth."
"The solution is user-friendly."
"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."
"It has the best feature for data augmentation."
"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 AI/ML enablement is useful, as many reporting tools do not offer machine learning models as of now, without writing customized code."
"Oracle Analytics Cloud's most valuable feature is its visualization."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Integration with Artificial Intelligence would benefit this solution."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The product could benefit from increased flexibility compared to other vendors."
"It is less scalable than Snowflake."
"When you implement the product on a small scale, it doesn't generate any ROI."
"The interfaces could be improved and some in-memory operations could be built in."
"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."
"Sharing dataflows is not possible at this time, and the custom chart functionality is not available."
"The product should be improved in terms of connectors; right now the top twenty connectors are available, but OneDrive and Teradata are missing."
"The solution could be more flexible."
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.