This chapter focuses on the additional configuration options available in Oracle GoldenGate 12c. The powerful options discussed here allow your configuration to extend in functionality and increase in performance. We will start with a performance enhancing option, enabling SQL statements to be grouped and applied as a batch against a target database. Later, we will explore the security features, including data compression and encryption, take a look at heterogeneous environments, and finally, discuss DDL support and the tools available to monitor the DDL replication.
This chapter explains the following configuration options:
Batching SQL by operation type
Data compression techniques
Data and password encryption methods
Using the Credential Store
Triggering an action from an event
Replicating DML statements to reduce lag during batch processing
The loop and conflict detection
The DDL replication
Using utilities to migrate Oracle Streams environment to GoldenGate