1.1 Oracle GoldenGate Overview

Oracle GoldenGate for HP NonStop has modular architecture that gives you the flexibility to extract and replicate selected data records and transactional changes across a variety of heterogeneous applications and platforms.

You can configure Oracle GoldenGate for HP NonStop to manage data from multiple, heterogeneous sources and targets. Oracle GoldenGate for HP NonStop contains features that enables your business to manage data at the transaction level across the enterprise.

1.1.1 Oracle GoldenGate Configuration

Oracle GoldenGate offers flexibility in configuring your transaction management system, supporting both homogeneous and heterogeneous data replication. This lets you configure Oracle GoldenGate to capture and deliver data to best suit your operating environment. Options include:

  1. One-to-one, from a single source to a single target

  2. One-to-many, from a single source to multiple targets

  3. Many-to-one, from multiple sources to a single target

  4. Bi-directional, between a single source and a single target

In doing so, the following business needs can be met:

  • Change synchronization, supporting both online and batch change synchronization for Transaction Management Facility (TMF)-enabled and non-TMF-enabled applications.

    • Online change synchronization continuously processes incremental data changes.

    • Batch change synchronization processes change records that are generated during specific periods of time.

  • Initial load, extracting complete records directly from a source file or table, then loading them into the target. You can use initial load to populate the target and to synchronize the source and target for change synchronization.

  • Data distribution, sending extracted records to more than one target.

1.1.2 Oracle GoldenGate Features

Oracle GoldenGate features let you select, map, and transform data so it can be used for a variety of applications. You can configure Oracle GoldenGate to integrate and convert data by selecting data based on filtering criteria. You can implement custom logic so Oracle GoldenGate works seamlessly with your own applications.

For example, you can configure the activities of Oracle GoldenGate by:

  • Configuring data selection to deliver only required records, filter records to extract specific column data, and control which types of operations are extracted

  • Mapping named source files and tables to the target when the target has similar formats but different file or table names

  • Splitting single rows into multiple rows and combining rows from different tables to a single table

  • Implementing data transformations to:

    • Convert dates from one format to another

    • Perform arithmetic calculations

    • Transform DML operations, such as converting delete operations into insert operations on the target table

You can also configure Oracle GoldenGate to run your custom programs and frequently-used routines with user exits, macros, and obey files. These features increase the flexibility of Oracle GoldenGate by:

  • Inserting user exits to call your applications and/or custom data management logic

  • Using macros to implement multiple uses of a statement, consolidate multiple commands, and call other macros

  • Automating frequently-used routines by using the OBEY command, which instructs Oracle GoldenGate to process parameters specified in another parameter file.

The modular architecture of Oracle GoldenGate lets you implement just the components you need. These components are introduced in the next section.