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."It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"It reduces a lot of legacy coding."
"Has a good visual tool for data mapping."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It has helped us monetize."
"It has very good monitoring and process monitoring."
"It is UI friendly and has all the advantages of an ETL tool."
"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."
"It has the best feature for data augmentation."
"The most valuable features of the solution are dashboarding and data visualization."
"Analytics Cloud allows you to merge various data types and structure data from multiple sources."
"The ability to quickly search for and access relevant data is crucial."
"The technical support services are good."
"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 plays a crucial role in facilitating decision-making for various organizational stakeholders."
"The pricing could be improved."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"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."
"Its scalability can be improved. It is not scalable."
"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."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"The performance of Informatica PowerCenter could improve."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"They could improve the ease of developing the dashboard and interacting with it."
"The interfaces could be improved and some in-memory operations could be built in."
"The learning curve should be improved, and I'm uncertain if tutorials are readily available or easily accessible. We may have resorted to looking on YouTube for such information. Having easily understandable documents or guides for new users would be beneficial. AI integration would be an interesting feature to add in the next release."
"The solution could be more flexible."
"The product should be improved in terms of connectors; right now the top twenty connectors are available, but OneDrive and Teradata are missing."
"When we have, for example, a table with low performance, we have several issues with drawing some graphics in the Oracle cloud."
"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."
"Analytics Cloud allows you to merge various data types and structure data from multiple sources."
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.