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 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."
"Once you have learned Informatica, it is very easy to use."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"UI-based ability to create data mapping."
"In the end, you have structured, proper data for use in an integrated BI solution."
"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."
"I found the map links, work links, and workflows valuable. They are important features."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"The scalability of the product is good."
"The most valuable feature is the reporting."
"I like the scheduling feature. It has an inbuilt scheduler which is very good, and it allows us to create agents, and those agents can be scheduled. It's quite flexible in that respect and goes into our IT infrastructure. The outputs are sent encrypted to various endpoints. Some are internal, and some are our clients, and it's encrypted at a high level. I do find Oracle OBIEE flexible. If there is stuff that's not in your model or schema, it's very flexible to create SQL scripts and create the data you want. It's quite nice to create a dashboard in OBIEE, and that's pretty straightforward in the way you drag and drop everything. You can create sections, and you can add elements to your page. That bit of the interface is relatively straightforward."
"The solution is user-friendly."
"It's easy to use for business analysts."
"The most valuable feature is the ability to set up the automated delivery of reports."
"I have not personally used any such products related to this service, however based on the popular opinion, Microsoft Power BI is more popular. We have never switched from this software due to infrastructure and license related costs. However, my team acknowledges that the Power BI is much more enhanced and includes features that are easier to use, including its drag and drop features. I am not sure, if OBIEE has these features, due to lack of updated versions."
"The most valuable features are the lexical parameters and distribution."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Lacks ability to calculate cost of the product."
"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."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"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."
"The performance of Informatica PowerCenter could improve."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The platform's data visualization features need improvement."
"From the point of view of strategic management, I would like to have a feature, perhaps a form after we get to the KPI dashboard, to be used to note if something unusual happens in the operations. That way we could record extreme KPI situations, and track why a number is very low or too high."
"There could be better integration with other solutions, such as Microsoft Office."
"BI Server"
"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 performance could improve and in a future release, they could provide more virtualization options."
"The documentation in Oracle OBIEE can be more user-friendly."
"Particularly on the Cloud, a lot of functionality has yet to be ported."
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.