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."I found the map links, work links, and workflows valuable. They are important features."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"Good product if you are trying implement data quality, data integration, and data management projects."
"UI-based ability to create data mapping."
"It has a Data Catalog that uses the Model repository."
"The solution is stable."
"The ability to scale through partitions helped us to improve the performance."
"Good interface, reasonable documentation."
"It can be used with any type of data models, such as relational lines and dimensional lines."
"Oracle OBIEE is very easy to use. Looking at analytics, I think they have come a long way by adding new features like visualization, which is really cool."
"User-friendly look and feel."
"It doesn't have many frills and is definitely older technology, but it is undeniably a workhorse."
"It's easy to use for business analysts."
"A great feature of the solution is its stability."
"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."
"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."
"Support could be better."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"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."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"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."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"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."
"They should release new versions for the solution's on-premises setup."
"I would like to see the data wrangling features enhanced."
"It is not a good product for data visualization."
"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."
"OBIEE doesn't have audit logs."
"I would like to see enhancements in tracking, debugging, and flexibility."
"n the beginning it had it's stability issues, but it became stable."
"When a large number of queries are running at the same time, the report fails."
"In terms of tech support, we have our own technicians. But, we did register for their help. When we register a call, it takes time for them to respond to us."
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.