We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and Oracle GoldenGate based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The most valuable features are the monitoring tools and the reporting manager."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"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."
"I found the map links, work links, and workflows valuable. They are important features."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The technical support for Informatica PowerCenter is good."
"The installation of the client ODI Studio is easy."
"Oracle provides great documentation."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"It's completely user-friendly."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It is an ETL tool, which does the extract, transform, and load."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database."
"I like that the product transforms data and provides real-time applications."
"CDC is the most valuable feature."
"GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"The reputation of Informatica is that it is expensive."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"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."
"The licensing is difficult."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The price needs to be lowered. It's too expensive."
"The performance of the user interface is in need of improvement."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The resource management aspect of the solution could be improved."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time."
"Lacks the ability to become a full-scale ETL tool."
"It is not a very stable tool, and you need to monitor it perfectly."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"A clean and user-friendly graphical interface based on common design principles would be beneficial."
"The GoldenGate license is very costly."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"The front-end management isn't very good."