By Irem Radzik on Sep 13, 2012
Yesterday morning we had two launch webcasts for Oracle GoldenGate 11g Release 2. I had the pleasure to present, as well as moderate the Q&A panels in both of these webcasts. Both events had hundreds of live attendees, sending us over 150 questions. Even though we left 30 minutes for Q&A, it was not nearly enough time to address for all the insightful questions our audience sent. Our product management team and I really appreciate the interaction we had yesterday and we are starting to respond back with outstanding questions today.Oracle GoldenGate’s new release launch also had great welcome from the media. You can find the links for various articles on the new release below:
Integration Developer News, Oracle GoldenGate Adds Deeper Oracle Integration, Extends Real-Time Performance
In this blog, I want to address some of the
frequently asked questions that came up during the webcasts. You can find the top questions and their answers
along with related resources below. We will continue to address frequently asked questions via future blogs.
Q: Will the new Integrated Capture for Oracle Database replace the Classic Capture? If not, which one do I use when?
A: No, Classic Capture will be around for long time. Core platform specific features, bug fixes, and patches will be available for both Capture processes.Oracle Database specific features will be only available in the Integrated Capture. The Integrated Capture for Oracle Database is an option for users that need to capture data from compressed tables or need support for XML data types, XA on RAC. Users who don’t leverage these features should continue to use our Classic Capture.
For those of you coming to OpenWorld, please attend the related session:
Extracting Data in Oracle GoldenGate Integrated Capture Mode, Monday Oct 1st 1:45pm Moscone South – 102
to learn more about this new feature.
Q: What is new in Conflict Detection and Resolution? And how does it work?
A: There are now pre-built functions
to identify the conditions under which an error occurs and how to handle the
record when the condition occurs. Error conditions handled include inserts into
a target table where the row already exists, updates or
deletes to target table rows that exist, but the original source data (before
columns) do not match the existing data in the target row, and updates or deletes where the row does
not exist in the target database table.For
each of these conditions a method to handle the error is specified.
Also, for those attending OpenWorld please attend the session:
Best Practices for Conflict Detection and Resolution in Oracle GoldenGate for Active/Active- Wednesday Oct 3rd 3:30pm Mascone 3000
Q: Does Oracle GoldenGate Veridata and the Management Pack require additional licenses, or is it incorporated with the GoldenGate license?
A: Oracle GoldenGate Veridata and Oracle Management Pack
for Oracle GoldenGate are additional products and require separate licenses. Please check out Oracle's price list here.
Q: Does GoldenGate - Oracle Enterprise Manager Plug-in require additional license?
A: Oracle Enterprise Manager Plug-in is included in the Oracle Management
Pack for Oracle GoldenGate license, which is separate from Oracle GoldenGate
license. There is no separate license for the Enterprise Manager Plug-in by
itself. Oracle GoldenGate Monitor, Oracle GoldenGate Director, and Enterprise Manager Plug-in are included in the Management Pack for Oracle GoldenGate license. Please check out Management Pack for Oracle GoldenGate data sheet for more info on this product bundle.
Q: Is Oracle GoldenGate replacing Oracle Streams product?
A: Oracle GoldenGate is the strategic data replication product. Therefore, Oracle Streams will continue to be supported, but will not be actively enhanced. Rather, the best elements of Oracle Streams will be added to Oracle GoldenGate. Conflict management is one of them and with the latest release Oracle GoldenGate has a more advanced conflict management offering. Current customers depending on Oracle Streams will continue to be fully supported.
Q: How is Oracle GoldenGate different than Oracle Data Integrator?
Data Integrator is designed for fast bulk data movement and transformation
between heterogeneous systems, while GoldenGate is designed for real-time movement
of transactions between heterogeneous systems. These two products are completely
complementary where GoldenGate provides low-impact real-time change data capture and delivery
to a staging area on the target. And Oracle Data Integrator transforms this
data and loads the DW tables. In fact, Oracle Data Integrator integrates with
GoldenGate to use GoldenGate’s Capture process as one option for its CDC
mechanism. We have several customers that deployed GoldenGate and ODI together
to feed real-time data to their data warehousing solutions. Please also check out Oracle Data Integrator Changed Data Capture with Oracle GoldenGate Data Sheet (PDF).
Thank you again very much for welcoming Oracle GoldenGate 11g Release 2 and stay in touch with us for more exciting news, updates, and events.