Senior Manager at PricewaterhouseCoopers
Real User
Good data replication capability and technical support
Pros and Cons
  • "The most valuable feature is data replication capability."
  • "It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."

What is our primary use case?

I am part of a consulting firm and we build database solutions for our customers. Oracle GoldenGate is one of the products that we assist our clients with.

It is primarily used to replicate data from the main database to a backup server.

What is most valuable?

The most valuable feature is data replication capability.

What needs improvement?

It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure.

For how long have I used the solution?

One of our clients began using Oracle GoldenGate in 2013 and a second client started with it in 2018.

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.
770,141 professionals have used our research since 2012.

What do I think about the stability of the solution?

Oracle GoldenGate is pretty much stable.

What do I think about the scalability of the solution?

I haven't encountered any issues in terms of scalability.  We are working with solutions where there is not much in terms of scope.

How are customer service and support?

Technical support from Oracle is good. We were able to get help and good advice from them.

How was the initial setup?

The initial setup was complex. It took a lot of time to get it stabilized.

What's my experience with pricing, setup cost, and licensing?

The price of this solution is good.

What other advice do I have?

Oracle GoldenGate is a product that I would recommend.

I would rate this solution a nine 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.
PeerSpot user
Armando Souza - PeerSpot reviewer
Oracle Solutions Architect at Viceri
Real User
Top 5
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.
PeerSpot user
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.
770,141 professionals have used our research since 2012.
Senior Manager of System and Database at ESL
Reseller
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?

The solution in our organization is not used for execution. We use it for a few schedules and to replicate in different databases.

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.

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 technical 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
PeerSpot user
Jon Davies - PeerSpot reviewer
Director at a healthcare company with 11-50 employees
Vendor
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
PeerSpot user
it_user837 - PeerSpot reviewer
Senior Manager of IT at a tech company with 51-200 employees
Real User
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.
PeerSpot user
it_user4401 - PeerSpot reviewer
it_user4401Developer at a transportation company with 1,001-5,000 employees
Vendor

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.

See all 2 comments
Fintech Project Manager at a comms service provider with 10,001+ employees
Real User
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.
PeerSpot user
it_user90060 - PeerSpot reviewer
Team Lead at a retailer with 10,001+ employees
Vendor
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.
PeerSpot user
Oracle Advisory Engineer at a tech services company with 11-50 employees
Real User
Top 20
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?

We use the solution for data recovery and integration with multiple databases.

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.

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
PeerSpot user
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Integration
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.