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 is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The number of docs has been reduced drastically, which is very good."
"The setup is straightforward."
"The interface is very clean and clear."
"The most valuable features are the monitoring tools and the reporting manager."
"UI-based ability to create data mapping."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"The solution is stable."
"The solution's existing SaaS platform for data integration gives us an edge."
"We use the tool to pull on-prem data."
"I like that the product transforms data and provides real-time applications."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"They've recently improved the ease of implementation."
"With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database."
"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."
"For small databases, GoldenGate handles the migration well."
"The reputation of Informatica is that it is expensive."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"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."
"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."
"Lacks ability to calculate cost of the product."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration."
"In some cases, expectations were not met, especially when specific tables were expected to be disabled, and changes were anticipated in the target environment. We had to take backups from the source and refresh the address to address this."
"There are a lot of bugs in the solution."
"The solution needs to improve its latency, monitoring and support."
"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."
"Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."
"GoldenGate is expensive. It's costly because this solution is unique in our market. The GoldenGate Cloud Service is cheaper than the on-premise solution."
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 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.