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."In the end, you have structured, proper data for use in an integrated BI solution."
"The technical support for Informatica PowerCenter is good."
"The number of docs has been reduced drastically, which is very good."
"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."
"The most valuable features are the metadata repository and the data warehouse application console."
"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."
"It has good standard features for ETL development."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The most valuable feature is the visualization."
"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."
"It's the connectors, the adapters. Built in connectors with different ERPs, you can plug in XL, other sources of data. It's very easy to configure. It's very easy to use."
"It is easy to use...I rate the scalability of the solution a nine out of ten."
"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 technical support services are good."
"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."
"Provides good data visualization features, and provides a lot of visualization reports from various data sources."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"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."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"Oracle OBIEE can improve the ease of use. It is a lot to learn and it could be made easier."
"In the on-premises version, the feature for connecting and selecting the data between the databases looks a bit cumbersome, but I am not sure. The person who is using it takes a lot of time to design a data warehouse. When I ask him why is it taking this long, I get a response that this is something that he has to design, and there are different tools that are available. He has to write the ETL and design the warehouse according to the customer's requirement, which takes a lot of time. Its visualization should be enhanced, and there should be a feature where you can easily create your custom data warehouse."
"The platform's data visualization features need improvement."
"n the beginning it had it's stability issues, but it became stable."
"Managing the OB applications requires a high level of experience, and makes the solution quite heavy."
"The pricing of the solution should be bettered."
"The performance and the complex setup are the main reason for switching to Qlik Sense."
"The solution is too expensive for small firms."
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.