We performed a comparison between Informatica PowerCenter and Oracle OBIEE based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"What I like the most is that we have to deal with less while writing the queries."
"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."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"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."
"Good interface, reasonable documentation."
"Good product if you are trying implement data quality, data integration, and data management projects."
"In terms of features, everything is good. It is also stable and scalable."
"It has helped to consolidate data and report on a single version of the truth."
"I have not personally used any such products related to this service, however based on the popular opinion, Microsoft Power BI is more popular. We have never switched from this software due to infrastructure and license related costs. However, my team acknowledges that the Power BI is much more enhanced and includes features that are easier to use, including its drag and drop features. I am not sure, if OBIEE has these features, due to lack of updated versions."
"Inter Process Communication."
"The solution has great reporting and forecasting capabilities."
"The technical support services are good."
"The most valuable feature of Oracle OBIEE is it's designed for Oracle. It works well in the Oracle environment and can sit on top of any application."
"Some of the dashboard capabilities are good. The dashboard capabilities that tell you what kind of reports are available and provide you a summary of the reports are valuable. It is easy to navigate and easy to download reports into Excel to utilize them."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"This product is going to decommission in the next couple of years."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"Its scalability can be improved. It is not scalable."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Particularly on the Cloud, a lot of functionality has yet to be ported."
"Oracle OBIEE could improve the visualizations, such as diagrams, charts, and graphical user interface. Other tools on the market have better graphical visualizations this Oracle OBIEE."
"It is not a good product for data visualization."
"Oracle products have a lot of complications...Oracle has a history of not really providing great support."
"If the data is large, the dashboard takes a really long time. So, based on the database, if you have around a million cost contacts, the load time is very low, and the dashboard fails."
"It could be more user-friendly. For example, the RPD layer could be more straightforward. From a user's point of view, the visualization, especially the graphs, are not as attractive when compared to other tools like QlikView and Qlik Sense."
"OBIEE doesn't have audit logs."
"The complexity of this product means that you need to have a technical team to develop the reports, although this is also true for products like Microsoft BI and Zoho."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle OBIEE is ranked 3rd in BI (Business Intelligence) Tools with 154 reviews. Informatica PowerCenter is rated 8.0, while Oracle OBIEE is rated 7.8. 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 OBIEE writes "A solution that is easily accessible, scalable and requires a straightforward initial setup process to get started". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Oracle OBIEE is most compared with Microsoft Power BI, SAP BusinessObjects Business Intelligence Platform, IBM Cognos, Tableau and Oracle Analytics Cloud.
We monitor all Data Integration 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.