Last week I hosted a webcast on Oracle GoldenGate 12c's latest features and its solutions for cloud environments. For those of you who missed it, I wanted to give a quick recap and remind that you can watch it on-demand via the following link:
Oracle GoldenGate 12c for the Enterprise and the Cloud
In this webcast my colleague Chai Pydimukkala, senior director of product management for Oracle GoldenGate and I
talked about some of the key challenges in cloud deployments and how
Oracle GoldenGate addresses them. We discussed examples of cloud-specific data integration use cases, such as synchronizing data between on-premises
systems and Oracle Cloud or Amazon Cloud environments. We also discussed
zero downtime consolidation to cloud using Oracle GoldenGate.
In the webcast, Chai also presented the latest features of Oracle GoldenGate 12.1.x including:
- New database support, including Informix, SQL Server 2014, MySQL Community Edition
- Real-time data integration between on-premises and cloud with SOCKS5 compliance
- New features in Oracle GoldenGate Veridata especially the new data repair capabilities
- Enhancements to Integrated Delivery, and support for capturing data from Active Data Guard standby system
- The new migration utility to help with the move from Oracle Streams to Oracle GoldenGate.
As with previous GoldenGate webcasts we had a very interactive Q&A where we received tons of questions. We tried answer as much as possible in the available time but could not get to all of them. Below are some of the commonly asked questions we received during the webcast and brief answers:
Question: Does GoldenGate replace ODI? When shall we use an ETL tool vs GoldenGate?
Answer: GoldenGate is designed for real-time, change data capture,
routing, and delivery. It performs basic, row level transformations.
For complex transformation requirements you still need ETL/E-LT
solutions. Our customers augment their existing ETL/E-LT solutions by
adding GoldenGate for real-time, low-impact change data capture and
delivery. GoldenGate can deliver data for ETL in flat file format, or
feed staging tables, or it can be JMS messages.Oracle Data Integrator's
E-LT architecture creates perfect combination as GoldenGate can capture
changed data non-intrusively with low-impact, and deliver to staging
tables in the target with sub-seconds latency. With ability to perform
transformations within the target (or source) database, ODI takes this
change data, performs transformations in micro-batches and loads user
tables with high performance. Because of this natural and strategic fit
between the products, we have tightly integrated ODI and GoldenGate.To learn more about how GoldenGate and ODI are integrated and work together, please watch this on-demand webcast. I also recommend reading the following white paper on real-time data warehousing best practices Here
you can see a demo of ODI and for customer examples, you can watch Paychex
, and Raymond James
Question: Is there a plan to sell GoldenGate as a service soon?
Answer: Yes, it is in the plans. We are working with the Oracle Cloud team. But we are not able to give a timeline.
Question: Are Integrated Capture and Delivery only available for Oracle Database or this can be used for non-Oracle databases?
Answer: Integrated Capture and Delivery are only available for Oracle Database and truly differentiate Oracle GoldenGate against other data integration and replication vendors. We offer Coordinated Delivery for all supported databases. Coordinated Delivery simplifies configuration significantly as well and it works with non-Oracle databases too. You can read more about Coordinated Delivery in a related blog, via Oracle GoldenGate 12c Release 1 New Features Overview white paper or documentation. Question: Is GoldenGate available for download for trial?
Answer: Yes, you can download GoldenGate on OTN for education and development purposes: http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html. For big data use case, you can use Big Data Lite virtual environment to experiment with Oracle GoldenGate.
Question: Does GoldenGate replace Active Data Guard?
No. The products are complementary. Data Guard is a physical replication solution designed for Oracle Database disaster recovery and offers it with great simplicity and performance. Oracle GoldenGate offers logical/transactional data replication which supplements Active Data Guard by eliminating downtime during planned outages (migration, consolidation, maintenance), and active-active data center synchronization for maximum availability. License for Oracle GoldenGate for Oracle Database includes also Active Data Guard. As mentioned in the webcast, GoldenGate 12c now can capture data from Active Data Guard's standby system too.
Question: Does the GoldenGate Veridata repair subset of data instead of doing full sync ? Example : I want to repair only missed deletes.
Yes. Oracle GoldenGate Veridata can do granular repair for out-of-sync records. Please see our Oracle GoldenGate Veridata data sheet for more info.
Question: How do we use Enterprise Manager for GoldenGate?
Answer: Oracle Management Pack for Oracle GoldenGate license includes a Enterprise Manager Plug-in that allows you to use your Oracle Enterprise Manager solution to monitor and manage Oracle GoldenGate solutions.
If you have not attended the webcast live, I highly recommend watching Oracle GoldenGate 12c for the Enterprise and the Cloud on demand and listening to the long Q&A session with Chai. During the webcast we covered many other frequently asked questions.