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."Informatica PowerCenter is a very good ETL tool."
"It reduces a lot of legacy coding."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"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."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"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."
"PowerCenter performs well during data transformation and optimization."
"We can scale the product."
"We can see almost-real-time performance in our operations. When there is a problem, it is easy to escalate it to top management and the time for management to make a decision about it is much shorter than it would be using a manual process."
"The most valuable feature of Oracle OBIEE is interactive reporting because it allows better analysis versus conventional reporting, especially on the data warehouse side."
"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 its ease of use."
"Inter Process Communication."
"It is easy to create a report quickly. It does not take much time to create an ad hoc report."
"In terms of features, everything is good. It is also stable and scalable."
"The solution is easy to use and very flexible."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"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."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"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 pricing could be improved."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"From an improvement perspective, the technical team should be able to provide more accurate answers by taking into consideration the context of the issues faced by users."
"I would like to see the data wrangling features enhanced."
"It should have more self-service capabilities."
"OBIEE doesn't have audit logs."
"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."
"There's a lot of redundancy, especially in relation to creating the code."
"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's not so flexible to do BI reporting directly from the data source without models. It is not that agile."
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.