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."To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"It has a Data Catalog that uses the Model repository."
"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."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"UI-based ability to create data mapping."
"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."
"The most valuable feature of Oracle OBIEE is interactive reporting because it allows better analysis versus conventional reporting, especially on the data warehouse side."
"The primary reason for using OBIEE is connectivity with Oracle E-Business Suite. It makes it easy to connect with our Oracle E-Business Suite. There are the standard dashboards available, which we sometimes use, and now we are looking for customized dashboards."
"The solution is easy to use and very flexible."
"It has a lot workaround in order to do the report. data blending, and getting information from big data sources."
"It mostly supports enterprise level data. We have millions of records on a daily basis."
"Can utilize SQL queries to generate reports directly."
"Some of the dashboard capabilities are good. The dashboard capabilities that tell you what kind of reports are available and provide you a summary of the reports are valuable. It is easy to navigate and easy to download reports into Excel to utilize them."
"Easy to create ad hoc reporting for different solutions."
"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."
"The pricing could be improved."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The performance of Informatica PowerCenter could improve."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The reputation of Informatica is that it is expensive."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"The platform's interface needs improvement."
"Oracle OBIEE is a product that is not easy to implement. The product is also not easy to use."
"They should develop greater visualization because their visualization isn't industry leading at the moment. The way you pull the data and see the data compared to other platforms, they're lagging a little bit behind. Also, their cost. I've got Oracle account managers trying to persuade me every day to purchase these licenses. Once you purchase OBIEE, then you have to purchase the virtualization and then you have to purchase the mobile license to operate on the mobile. It's really expensive."
"Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement."
"I would like to see Machine Learning included in this solution."
"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."
"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."
"It crashes when many people login simultaneously."
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.