User Guide

1.1
- 1.3
- 1.2
- 1.0

Back Next

Reporting the Avro Format Definitions for Source Tables

Use the PwxCDCAdmin utility with the REPORT=FORMAT parameter to generate the Avro format definitions, or schemas, for all source tables or a specific source table in the \instance
\reports subdirectory.

The generated format definitions are available in a legible format for viewing and can be used by consumer applications to read the messages that the PowerExchange CDC Publisher sent to the target messaging system. The generated schemas reflect the flat, nested, or generic format that you set in the Formatter.avroSchemaFormat parameter setting in the cdcPublisherAvro.cfg configuration file.

Before you issue the PwxCDCAdmin command, ensure that the PowerExchange CDC Publisher process is running in a separate command line window.

At the command prompt, enter the PwxCDCAdmin command with the REPORT=FORMAT and TABLE parameters.

You can issue the command from the

pwxcdcpub_root_installation\bin

subdirectory or from another location if you specified the PWXPUB_HOME environment variable.

In the TABLE parameter, indicate whether to generate the schemas for all tables or a specific table. Also include the optional INSTANCE parameter if you are running the PwxCDCPublisher process using an instance other than the default "instanceA" at

/pwxcdcpub_root installation/instanceA

Use the following syntax:

PwxCDCAdmin REPORT=FORMAT TABLE={ALL|mapname_tablename} [INSTANCE=override_instance_directory]

In this syntax, mapname_tablename is the map name and table name portion of the extraction map name, where the extraction map name has the format xnninstance.
mapname_tablename
. For more information about the command syntax, see PwxCDCAdmin Utility - Command and Parameters.

To verify that the Avro format definitions were generated for the source tables or table, check the reports subdirectory under the instance that you are using.

Rename Saved Search

Table of Contents

User Guide

User Guide

Reporting the Avro Format Definitions for Source Tables

Reporting the Avro Format Definitions for Source Tables