We performed a comparison between Informatica PowerCenter and Oracle GoldenGate based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It has good standard features for ETL development."
"Good interface, reasonable documentation."
"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 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."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It has very good monitoring and process monitoring."
"The product's initial setup phase is very easy."
"This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
"Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support."
"The solution is useful for data transformation."
"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."
"They've recently improved the ease of implementation."
"The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios."
"You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."
"It is a scalable solution."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"We had stability issues, mostly with JVM size."
"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."
"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."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"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."
"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."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it."
"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."
"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
"I would like to see the interface more graphical and easier to use."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"Troubleshooting issues is not always the easiest. It should be easier to troubleshoot. Their support can also be improved. They don't read your problem statement and waste a lot of time. GoldenGate for big data is actually a separate license. It is sort of a separate product, but it might fall underneath your GoldenGate category. If we're talking about big data, its interaction with big data sources is poorly documented."
"Monitoring must be a bit more enhanced."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 48 reviews. Informatica PowerCenter is rated 8.0, while Oracle GoldenGate is rated 8.2. 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 GoldenGate writes "Performs real-time replication without data loss, but we cannot do much automation". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Matillion ETL, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and Confluent. See our Informatica PowerCenter vs. Oracle GoldenGate report.
See our list of best Data Integration vendors.
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.