We use the solution for data recovery and integration with multiple databases.
Oracle Advisory Engineer at a tech services company with 11-50 employees
Reliable solution with efficient data integration features
Pros and Cons
- "It is a scalable solution."
- "The solution's performance needs improvement."
What is our primary use case?
What is most valuable?
The solution's most valuable feature is its ability to integrate with multiple platforms.
What needs improvement?
The solution's performance needs improvement. It could be faster.
For how long have I used the solution?
I have been using the solution for three years.
Buyer's Guide
Oracle GoldenGate
October 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
I rate the solution's scalability a nine out of ten. It is suitable for enterprise businesses.
How are customer service and support?
I can resolve the technical issues myself with the help of online support portals for the solution. Also, their support team takes longer to respond to the queries. In addition, their marketing team keeps contacting us to share extra product information, which I find unnecessary.
How would you rate customer service and support?
Neutral
How was the initial setup?
The solution's initial setup is complicated. We need to understand its GUI before implementing it. Also, we need to know the exact requirements for configuration.
What about the implementation team?
Our customers take help from third-party vendors to implement the solution.
What's my experience with pricing, setup cost, and licensing?
The solution is highly-priced.
What other advice do I have?
The solution is reliable. I rate it a 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: Partner
Oracle ERP DBA Conultant- Oracle Super Cluster T5-8 Admin at a government with 1,001-5,000 employees
Good replication between databases and can accept data from multiple sources
Pros and Cons
- "GoldenGate can connect and collect data from multiple sources, such as SQL Server."
- "I would like to see the interface more graphical and easier to use."
What is our primary use case?
Our primary use is to transfer data or tables in databases from one server to another.
What is most valuable?
GoldenGate can connect and collect data from multiple sources, such as SQL Server.
What needs improvement?
There are some DDLs that have problems with GoldenGate. These issues detract from stability and it is something that should be improved.
I would like to see the interface more graphical and easier to use. I like Microsoft products, for example, because they are easy to use. When I work in SQL Server, which is integrated with Oracle GoldenGate, I find it better to work in than Oracle.
For how long have I used the solution?
We have been using Oracle GoldenGate for the past three or four years.
What do I think about the stability of the solution?
GoldenGate is a stable product.
Usually, it works with no problems. Sometimes there are issues, but we have been able to solve them.
What do I think about the scalability of the solution?
It is easy to scale once you learn it.
How are customer service and technical support?
This product has been working well in our environment so we haven't had the need to contact technical support.
How was the initial setup?
The initial setup was straightforward. It took three or four months to complete.
What about the implementation team?
The implementation was done by the Oracle team.
What other advice do I have?
My advice for anybody who is considering this product that its suitability depends on the environment. If Oracle is being used then it is a good solution but otherwise, another product would be a better choice. I would suggest using a solution by the same vendor as the database that is being used.
I would rate this solution an eight out of ten.
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
Oracle GoldenGate
October 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
Database Administrator at a tech services company with 51-200 employees
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication being the primary purpose of all the mentioned technologies, each have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA's must learn and understand the functionality of both and know which technique can be used and in what scenario.
Let's discuss the differences between Oracle Active Dataguard and Oracle GoldenGate.
Oracle Active Dataguard is simple and the most economical solution for replication. The concept of active dataguard is a super set of traditional dataguard. It offers real time data protection and availability. Here in active replication you can place your secondary database in read-only mode, where the secondary database is available to users for limited usage like reporting and query offloading. Active Dataguard promises zero data loss across large distances without hampering performance. Other benefits to count on you can consider the capability of Active Dataguard to automatically repair the physical corruption without incurring any performance impact and availability of the dedicated servers. Using special purpose network devices Active Dataguard ensure minimal bandwidth utilization. With Active Dataguard DBAs can reduce the planned downtime to much extent while migrating or upgrading databases.
Oracle GoldenGate is the most advanced logical replication product from Oracle. This is especially well known for its cross-platform operating capabilities. GoldenGate provides a wide range of options addressing a number of customer replication needs. The basic principal is that it works up on is to capture online changes, distribute and deliver transactions across various secondary systems. The secondary database in this configuration which is available is read-write mode during replication and synchronizations, incurring additional overhead to maintain both database in same state. The beauty of GoldenGate lies in its capability to replicate the changes in heterogeneous IT environment taking into consideration all the components of IT along with various Database Management Systems. We can rely on the technology even in case of network outage between primary and secondary server located geographically at long distances. The recent release of product promises improved performance, reliability, consistency, conflict detections, data integrity etc.
It is really important to understand the feasibility of a solution taking into consideration the financial aspect of the organization while selecting an appropriate solution. Below are some comparison points that can let us decide which technology can be used to meet our requirements:
1. Use of Secondary Server: If there is any need to update the secondary server, you can do so with GoldenGate. Database is available in read-write mode and users can perform operation on the database. Whereas the database in case of Active Dataguard is open in read-only mode.
2. Supplemental Logging: With Active Dataguard you are not required to put on the supplemental logging for tables not having primary keys or unique indexes. Some configurations and settings with minimal performance overhead active dataguard handles most workload. GoldenGate compulsory requires supplemental logging tables with without primary key and unique indexes.
3. Maintenance & Migrations: Oracle Golden Gate provides the zero-downtime using 2-way or bi-directional replication. Whereas there are some scenarios where reduced downtime for various planned activities is not possible with Active Dataguard.
4. Cross-Edition migrations & replication: GoldenGate ensures the cross-platform replication and migration with zero-downtime. Active Dataguard requires the configuration to have same editions of database on the same operating platform on both primary and secondary environment. That means any cross-platform migration or replication is not provided by Active Dataguard.
5. Version backward Compatibility: GoldenGate is flexible enough to support the previous releases for replicating data from a newer version or release. This means that the data of Oracle 11g can be replicated on a Oracle 10g database.
Depending upon the requirements we can chose the replication technology. Even though we see the two different technologies separately there are some high availability architecture where both can be used.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Analyst & BI Specialist at ABS SCANDINAVIA ApS
Fast and efficient replication between central and local repositories
Pros and Cons
- "This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
- "I find the user interface to be difficult for non-technical people."
What is our primary use case?
We implement this solution for our customers, and our most recent deployment was for a client in France. The solution involved one central database and ten replicas that were distributed to the local offices. The central database is automatically updated as the replicas are changed, and similarly, when the central database is modified, each of the local copies is updated accordingly.
How has it helped my organization?
Using this solution has improved both the speed and efficiency of the data replication process. Prior to this, I used packages with merge functionality for replication. The process was very slow, and sometimes had negative effects on the production database. This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.
What is most valuable?
The most valuable feature is the CDC (Changed Data Capture), which captures only the changes that are made to the data. This has the lowest load on the production database, and it runs very quickly in the background.
Reading directly from the log file makes updating the databases very fast.
What needs improvement?
I find the user interface to be difficult for non-technical people. It was suggested to me that I use the command prompt, which is fine for me because I am a technical person. However, when showing others, such as managers, how to use the product to provide details such as the system status, it is a bit difficult.
The inclusion of monitoring and management tools would be very nice.
The Oracle documentation is very complex, and some of the documents are very long. I prefer to use sites that are on the topic of Oracle, but in fact, are not run by Oracle itself.
In our experience, there is zero technical support for this solution.
For how long have I used the solution?
Between four and five years.
What do I think about the stability of the solution?
This is a very stable solution, and I haven't had any problem with the tools.
What do I think about the scalability of the solution?
This solution scales easily. It's dependent on the files and configuration, and you can do anything you want.
This solution is being used on a daily basis. We have approximately one thousand users on the production database, including both developers and end-users. We do have plans to increase our usage, although the interface for monitoring and managing becomes difficult to use when it grows to a certain point.
How are customer service and technical support?
I have contacted technical support, but could not get any support. I would say that the support is zero.
Which solution did I use previously and why did I switch?
Prior to this solution, we had a package that used an SQL process. It had come from Oracle Scheduler. We switched because it negatively impacted our production database, making it very slow. If there was downtime and the production database had transactions then it would take days to recover from the lag.
How was the initial setup?
The initial setup of this solution is of medium difficulty. It is not straightforward; however, it is not as complex as it looks.
For a single deployment that has two sites, I would expect the process to take less than two hours, although it depends on the complexity of the replication.
An example of a more complicated configuration is where only a subset of the tables are being replicated, and the flow of data is different in both directions. Setting this up can take a very long time, and incur a large cost because of coding time.
We have three people to manage and maintain this solution. This includes making changes to the database. For the monitoring and altering, one person is sufficient and it will not take one hundred percent of their time.
What about the implementation team?
We handled the implementation of this solution in-house.
What's my experience with pricing, setup cost, and licensing?
We do like the price of this solution.
Which other solutions did I evaluate?
We did not evaluate other options when we chose this solution, although I am now considering other tools.
What other advice do I have?
This solution is priced well, is fast, and doesn't have any impact on our production database.
I would rate this solution and eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
Senior Manager of IT at a tech company with 51-200 employees
Data replication is seamless but time to value can be long
Valuable Features:
Data replication is seamless, once it is setup on a database. No triggers to setup.
Room for Improvement:
Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
As far as I know, there is a feature called Syncfile in Goldengate. Do you know if this feature can be used for E-business suite file synching? Thank you.
DBA
Transforms data in real-time from one database to many or from many to one
Pros and Cons
- "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."
- "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."
What is our primary use case?
The primary usage of the product is to transform data from one database to another, for an application.
How has it helped my organization?
If you have one environment that is for some application and it has a lot of data, and you need this information not only for the application but also for a warehouse - to do some analytics later - you just transform all that data to the warehouse and then you can work with it.
What is most valuable?
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. In my experience, it is able to transform a large amount of data within a few seconds.
What needs improvement?
I would like it to be simplified, easier to manage.
What do I think about the stability of the solution?
This is the tricky part. 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.
Maybe they can simplify it. You learn the tool, you learn how to work with it. Now we have a very stable environment but it took like a few months until it became stable.
What do I think about the scalability of the solution?
You have scalability. If you have a database and you have all sorts of objects inside and you want to transform them, you can add more objects.
What other advice do I have?
I would recommend Oracle GoldenGate, of course.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solutions Developer at a music company with 51-200 employees
We're able to use it for real-time ETL and implementation of zero-downtime migrations, but it needs a wizard for table replication.
Valuable Features
- Replication by SCN
- Ability to perform basic data transformation/call user-defined functions
- Exception handling
- CDC capabilities when used with ODI
Improvements to My Organization
- Ability to implement zero-downtime migrations
- Ability to scale horizontally
- Ability to use ODI and Goldengate for real-time ETL
Room for Improvement
Current features:
None
New features:
Offer basic process monitoring out-the-box
Offer a (CLI) wizard for quickly creating and configuring (extract, pump, replicat) table replication
Use of Solution
3 years
Deployment Issues
Base versions where a bit buggy particularly during recovery after there were machine/host crashes or unexpected shutdowns. Latest patches/versions resolved these issues.
Stability Issues
Only in Windows were there a few GoldenGate crashes, but we suspect these were due to insufficient memory.
Scalability Issues
No, although we haven't applied parallelism to any of our processes yet.
Customer Service and Technical Support
Customer Service:
Very good. I have often spoken directly with support personal and P1 issues are handled swiftly.
Technical Support:Excellent for above P3.
Initial Setup
Straightforward
Implementation Team
Initially through a vendor, Michael Rainey from RittmanMead, and we were able to support the product on our own after that. Michael's level of expertise is very high.
ROI
Hard to calculate, but GoldenGate offers an excellent ROI if you use the product cleverly.
Pricing, Setup Cost and Licensing
NA
Other Solutions Considered
No
Other Advice
Reduce the price to compete with products like DBVisit because once customers see the power behind this product, they will be locked in forever.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solutions Architect Manager at a tech services company with 51-200 employees
Good data replication capabilities, but integration and technical support need to be improved
Pros and Cons
- "When we are replicating data between similar databases then it is straightforward."
- "The process of transforming the data between two different databases is inefficient and needs to be improved."
What is our primary use case?
We are a reseller, and we implement this solution for our clients. They are generally either government or financial institutions. These clients use other Oracle technologies for tasks such as identity management and business intelligence. This solution is used to replicate the data for purposes such as disaster recovery and high availability.
What is most valuable?
The most valuable feature of this solution is data replication. When we are replicating data between similar databases then it is straightforward.
What needs improvement?
We are having a challenge in that we want to replicate different types of data, from one database to another, that have different types of elements. The process of transforming the data between two different databases is inefficient and needs to be improved.
Technical support for this solution could be improved.
The integration is not straightforward and should be made simpler.
For how long have I used the solution?
We have been using this solution for two years.
What do I think about the stability of the solution?
This solution is stable and we aren't facing any issues.
What do I think about the scalability of the solution?
Scalability of this solution depends on the licensing from Oracle.
How are customer service and technical support?
We have had trouble with the Oracle technical support. When we need them to reply to us, we need to open a 24/7 ticket. If we open a critical ticket instead, then nobody replies and it takes a lot of time. Consequently, whenever we are facing an issue and we need to open a Service Request (SR), we use the 24/7 support. This leads to three people working in parallel to resolve our problem. Otherwise, we will not get a resolution.
How was the initial setup?
The initial setup of this solution is straightforward. For the installation, you need only follow the steps in the documentation.
What's my experience with pricing, setup cost, and licensing?
There are a lot of tricks when it comes to licensing.
What other advice do I have?
This is a good solution for data replication, but there are some areas that need to be improved.
I would rate this solution a seven out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Product Categories
Data IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
AWS Glue
Teradata
MuleSoft Anypoint Platform
Oracle Data Integrator (ODI)
webMethods.io
Talend Open Studio
Confluent
IBM InfoSphere DataStage
AWS Database Migration Service
Palantir Foundry
SAP Data Services
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?
Helpful because it explained the details in an appropriate manner.