Oracle GoldenGate Initial Setup
The setup with the classic GoldenGate architecture was easy. Oracle has now moved to Microservices Architecture. It is a real pain. There are a lot of new things we have to learn. I rate the ease of setup of the classic architecture a seven out of ten. For Microservices, I rate the ease of setup a three out of ten.
The deployment takes a couple of hours. We need one system administrator to deploy the tool. We need to maintain the tool. We are a team of four people. We need at least three people for maintenance. The time taken for maintenance depends on how big the environment is. We spend a lot of time on maintenance because our environment is big.
The initial setup is a bit complicated compared to a solution such as SharePlex where you just run the installer and update one config file. GoldenGate requires a lot of configuration and there are some limitations. The initial setup took close to a week and was carried out in-house with our team.
SJ
Steve-James
Cloud Migration Software Consultant - UK & EMEA at 1PLACE
GoldenGate is quite difficult to set up. The process can take you a few days.
When it comes to maintenance and things like patch updates, it's relatively straightforward as long as you're paying the support fees. You get that as part of the license.
View full review »Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
AO
Amos Okoth
Database Manager at State of New York
We installed the product on Microservices.
View full review »I find the initial setup process of Oracle GoldenGate to be straightforward and haven't encountered any complexities with it. I would rate the easiness of the initial setup as an eight out of ten.
The deployment process for Oracle GoldenGate begins with understanding the customer's replication needs. It is essential to clarify which data to replicate and any limitations. Documentation and workflow planning follow, listing objects and target environments. For major changes like database migrations, a careful cut-over plan is crucial. The deployment time for Oracle GoldenGate varies based on the data size and initial load type, but with good connectivity, it can be quick.
Maintenance isn't difficult and mainly involves proactive monitoring to address issues before they occur. Additional attention may be needed only if businesses want to adjust configurations or address performance lags.
The deployment of Oracle Golden Gate is handled by the Oracle team. On boarding resources, such as administrators, is a requirement for the client, which may be complex for them. However, for us, it is not complex as it is not under our control.
GS
Gerson Silveira
Managing Partner at Gs Consultoria em Ti LTDA
The initial setup wasn't overly complex.
View full review »The product's initial setup phase was very simple.
The solution can be deployed in a day, and it can be installed on the cloud or on an on-premises model, as it is a simple process. It takes a day to integrate some of the tables. Sometimes, deploying the tool on an on-premises model takes a day or two because you need to install the software and the patch.
Oracle GoldenGate is simple to set up.
View full review »The complexity of the initial setup is dependent on the platform being used.
The deployment, on average, takes between two to four hours per server if we don't use packaging services like Ansible for infrastructure deployment systems.
View full review »Oracle GoldenGate's initial setup is easy.
View full review »The solution is very straightforward to set up. It's not overly complex. I'd rate the implementation process nine out of ten in terms of ease of setup.
The time it takes to deploy depends on the platform. For example, a Linux or Oracle database may take a few minutes up to one hour.
View full review »AM
Amro Mourad
Senior Oracle Database Admin at mrcc
I think that the installation of this product is very straightforward. I am sure I will encounter some problems and other issues because I installed a sample configuration of GoldenGate. This is a sample project where I have installed a huge database. It gives me the opportunity to encounter some problems and issues. I hope that I do not see any problems, but I am pretty sure I will experience some things that will go wrong.
The installation of Oracle's GoldenGate is fairly different from other similar applications. It is straightforward but at the same time more difficult. I think that is partly because other solutions will have about one-quarter of the features when compared to GoldenGate.
The initial setup is straightforward. The whole deployment can be completed in a day.
View full review »The difficulty with the initial setup depends on the type of project you are setting up. Is it a small, midsize, or large project? You have to look at the type of vertical or line of business. If the business is in banking, the solution has to be secure. In the telecom industry, fast transactions and latency come into the picture. These factors come in during enterprise design.
The initial setup is very easy with structured data because Oracle is a master in that area. However, storage becomes an issue when discussing unstructured and semi-structured data. GoldenGate does provide access to all these things, and there isn't much of a challenge from the integration perspective with the solution.
I rate the initial setup a nine out of ten.
View full review »We use the solution on Oracle’s cloud. The configuration is very easy. Anyone can do it with a click of a button. The setup does not take more than 15 to 20 minutes.
View full review »LP
reviewer1419942
Senior Database Engineer at a financial services firm with 10,001+ employees
Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration.
The implementation of the solution took approximately a few hours and if there are any issues it can take longer.
View full review »SP
reviewer1284903
Database Administrator at a manufacturing company with 10,001+ employees
It has a medium complexity level.
View full review »GO
Gurcan Orhan
Data Quality Software Development Manager at Yapı Kredi Bank
Straightforward, easy. Deployed everything within Oracle Data Integrator.
View full review »XB
reviewer2213685
Data Analysis Lead at a insurance company with 10,001+ employees
The tool's setup is straightforward. If the database is new, the deployment can take around three to five days to complete. We required one or two people to handle the tool's deployment.
View full review »We are not using Oracle GoldenGate for high-volume transactional systems which made the deployment not difficult. Moving forward we might integrate with high volume transactions systems and we could run into some challenges.
View full review »OM
Osama Mohei
Consultant at National Water Company
The initial setup is straightforward. It doesn't take too much time or effort to implement the solution.
View full review »The initial setup is simple.
View full review »PY
reviewer2147955
Application Enterprise Architect Lead at a transportation company with 10,001+ employees
The tool's setup is complicated. One engineer is enough to monitor the solution.
View full review »AE
AdelElhady
Senior Technology Consultant at a tech services company with 11-50 employees
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.
It was easy to set up.
View full review »OD
OleksandrDenysenko
Technical director at RDTEX LLC
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.
View full review »NC
Neil Chandler
Database Architect and Oracle ACE Director at Chandler Systems
I've done the initial setup of Golden Gate for many clients. It's extremely straightforward. It's probably the simplest replication tool I've ever used.
View full review »KB
reviewer1311126
Managing Partner at a tech services company with 51-200 employees
The solution’s initial setup is easy.
View full review »CF
Claudio Freire
Chief Enterprise Architect at a non-profit with 1,001-5,000 employees
OGG technology is not simple. The first setup took almost six months because we had a hard time finding OGG specialists on the market.
There are three support teams in the project. We have a support team for infrastructure management, a team of DBAs to manage the Exadata, and an operations team to manage the 3000 databases (sources). And we also have Oracle's support for bugs and problems that we encounter along the way.
View full review »AM
Amit Mataghare
Senior Manager at PricewaterhouseCoopers
The initial setup was complex. It took a lot of time to get it stabilized.
View full review »Setting up GoldenGate was straightforward.
View full review »PS
Pinak Sarkar
Senior Manager of System and Database at ESL
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.
View full review »AE
Ahmed El Banna
Fintech Project Manager at a comms service provider with 10,001+ employees
This solution is straightforward to implement with a hassle-free setup.
View full review »AZ
AnvarZhaxybayev
Oracle Advisory Engineer at a tech services company with 11-50 employees
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.
View full review »MA
reviewer1454490
Oracle ERP DBA Conultant- Oracle Super Cluster T5-8 Admin at a government with 1,001-5,000 employees
The initial setup was straightforward. It took three or four months to complete.
View full review »NM
Nafise Mohammadbeigi
Data Analyst & BI Specialist at ABS SCANDINAVIA ApS
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.
View full review »Straightforward
View full review »The initial setup of this solution is straightforward. For the installation, you need only follow the steps in the documentation.
View full review »Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.