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."It's very easy to use it to develop mappings and workflows."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"Good product if you are trying implement data quality, data integration, and data management projects."
"In the end, you have structured, proper data for use in an integrated BI solution."
"The most valuable features are the monitoring tools and the reporting manager."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The most valuable features are the metadata repository and the data warehouse application console."
"For me, it makes the difference is in terms of our users being able to take advantage of a product which allows you to get access to data, reports, make decisions quickly, and have better insights regarding operations."
"The solution is easy to use and very flexible."
"There are some great new features in the latest version."
"The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand."
"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 is the reporting."
"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 visualization is very good."
"The initial setup is not straightforward. You need expertise to do it."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Support could be better."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Integration with Artificial Intelligence would benefit this solution."
"Requires an established data center because there is no option for software as a service."
"I would like to see enhancements in tracking, debugging, and flexibility."
"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."
"The documentation in Oracle OBIEE can be more user-friendly."
"It's not so flexible to do BI reporting directly from the data source without models. It is not that agile."
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"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."
"There's a lot of redundancy, especially in relation to creating the code."
"The performance could be better."
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.