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 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."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"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."
"UI-based ability to create data mapping."
"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 reliability of the product and the way of orchestration of different services is valuable to us."
"Informatica PowerCenter is a very good ETL tool."
"The scalability of the product is good."
"Both the vertical and horizontal scalability of the solution is good. In terms of scalability, I would rate this solution a nine out of ten."
"They were reasonable in terms of price."
"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."
"The most valuable feature of Oracle OBIEE is its ease of use."
"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 performance can issue queries to work in the Oracle database in Oracle's native language. There are a lot of visualizations which suit our business."
"The technical support services are good."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The documentation could be improved."
"The performance of Informatica PowerCenter could improve."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"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."
"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."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The development effort takes longer than other BI tools currently on the market."
"I find I prefer Oracle OAC over OBIEE. It's more advanced, has artificial intelligence, and there's more that we can do with it in general. OBIEE is lacking features."
"BI Server"
"We were not satisfied with the support, because we could not obtain answers or solutions."
"There are a lot of aspects of Oracle OBIEE that are exceptionally complicated, make things unnecessarily difficult for everyone who uses it. In terms of the integrations, Oracle needs to improve a little more, but I believe that they have tried to capture all those issues. The issues we are facing in the Oracle OBIEE 12C versions, in the Oracle Analytical Server Center or Analytical Cloud versions, Oracle has managed to overcome the challenges."
"Oracle OBIEE only displays KPIs, but it does not include strategic objectives or display risk in a strategic map."
"It crashes when many people login simultaneously."
"Even though we have a feature to enable the physical query to be seen in the log, in case of any issues, it is challenging to debug and see or identify where is the issue. For example, we designed the OBIEE repository and deployed it into the server, and we are now accessing and creating a report. For some reason, if the report is not working as expected, it is very difficult to identify the issue. We have a feature to see the physical query that is being generated in the central OBIEE server. I feel that this feature should have been available at the repository level so that while designing the repository, we can select the presentation columns and the query it is going to create. This will avoid the additional task of deploying a feature into the server and then testing the report. It will also make the implementation process friendly if, while designing the repository, we can see: How is a feature working? Are any of the presentation columns selected? How is the query being generated? Which query is being generated? Are any joints used? What kind of joints are used? Having this kind of information will make Oracle OBIEE more powerful and developer-friendly."
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.