I was joined by Shan Nawaz of Verisign last Thursday morning
for a great session covering best practices and advanced features of Oracle
GoldenGate. Despite the rain; people recovering from the previous nights
festivities; and coinciding with a whole bunch of cloud sessions and demos; we
had pretty amazing attendance.
I kicked off by giving an overview of Oracle Data
Integration and a quick crash course on Oracle GoldenGate for the few in the
audience not familiar with out technology.
After that, I handed over to Shan, who did a terrific job
covering some of the best practices for getting optimal performance out of Oracle
GoldenGate. He started off with an image that truly summarizes the difference
GoldenGate can make to an enterprise:
Shan then moved on to cover a number of philosophies and
techniques that he had used successfully to maximize the potential of Verisign’s
investment in Oracle GoldenGate, including:
sure you understand what the data integration requirements are before you
start. What is the primary objective of using GoldenGate? What is the
maximum throughput you expect, and maximum latency you can accept? If you
don’t know these things, you won’t be able to measure success.
when you might need to consider parallel data streams to handle maximum
load, and what functionality is available to help you achieve that.
the impact of I/O on GoldenGate processes and architecting solutions to
the performance of the GoldenGate Capture, Pump and Delivery processes and
optimal tuning of network components.
This was followed by my Advanced Features portion of the
session, in which I highlighted some of the less commonly known aspects of
Oracle GoldenGate functionality. I covered:
Event Marker Infrastructure – which allows GoldenGate processes to take
specific actions whenever they encounter certain database records
File Integration – which adds micro-batch file delivery capabilities to
Integration – which enables GoldenGate to invoke Java APIs based on
database events; and provides capture and delivery of data using a JMS
Finally, I gave a preview of some future (next calendar
year) functionality that aims to enable Oracle GoldenGate to directly integrate
with Oracle Coherence and Oracle TopLink to allow database changes to
immediately trigger cache changes. This should help solve a number of use-cases
where cached data may become stale if the underlying data changes.
With so much content, we didn’t have much time for Q&A,
but still managed to have quite a lively, if brief, Q&A session. Shan had
to leave quickly to catch an international flight, but still graciously
answered some in-depth questions and swapped contact information with another
customer so they could continue the conversation off-line.
It was a pleasure to present with Shan, and I am looking
forward to similar sessions at Oracle OpenWorld 2012.