The solution in our organization is not used for execution. We use it for a few schedules and to replicate in different databases.
Senior Manager of System and Database at ESL
Quite stable and scalable with an easy implementation process
Pros and Cons
- "They've recently improved the ease of implementation."
- "The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."
What is our primary use case?
What is most valuable?
We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema.
The solution is quite stable.
They've recently improved the ease of implementation.
What needs improvement?
Right now, the solution is working quite well for us as it is.
The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement.
For how long have I used the solution?
I've been using the solution for the past three to five years.
Buyer's Guide
Oracle GoldenGate
November 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,660 professionals have used our research since 2012.
What do I think about the stability of the solution?
The solution is very reliable. I don't recall experiencing bugs or glitches, or crashes, for that matter. I'd describe it as very stable.
What do I think about the scalability of the solution?
The solution is extremely scalable. If a company needs to expand it, it should be able to do so without any issues.
We're a service provider and we implement products to companies of various sizes.
How are customer service and support?
As a vendor company, we're eligible to give support to our clients if they need it. As for contacting their technical support services, I don't recall if we really needed to, so I can't speak to their quality of service.
Which solution did I use previously and why did I switch?
I've only ever worked with this solution. I haven't tried any similar solutions in the past.
How was the initial setup?
In previous versions, the solution wasn't so easy to implement. In the latest version of the solution, they've made it really straightforward. It's much less complex than it was previously.
How long deployment takes depends on your formation and your design. If you want to do two more samples just for feature comparing, then it will take maybe three to four hours, if that. However, if you want to do some complex configurations, while it depends on the customer, it will take longer. How much of a database they want to initiate with GoldenGate will factor in on the length of time it will take. If the size is bigger by one million or even 200,000, then it will take much longer.
What about the implementation team?
We're a vendor company; we help our customers with the implementation.
What's my experience with pricing, setup cost, and licensing?
The cost of the solution is a bit high. It's higher than a lot of competitors.
What other advice do I have?
We're a reseller. We help our clients implement the solution.
I'm not sure which version of the solution I'm using or if it's the most current.
GoldenGate, right now, is a really fantastic solution. The price is high, but it's worth the cost, in my opinion.
It works with heterogeneous environments like Oracle, or IBM digital. We host it in servers and we host it in databases. A lot of the times we also host it in MySQL or on the MySQL database.
The solution uses a very low latency bandwidth because GoldenGate actually transfers the data. It will not take up a lot of resources like CPU or memory.
I'd rate the solution nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: reseller
Data Quality Software Development Manager at Yapı Kredi Bank
Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.
Pros and Cons
- "Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
- "It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
What is most valuable?
Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).
How has it helped my organization?
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 can able to replicate Big Data solution from any supported source system to Hadoop clusters.
What needs improvement?
Oracle GoldenGate Studio could be more user-friendly.
It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others).
For how long have I used the solution?
More than 5 years.
What was my experience with deployment of the solution?
No, if found Oracle Support and/or Oracle Community helped me a lot.
What do I think about the stability of the solution?
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, truncate 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.
What do I think about the scalability of the solution?
No.
How are customer service and technical support?
Customer Service:
Created some service requests about GoldenGate years before, but all are solved.
Technical Support:10 over 10.
Which solution did I use previously and why did I switch?
Quest Shareplex, because of licensing costs.
How was the initial setup?
Straightforward, easy. Deployed everything within Oracle Data Integrator.
What about the implementation team?
In-house and vendor, depending on the project.
What was our ROI?
Developing 1000 of ODI interfaces for loading into Operational Data Store will took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
What's my experience with pricing, setup cost, and licensing?
No comment about pricing and licensing.
Which other solutions did I evaluate?
Yes, we switched from SharePlex of Quest Software.
What other advice do I have?
Oracle GoldenGate is a stable, powerful and robust solution for your data replication needs. It supports not only Oracle, but also many source and target systems to replicate.
It now has the ability to work together with Oracle Enterprise Manager, as well as it has its own GUI (Oracle GoldenGate Studio).
Management Pack and VeriData are additional packs for your management and data verification needs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle GoldenGate
November 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,660 professionals have used our research since 2012.
Senior Technology Consultant at a tech services company with 11-50 employees
Helps you replicate a subset of your data instead of the full data
Pros and Cons
- "You can use Oracle GoldenGate as a DR for your system."
- "It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
What is our primary use case?
I used Oracle GoldenGate for some migrations and consultations between different types of businesses.
What is most valuable?
Oracle GoldenGate has a lot of benefits. You can use Oracle GoldenGate as a DR for your system. You can use the solution if you don't want to have unnecessary recovery using synchronization or have some restrictions, like character suit or limited use.
Oracle GoldenGate can help if you have only to replicate the subset of your data and not the full data. Suppose you are in an organization with many branches and are interested in replicating only the accounting and not the financial data. In that case, Oracle GoldenGate will help you with some considerations, calculations, and transformations associated with it.
What needs improvement?
In Oracle GoldenGate, we don't have full capabilities or information on ODI products for Oracle, which are specifically used for transformations. You can do your coding or transformation processes and do your job. Sometimes I use a quality tool for Oracle to do some transformation from data cleansing and data insights.
I know every Oracle product has been designed for each feature, and Oracle GoldenGate is a dedicated tool for better transformation and replication. It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate. Although currently, it's a good prototype, Oracle GoldenGate can do more.
For how long have I used the solution?
I have been using Oracle GoldenGate for almost four years.
What do I think about the stability of the solution?
Oracle GoldenGate's stability is better if you follow the metrics for compatibility between software versions. If you follow all the metrics, Oracle GoldenGate's stability can be rated an eight to nine out of ten. However, you may face some bugs if you don't follow the metrics.
What do I think about the scalability of the solution?
I rate Oracle GoldenGate an eight or nine out of ten for scalability. Oracle GoldenGate can work for small, medium, and enterprise companies. It's scalable to work on different scales.
How are customer service and support?
We sometimes need to open the tickets with Oracle to get technical support. Depending on the team and the escalation level, sometimes we get a very good response from Oracle, and sometimes we don't.
How would you rate customer service and support?
Positive
How was the initial setup?
Oracle GoldenGate's initial setup is very simple because Oracle has a dedicated version for every database, whether Oracle or non-Oracle. For the initial setup between the source and the solution, the ease of setup depends on the configuration and the business requirement. It does not depend only on the technology but on the customer's requirements. If you have a very complex replication, it needs a more complicated setup. It depends on each task.
We can't comment that it's always easy to have Oracle GoldenGate, and we can set it up in a day or two. Sometimes you can set it up within a few hours; other times, it needs very deep understanding and preparation before going to Oracle Golden Gate.
You might need some help from ODI or other tools to prepare your data and get ready. It will be easier if everything is clear and there is an understanding of the mapping between the source and destination, objects, and attributes. However, you cannot have a definite answer for all cases.
What about the implementation team?
In certain cases, customers could install the solution themselves. Oracle has had a GUI interface for Oracle GoldenGate for two or three years called the microservices. Microservices can be easier to set up for single cases. However, if you have some complex cases, you will need some help understanding data, replication, and knowing if some preparation is required at the beginning.
What other advice do I have?
I would recommend Oracle GoldenGate to other users because it’s a good product.
Overall, I rate Oracle GoldenGate an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Director at a healthcare company with 11-50 employees
Works best with Oracle, but needs better front-end management
Pros and Cons
- "It works best with Oracle."
- "The front-end management isn't very good."
What is our primary use case?
We are using it for getting data back.
What is most valuable?
It works best with Oracle.
What needs improvement?
The front-end management isn't very good.
Its pricing and licensing can also be better.
For how long have I used the solution?
I have been using this solution for about a year.
What do I think about the stability of the solution?
It is very stable.
What do I think about the scalability of the solution?
It is very scalable.
How are customer service and support?
Their technical support is pretty good. I would rate them a four out of five.
How was the initial setup?
It was easy to set up.
What about the implementation team?
I installed it myself.
What's my experience with pricing, setup cost, and licensing?
Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing.
There don't seem to be any additional costs.
What other advice do I have?
I would recommend this product. It's pretty good.
I would rate it a seven out of ten.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Technical director at RDTEX LLC
Supports cross-platform migrations; doesn't hang or crash, so it's stable
Pros and Cons
- "What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2."
- "What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better."
What is our primary use case?
My customer uses Oracle GoldenGate mostly for pumping data from one database to another, including data storage format changes. The solution is also used for migrating from one system to another and cross-platform migrations.
What is most valuable?
What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2.
What needs improvement?
What needs improvement in Oracle GoldenGate is the support.
Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line.
Simplifying how Oracle GoldenGate is used would also make the solution better.
For how long have I used the solution?
I've been working with Oracle GoldenGate for more than three years.
What do I think about the stability of the solution?
Oracle GoldenGate is a stable solution because a lot of my customers use it and it doesn't hang. It doesn't crash. It works.
What do I think about the scalability of the solution?
Oracle GoldenGate is a scalable solution.
How are customer service and support?
The technical support for Oracle GoldenGate still needs a little bit of improvement. On a scale of one to five, I'm rating the support for the product as four out of five.
How was the initial setup?
Oracle GoldenGate is quite complex to set up and support, though it has powerful features. Deployment could be completed within days or weeks, depending on your database and how your storage structure is implemented. The process may require some introduction and workarounds for it to go smoothly. It highly depends on the database you're using.
What's my experience with pricing, setup cost, and licensing?
Licensing for Oracle GoldenGate is paid yearly.
What other advice do I have?
I concentrate on Oracle products, and I'm currently working with Oracle GoldenGate.
My company provides Oracle GoldenGate for customers, so my team has been working with a lot of versions of the solution, starting from version 12 up to version 19.
My company works on consulting projects, and can also sell licenses, but if the customer has a license and requires some solutions, the team can provide complete services, starting from designing architecture, upgrading, ensuring there's minimal downtime, etc.
At the moment, my company has seven clients using Oracle GoldenGate.
My advice to others who want to start using Oracle GoldenGate is that it may not be as easy at the beginning, but it's a good product.
My current rating for Oracle GoldenGate is nine out of ten, but if I'm able to evaluate other solutions, that rating could change to a lower or higher rating.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Fintech Project Manager at a comms service provider with 10,001+ employees
Easy to maintain, flexible, and scales with our environment
Pros and Cons
- "This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
- "Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
What is our primary use case?
Our primary use for this solution is the replication of data between heterogeneous environments to implement a data hub. We use this for reporting purposes or to publish data to the various systems (acquire and publish technique) using multiple technologies and multiple platforms. They are typically Oracle DBs on Oracle platforms, with some different types of databases, like Teradata, and also sourcing data into Hadoop Big Data.
How has it helped my organization?
This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation. There is minimal effort required for maintenance, which would be performed by non-dedicated DBA.
What is most valuable?
The most valuable feature of this solution is its compatibility with Oracle DB and Oracle products, generally, as our environment is really dependant on them.
The flexibility for customization as well as the scalability of the tool is very important, as we expand our environment we can expand and scale up the tool on the go.
What needs improvement?
The User Interface should be improved in newer versions, but without putting any restrictions on the customization capabilities. Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner.
The licensing model should be improved to be more cost-effective for the end users.
For how long have I used the solution?
Seven years.
How was the initial setup?
This solution is straightforward to implement with a hassle-free setup.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Team Lead at a retailer with 10,001+ employees
Support for Oracle, MySQL, DB2, Sybase, Teradata, SQL server and others
In 2009, Oracle acquired Golden Gate to strengthen its data replication technology as part of future strategies within data warehouse and real time transaction database. Before this acquisition, Oracle had its own replication technology which mainly constitutes basic replication, advance replication and stream replication.
Oracle's basic replication process had two different methods: log based and trigger based. In log based replication, snapshot schema and DB links had to set up between source and target database. Data was transported from online redo log to target database over network.
In advance replication Oracle included multiple master replications from multiple environments and trigger based replication method.
In later versions of Oracle 9i, stream replication
was introduced with improvements in its earlier replication technologies. It uses log
based replication where committed transaction’s online redo log of source
system is mined to target system over network. Also a new
background process to manage communication and operations of replication activities has been introduced
However these replication technologies couldn't stand long as it
involved complicacy and complex software development to harness the
power of Oracle to Non Oracle database environment to allow the
transaction to be moved between environment.
In 1990, a small software company Golden Gate came with
different approach on data replication between cross platform. Instead of using
different formats, Golden Gate implemented a uniform format and used a command
prompt GGSCI (Golden Gate Software Command Interface) to perform data
replication operation. Oracle Goldengate 11g supports both DDL and DML
operation. Legacy Oracle 8i version or prior requires an upgrade to 9i or later to implement the
Goldengate.
Goldengate supports all popular databases such as Oracle,
MySQL, DB2, Sybase, Teradata, SQL server etc.
Goldengate contains three installable components which can be
downloaded separately from Oracle's website and can be installed on
both, source and target system depending on requirement. Below is the
list of installable components for Goldengate:
- Oracle Goldengate which includes GGSCI, DEFGEN, LOGDUMP and REVERSE.
- Oracle Goldengate Director which includes Director Service application, Monitor Agent, Director Client and Administrator client.
- Oracle Goldengate Veridata which includes Agent, CLI, Web interface.
Architecture
Manager Process
- Start and manage Goldengate processes such as collector.
- Manage port numbers.
- Trail Management.
- Createerror, event and reports.
- Process command GGSCI.
Extract Process – Extract DML and DDL data from source database.
Data Pump Process: Option process but recommended. Read records
from source trails, process them and passes over to target system.
Collector Process: This background process runs on Target system. It writes records on remote trail.
Replicate Process: ReadsRemote trail, process them and applies
changes to target Database.
Trail: It is a Goldengate intermittent file written in
proprietary format by either extract process (source system) or
collector background process (target system).
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Oracle Solutions Architect at Viceri
It enables us to merge and transform data from various sources in real time
Pros and Cons
- "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."
- "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."
What is our primary use case?
We use GoldenGate to integrate and consolidate various databases. After this, we send the information to Oracle Cloud Analytics to generate reports.
What is most valuable?
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 how long have I used the solution?
I have worked with Oracle for six years and GoldenGate for the past two.
What do I think about the stability of the solution?
GoldenGate is highly stable.
What do I think about the scalability of the solution?
GoldenGate is highly scalable.
How are customer service and support?
Oracle support is okay.
How was the initial setup?
Setting up GoldenGate was straightforward.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
I rate Oracle GoldenGate 10 out of 10. I recommend GoldenGate for business customers who need data integration. There are multiple GoldenGate products to use.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Data IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
Teradata
Oracle Data Integrator (ODI)
Talend Open Studio
IBM InfoSphere DataStage
Palantir Foundry
SAP Data Services
Qlik Replicate
StreamSets
Alteryx Designer
Fivetran
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- Should we choose Data Hub or GoldenGate?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
- What are the best on-prem ETL tools?
- Which integration solution is best for a company that wants to integrate systems between sales, marketing, and project development operations systems?
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- What are the must-have features for a Data integration system?
- Should we choose Data Hub or GoldenGate?