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 reliability of the product and the way of orchestration of different services is valuable to us."
"It reduces a lot of legacy coding."
"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 product's initial setup phase is very easy."
"It has helped us monetize."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"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."
"It has a Data Catalog that uses the Model repository."
"Ability to create our own reports."
"It's easy to use for business analysts."
"User-friendly look and feel."
"Can utilize SQL queries to generate reports directly."
"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."
"Inter Process Communication."
"A great feature of the solution is its stability."
"I think the most valuable features are the ability to drill down, the graphs, and the scheduling for the reports to be received in Excel on a daily basis. Users like Excel, so it's good for them that they receive the reports by email, that they don't have to specify the schedule."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The UI is a little outdated."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"I would like to see it be able to import data from NoSQL."
"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."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"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."
"One significant improvement is the need for simplification. The set up could be more intuitive. An enterprise setup with HA and DR are pretty complex and to get a robust solution one has to play around with Real Application Cluster data sources and FAN notifications as well as WebLogic clustering and external load balancers. SSO also is not that simple to set up especially if you want all your Oracle systems to use the same SSO solution, i.e., no cheating with direct LDAP connectivity."
"For a beginner, this is a product that is difficult to learn. You cannot learn it quickly."
"There's a lot of redundancy, especially in relation to creating the code."
"Customer service/technical support gets five out of 10. Sometimes good, sometimes bad."
"The drawback with the tool is that though it is well-created, its users are under-trained to use it."
"In our organization, we feel that data visualization for APIs is an area in which the solution lacks."
"n the beginning it had it's stability issues, but it became stable."
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.