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 performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"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."
"Informatica PowerCenter is a very good ETL tool."
"Deployment was simple and straightforward."
"The setup is straightforward."
"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."
"The solution is stable."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"I like the architecture of this solution. RPV is a powerful feature in Oracle OBIEE. It lets us design as per the needs of the organization. I can have multiple presentation folders and presentation layers. I can have customization in a single node in VMware, which is a very good feature of Oracle OBIEE. It helps customers in designing as per their requirements."
"Easy to create ad hoc reporting for different solutions."
"Its robustness is most valuable. It can handle massive amounts of data quickly. If it's properly configured and tuned, it can handle massive amounts of data very quickly to produce results. That to me is the number one feature."
"It has a lot workaround in order to do the report. data blending, and getting information from big data sources."
"I have found the most valuable features are business intelligence and reporting."
"Can utilize SQL queries to generate reports directly."
"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."
"We had stability issues, mostly with JVM size."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"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."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"There is some room for improvement in terms of pricing."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"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 OBIEEE's performance and licensing costs could be improved."
"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."
"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."
"Particularly on the Cloud, a lot of functionality has yet to be ported."
"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."
"It crashes when many people login simultaneously."
"The documentation in Oracle OBIEE can be more user-friendly."
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.