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."The product's initial setup phase is very easy."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"Can manage a huge quantity of data and provide reliability."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The “Business Model & Mapping” layer in the Administration Tool, because the maintenance and evolution processes are greatly facilitated."
"The main features of this solution are that it is easy to use, intuitive, and user-friendly. When I retrieve the data from the database it is in a very raw form, then when I use the Oracle Report Builder it has advanced intelligence features to allow me to view and make changes to the data easily."
"It has a lot workaround in order to do the report. data blending, and getting information from big data sources."
"The primary reason for using OBIEE is connectivity with Oracle E-Business Suite. It makes it easy to connect with our Oracle E-Business Suite. There are the standard dashboards available, which we sometimes use, and now we are looking for customized dashboards."
"There are some great new features in the latest version."
"Oracle OBIEE is good for data visualization and analytical reporting."
"The most valuable feature is the visualization."
"It provides excellent stability."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"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."
"Implementation is cumbersome and requires expertise."
"There's a lot of redundancy, especially in relation to creating the code."
"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."
"The ability to migrate from one version to another, such as doing so from version 11 to an upgraded 12 of Oracle business environment, can be difficult."
"Oracle OBIEE is a product that is not easy to implement. The product is also not easy to use."
"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."
"For a beginner, this is a product that is difficult to learn. You cannot learn it quickly."
"It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market."
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.