2 Introducing the File Writer

This chapter provides an overview of the Oracle GoldenGate Adapter for Flat Files. This adapter provides a user exit library that is dynamically linked into an Oracle GoldenGate Extract process. The library may be a.ddl or an.so format. It is configured using a properties file so no programming is required.

This chapter includes the following sections:

2.1 Overview of the Adapter for Flat Files

Oracle GoldenGate Adapter for Flat Files outputs transactional data captured by Oracle GoldenGate to rolling flat files to be used by a third party product.

The user exit supports two modes of output:

  • DSV – Delimiter Separated Values (commas are an example)

  • LDV – Length Delimited Values

It can output data:

  • All to one file

  • One file per table

  • One file per operation code

The user exit can roll over based on time and/or size criteria. It flushes files and maintains checkpoints whenever Oracle GoldenGate checkpoints to ensure recovery. It writes a control file containing a list of rolled over files for synchronization with the supported data integration product and can also produce a summary file for use in auditing.

Additional properties control formatting (delimiters, other values), directories, file extensions, metadata columns (such as table name, file position, etc.) and data options.

2.2 Typical Configuration

The following diagram shows a typical configuration for the Oracle GoldenGate Adapter for Flat Files.

In this configuration, transactions from the source database are captured by a Primary Extract process and written to an Oracle GoldenGate trail. A data pump Extract send this trail to the Oracle GoldenGate Adapter Extract, whose associated user exit process writes the data to flat files formatted to suit a third party application.

Figure 2-1 Oracle GoldenGate for Flat File

Description of Figure 2-1 follows
Description of "Figure 2-1 Oracle GoldenGate for Flat File"