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."PowerCenter performs well during data transformation and optimization."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"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."
"Once you have learned Informatica, it is very easy to use."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"Good interface, reasonable documentation."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"In terms of features, everything is good. It is also stable and scalable."
"We do you use Oracle support. We've been paying for an Oracle support subscription for four or five years, and not one ticket has ever been logged. When I came in, I've encouraged the team to ask Oracle questions. They do get back quite quickly. Their support is good. Working with our account managers, if I need to escalate anything, I can speak to them and they escalate the call. I've got that ecosystem working quite well. That does work for us."
"The most valuable feature of Oracle OBIEE is interactive reporting because it allows better analysis versus conventional reporting, especially on the data warehouse side."
"The most valuable feature of Oracle OBIEE, for me, would be the Web Catalog. From a development perspective, I do not need any client or any software to be installed on my laptop or desktop. Everything is browser-based, so I just open the browser and start development."
"The most valuable features of Oracle OBIEE are the ease of logging in, the dashboard, and showing the problems in the data. Additionally, the reports are well integrated and it has good technology."
"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."
"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."
"The most valuable features are the lexical parameters and distribution."
"Support could be better."
"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."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The UI is a little outdated."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"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."
"Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement."
"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."
"The performance could be better."
"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."
"There could be better integration with other solutions, such as Microsoft Office."
"Setup and migration are very complex. Technically, Oracle accessory is extremely complex. These days, the industry demands a kind of Excel analysis, which is very easy to install, set up, and it's very developer-friendly as well as end-user friendly. OBIEE lacks all those features."
"Oracle OBIEE can improve the ease of use. It is a lot to learn and it could be made easier."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle OBIEE is ranked 1st in Legacy BI Tools with 153 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, Tableau, IBM Cognos 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.