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.
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.
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.
One of our clients began using Oracle GoldenGate in 2013 and a second client started with it in 2018.
Oracle GoldenGate is pretty much stable.
I haven't encountered any issues in terms of scalability. We are working with solutions where there is not much in terms of scope.
Technical support from Oracle is good. We were able to get help and good advice from them.
The initial setup was complex. It took a lot of time to get it stabilized.
The price of this solution is good.
Oracle GoldenGate is a product that I would recommend.
I would rate this solution a nine out of ten.
We use GoldenGate to integrate and consolidate various databases. After this, we send the information to Oracle Cloud Analytics to generate reports.
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.
I have worked with Oracle for six years and GoldenGate for the past two.
GoldenGate is highly stable.
GoldenGate is highly scalable.
Oracle support is okay.
Setting up GoldenGate was straightforward.
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.
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.
The solution in our organization is not used for execution. We use it for a few schedules and to replicate in different databases.
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.
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.
I've been using the solution for the past three to five years.
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.
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.
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.
I've only ever worked with this solution. I haven't tried any similar solutions in the past.
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.
We're a vendor company; we help our customers with the implementation.
The cost of the solution is a bit high. It's higher than a lot of competitors.
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.
We are using it for getting data back.
It works best with Oracle.
The front-end management isn't very good.
Its pricing and licensing can also be better.
I have been using this solution for about a year.
It is very stable.
It is very scalable.
Their technical support is pretty good. I would rate them a four out of five.
It was easy to set up.
I installed it myself.
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.
I would recommend this product. It's pretty good.
I would rate it a seven out of ten.
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.
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.
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.
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.
This solution is straightforward to implement with a hassle-free setup.
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
Architecture
Extract Process – Extract DML and DDL data from source database.
We use the solution for data recovery and integration with multiple databases.
The solution's most valuable feature is its ability to integrate with multiple platforms.
The solution's performance needs improvement. It could be faster.
I have been using the solution for three years.
It is a stable solution.
I rate the solution's scalability a nine out of ten. It is suitable for enterprise businesses.
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.
Neutral
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.
Our customers take help from third-party vendors to implement the solution.
The solution is highly-priced.
The solution is reliable. I rate it a nine out of ten.
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.