Striim 3.10.1 documentation

GG Trail Reader properties

To rewrite an application using FileReader + GG Trail Parser to use GG Trail Reader, copy the values for the deprecated old properties to the corresponding new properties:

  • FileReader Compression Type > GG Trail Reader Trail Compression type

  • FileReader Directory > GG Trail Reader Trail Directory

  • FileReader Wildcard > GG Trail Reader Trail FIle Pattern

  • GG Trail Parser Metadata > GG Trail Reader Definition File

property

type

default value

notes

Charset Map

String

Optionally, override the GoldenGate source character set mapping (see SOURCECHARSET using the syntax <character set 1>,<Java charset 1>;<character set 2>,<Java charset 2>;....

Compression

Boolean

False

If set to True, update operations for tables that have primary keys include only the primary key and modified columns, and delete operations include only the primary key. With the default value of False, all columns are included.

DB Charset ID

String

When the database does not use the ASCII character set, specify the character set here, for example, Cp037. When this property is specified, the Support Column Charset setting is ignored.

Definition File

String

With GoldenGate version 12.2 or later, leave this property blank to read the metadata from the trail file.

Otherwise, specify the path (from root or relative to the .../Striim directory) and name of a GoldenGate source definition file (generated by the GoldenGate defgen utility) containing the metadata description of all the tables for which trail data was captured.

Exclude Tables

String

If a wildcard is specified for Tables, any tables specified here will be excluded from the query. Specify the value as for Tables.

Filter Transaction Boundaries

Boolean

True

With the default value of True, begin and commit transactions are filtered out. Set to False to include begin and commit transactions.

Start Position

String

Optionally, specify an offset (FileName:<filename>; offset:<offset>) or RBA value (FileName:<filename>; RBA:<RBA value>) from which to start reading the trail file(s).

Support Column Charset

Boolean

False

Use the default value of False when all columns use the ASCII character set.

Set to True if the data contains a mix of ASCII and non-ASCII columns. The DEFGEN must include the database locale and character set and the character set for each column. When a character set is specified using the DB Charset ID property, this setting is ignored.

Tables

String

%

The table(s) to be read. With the default value, all tables will be read. Alternatively, specify one or more table names, separated by semicolons, or a string ending with the % wildcard, such as HR.%.

Trail Byte Order

String

BigEndian

Set to LittleEndian if that is the TRAILBYTEORDER of the trail file.

Trail Compression Type

String

Set to gzip when Trail File Pattern specifies a file or files in gzip format. Otherwise, leave blank.

Trail Directory

String

Specify the path to the directory containing the trail files.

Trail File Pattern

String

Specify the name of the file, or a wildcard pattern to match multiple files. When reading multiple files, Striim will read them in the default order for the operating system. Once Striim has read a file, it will ignore any further updates to it.

Sample:

CREATE SOURCE GGTrailSource USING GGTrailReader (
  TrailDirectory:'Samples/GG/data',
  TrailFilePattern:'rt*',
  DefinitionFile:'Samples/GG/PosAuthorizationsDef.def'
)
OUTPUT TO GGTrailStream;