Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.
Gurcan Orhan | TrustRadius Reviewer
October 30, 2017

Different Source Systems (IBM DB2, Microsoft SQL Server) Are Supported For Real Time Replication.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle GoldenGate

Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.
  • 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
  • Oracle GoldenGate Studio could be more user-friendly.
  • It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).
  • In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
  • But both issues are solved now.
  • Installation is straightforward, easy.
  • Deployed everything within Oracle Data Integrator.
  • Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
  • Management Pack and VeriData are additional packs for your management and data verification needs.
Yes - I am a member of the Independent Oracle User Group, ODTUG, Colombia Oracle Users Group, Costa Rica Oracle Users Group, Ecuador Oracle User Group, Grupo de Usuarios Oracle El Salvadore, Oracle User Group Guatemala, Oracle User Group Mexico, Panama Oracle User Group, Azerbeidzjan Oracle User Group, Bulgarian Oracle User Group, Oracle Gebruikersclub Holland, Oracle User Group Finland, Oracle User Group Norway, Romanian Oracle User Group, Slovenian Oracle User Group SIOUG, Spain Oracle User Group, TROUG Turkish Oracle User Group, UK Oracle User Group and All India Oracle User Group.

I am presenting in various Oracle User Groups worldwide and share my expertise with Oracle Golden Gate in many of my sessions.
We switched from SharePlex of Quest Software because of licensing costs.

  • Capture data based on transaction log
  • Handle the distribution and the delivery of committed data in real-time
  • Supports heterogeneous systems both in source or target database
  • It can work in uni-directional, bi-directional or peer-to-peer mode
  • It has a sub-second speed
  • Low impact on source and target systems
  • Platform independent universal data formatEasy to deploy - simple configuration of parameter files
  • Conflict detection and resolution
  • Supports data encryption

Oracle GoldenGate Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
9
Simple transformations
8
Complex transformations
5
Data model creation
Not Rated
Metadata management
Not Rated
Business rules and workflow
Not Rated
Collaboration
8
Testing and debugging
9
Integration with data quality tools
10
Integration with MDM tools
10