Summary

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, ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.