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."Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"I like the completeness of the way I can build ETL workflows."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"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 found the map links, work links, and workflows valuable. They are important features."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"The dashboard and analysis are the most valuable features of this solution."
"The security is good. For example, we can implement column-level security."
"The technical support services are good."
"It's the connectors, the adapters. Built in connectors with different ERPs, you can plug in XL, other sources of data. It's very easy to configure. It's very easy to use."
"It is easy to create a report quickly. It does not take much time to create an ad hoc report."
"The most valuable feature is the user-friendly set of tools that the customer can use to develop their own business dashboards."
"It has helped to consolidate data and report on a single version of the truth."
"The most valuable feature is the openness of the solution. It helps us integrate some of our clients."
"The initial setup is not straightforward. You need expertise to do it."
"The solution does not scale."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The licensing is difficult."
"The reputation of Informatica is that it is expensive."
"Support could be better."
"We needed some technical expertise during setup."
"This solution is weak in the data science perspective. I have past data science experience. And, I find that there is a lot of room for improvement in terms of incorporating more advanced statistical modeling into the product."
"BI Server"
"OBIEE doesn't have audit logs."
"One feature I would definitely like to see is the ability to provide the in-memory data. Oracle might have some plugins but, as of now, that feature isn't available out-of-the-box. You might have to purchase that feature."
"It should have more self-service capabilities."
"Warehouse and business intelligence are two different things, but OBIEE also has some warehouse features in it. I would like to see some of those capabilities improved."
"It would be better if it had a wide range of visualization options. For example, Microsoft Power BI has an extensive range of visualization options, but it's not available in OBIEE. There are also some conflicts because it's complicated, but the cloud application is easier. They added some features for ETL with the on-premises application, but we need a different or a separate application for ETL in the cloud. In the next release, I would like to have more AI features."
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.