This chapter has provided an overview of the advanced configuration options that GoldenGate has to offer. We started with data selection using the WHERE and FILTER clauses before moving on to data mapping, exploring the COLMAP option and the DEFGEN utility. We discussed data transformation and the vast array of functions and tools available and discovered that if GoldenGate does not provide a function or mapping specific to our requirements; we can write our own in PL/SQL, C, or C++. The GoldenGate product provides the necessary call interface to stored procedures and external routines to satisfy the most discerning developer.

You also learned the flexibility and performance benefits when GoldenGate is configured with Oracle Data Integrator, enabling real-time access to real-time information.

In the next chapter, you will learn how to measure and report on your GoldenGate environment. Here, we will discover the on demand and automated procedures for statistics and process monitoring offered by GoldenGate along with how to leverage Oracle Enterprise Manager Cloud Control 12c Metric Extensions to enable effective system management.