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 works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"It has a Data Catalog that uses the Model repository."
"The most valuable features are the metadata repository and the data warehouse application console."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"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 number of docs has been reduced drastically, which is very good."
"The setup is straightforward."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments."
"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."
"With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"They've recently improved the ease of implementation."
"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."
"One feature that stands out for me is the data center capability."
"When we are replicating data between similar databases then it is straightforward."
"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."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"I would like to see it be able to import data from NoSQL."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"The performance of Informatica PowerCenter could improve."
"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 initial setup is not straightforward. You need expertise to do it."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"The process of transforming the data between two different databases is inefficient and needs to be improved."
"You cannot put everything in Golden Gate for the license and large models."
"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."
"Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."
"The solution's performance needs improvement."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 47 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 Tableau, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and JumpMind SymmetricDS. 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.