How To Include OGG User Tokens In Filewriter Output File? (Doc ID 2772267.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Please advise on how to include OGG user tokens in OGG for BigData filewriter output files.

The OGG capture from the Oracle source database is configured to write user tokens to the trail files, and the user tokens can be verified using the logdump tool. 

The following parameters are set in the properties file of OGG replicat to filewriter:

gg.handlerlist=filewriter
gg.handler.filewriter.type=filewriter
...
gg.handler.filewriter.includeTokens=true
gg.includeggtokens=true

But the user tokens do not get included in the filewriter output files.

The OGG for BigData filewriter version is:

---------------------
Oracle GoldenGate for Big Data
Version 19.1.0.0.8 (Build 002)
Oracle GoldenGate Command Interpreter
Version 19.1.0.0.210228 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_210212.1752.2
Linux, x64, 64bit (optimized), Generic on Mar 18 2021 07:13:36
---------------------

Question: What is missing in order to include the user tokens in the filewriter output files?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.