What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
198 Ratings
76 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Oracle GoldenGate

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
198 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Likelihood to Recommend

Informatica PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel | TrustRadius Reviewer

Oracle GoldenGate

It is particularly useful in situations where ACTIVE DATA GUARD cannot handle the desired outcome. It can be used to support cross-platform migrations not supported by Active Data Guard which is a far cheaper solution to DR. It is suited for migrations that require zero downtime as there is bi-directional capability built into the product. It is also useful when the source and target are of different databases such as Oracle to SQL Server as the target. It is overkill if all you require is a physical standby that is open read-only.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Informatica PowerCenter
8.8
Oracle GoldenGate
8.5
Connect to traditional data sources
Informatica PowerCenter
9.4
Oracle GoldenGate
9.0
Connecto to Big Data and NoSQL
Informatica PowerCenter
8.2
Oracle GoldenGate
8.0

Data Transformations

Informatica PowerCenter
8.6
Oracle GoldenGate
8.3
Simple transformations
Informatica PowerCenter
8.7
Oracle GoldenGate
8.7
Complex transformations
Informatica PowerCenter
8.5
Oracle GoldenGate
8.0

Data Modeling

Informatica PowerCenter
8.3
Oracle GoldenGate
7.2
Data model creation
Informatica PowerCenter
7.4
Oracle GoldenGate
7.8
Metadata management
Informatica PowerCenter
9.0
Oracle GoldenGate
7.2
Business rules and workflow
Informatica PowerCenter
8.6
Oracle GoldenGate
7.8
Collaboration
Informatica PowerCenter
8.7
Oracle GoldenGate
7.5
Testing and debugging
Informatica PowerCenter
7.9
Oracle GoldenGate
5.9
feature 1
Informatica PowerCenter
Oracle GoldenGate
7.2

Data Governance

Informatica PowerCenter
8.1
Oracle GoldenGate
7.7
Integration with data quality tools
Informatica PowerCenter
8.1
Oracle GoldenGate
7.8
Integration with MDM tools
Informatica PowerCenter
8.2
Oracle GoldenGate
7.6

Pros

Informatica PowerCenter

  • Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
  • Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
  • Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

  • Ease of installation
  • Ease of maintenance
  • Powerful output with sub-second speed
  • Supporting Big Data and Cloud environment
  • Capturing source data based on transnational log, no cost on source CPU
  • Handle the distribution and the delivery of committed data in real-time
  • Supports heterogeneous systems regarding target or source database
  • Can be implemented uni-directional, bi-directional or peer-to-peer mode
  • Zero downtime migration
  • Supports data distribution
  • Can be used for disaster recovery or data protection
Gurcan Orhan | TrustRadius Reviewer

Cons

Informatica PowerCenter

  • One of the challenges of PowerCenter is the lack of integration between the components and functionality provided by PowerCenter. PowerCenter consists of multiple components such has the repository service, integration service, metadata service. Considerable time and resources were required to install and configure these components before PowerCenter was available for use.
  • In order to connect to various data sources such as Netezza database or SAS datasets, PowerCenter requires the installation and configuration of separate plug-ins. We spent considerable time trouble-shooting and debugging problems while trying to get the various plug-ins integrated with PowerCenter and get them up and running as described in the documentation.
  • PowerCenter works well with structured data. That is, it is easy to work with input and output data that is pre-defined, fixed, and unchanging. It is much more difficult to work with dynamic data in which new fields are added or removed ad-hoc or if data format changes during the data ingest process. We have not been as successful in using PowerCenter for dynamic data.
  • One of the challenges of learning PowerCenter is that it is difficult to find documentation or publications that help you learn the various details about PowerCenter software. Unlike SAS Institute, Informatica does not publish books about PowerCenter. The documentation available with PowerCenter is sparse; we have learned many aspects of this technology through trial and error.
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

  • Setting Up Oracle GoldenGate as HA in an Oracle RAC environment. While this is possible to do and there is documentation out there, I've found that specific Oracle GoldenGate and Oracle RAC experience is needed in order to make this happen. That level of experience does not exist everywhere.
  • Monitoring Oracle GoldenGate. Currently there are two main options for monitoring Oracle GoldenGate, the first, GoldenGate Monitor, does not scale well as it becomes very non-performant when you have more than 10-15 GoldenGate Managers reporting to it, the second, Oracle Enterprise Manager, while getting better still requires a lot of manual configuration to have Oracle GoldenGate talk to the OEM agent. While this has got a lot better with 12c GoldenGate, I still feel that there is room to improve here.
  • Unable to replicate certain Data Types. Again, less of an issue in 12c Oracle GoldenGate, but there are still some Data Types that Oracle GoldenGate is unable to replicate.
Michael Grayson | TrustRadius Reviewer

Likelihood to Renew

Informatica PowerCenter

Informatica PowerCenter 10.0
Based on 4 answers
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
Robert Goodman | TrustRadius Reviewer

Oracle GoldenGate

Oracle GoldenGate 9.2
Based on 3 answers
We are very Happy with the product and the support and it helps us achive our 99999 SLA.
Anonymous | TrustRadius Reviewer

Usability

Informatica PowerCenter

Informatica PowerCenter 9.5
Based on 2 answers
Positives;- Multi User Development Environment- Speed of transformation- Seamless integration between other Informatica products.Negatives;- There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center.- Oracle Analytical functions should be natively used.- E-LT support as well as ETL support.
Gurcan Orhan | TrustRadius Reviewer

Oracle GoldenGate

Oracle GoldenGate 8.6
Based on 3 answers
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
Michael Grayson | TrustRadius Reviewer

Reliability and Availability

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
Oracle GoldenGate has only gone down for us when the data being sent was bad.
Michael Grayson | TrustRadius Reviewer

Performance

Informatica PowerCenter

Informatica PowerCenter 9.5
Based on 2 answers
PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

Oracle GoldenGate 9.0
Based on 1 answer
Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
Michael Grayson | TrustRadius Reviewer

Support Rating

Informatica PowerCenter

Informatica PowerCenter 8.0
Based on 1 answer
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

Oracle GoldenGate 8.8
Based on 3 answers
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
Michael Grayson | TrustRadius Reviewer

In-Person Training

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
Michael Grayson | TrustRadius Reviewer

Online Training

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
Michael Grayson | TrustRadius Reviewer

Implementation Rating

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 8.6
Based on 3 answers
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
Michael Grayson | TrustRadius Reviewer

Alternatives Considered

Informatica PowerCenter

PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.
Brian Randolph | TrustRadius Reviewer

Oracle GoldenGate

It wasn't easy to set up replication to a message queue using SharePlex. We had challenges using the product when the application was doing a lot of "rollbacks to savepoint". SharePlex always showed a lag.When I was testing SharePlex, there was no way to offload the workload from the DB server while using it.
Anonymous | TrustRadius Reviewer

Scalability

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
Michael Grayson | TrustRadius Reviewer

Return on Investment

Informatica PowerCenter

  • Positive - Easy to maintain processes built in Informatica Power Center.
  • Positive - Rapidly build and deploy ETL data mappings.
  • Positive - Develop the overall workflow process to run all ETL processes for the project.
  • Negative - Informatica Power Center can be a bit expensive, so your application needs to warrant the enterprise support.
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

  • As Oracle GoldenGate integrated well with the Oracle products we were already using, we didn't need to spend additional time and money to purchase or develop an integration solution.
  • XStream and Active Data Guard licenses come free with Oracle GoldenGate, reducing overhead costs.
  • Eliminated the need to scale our workstations up in terms of hardware resources. Creating read-replicas to offload read requests gave more opportunities to scale horizontally.
Anonymous | TrustRadius Reviewer

Pricing Details

Informatica PowerCenter

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Oracle GoldenGate

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Informatica PowerCenter
8.6
Oracle GoldenGate
8.7

Likelihood to Renew

Informatica PowerCenter
10.0
Oracle GoldenGate
9.2

Usability

Informatica PowerCenter
9.5
Oracle GoldenGate
8.6

Reliability and Availability

Informatica PowerCenter
Oracle GoldenGate
10.0

Performance

Informatica PowerCenter
9.5
Oracle GoldenGate
9.0

Support Rating

Informatica PowerCenter
8.0
Oracle GoldenGate
8.8

In-Person Training

Informatica PowerCenter
Oracle GoldenGate
10.0

Online Training

Informatica PowerCenter
Oracle GoldenGate
10.0

Implementation Rating

Informatica PowerCenter
Oracle GoldenGate
8.6

Scalability

Informatica PowerCenter
Oracle GoldenGate
10.0

Add comparison