Table of Contents

Search

  1. Preface
  2. PowerExchange CDC Publisher Overview
  3. Installing and Upgrading PowerExchange CDC Publisher
  4. PowerExchange CDC Publisher Key Concepts
  5. PowerExchange Change Capture Environment
  6. Target Messaging Systems
  7. Configuring PowerExchange CDC Publisher
  8. Streaming Change Data
  9. Monitoring PowerExchange CDC Publisher
  10. Administering PowerExchange CDC Publisher
  11. Command Reference for the Command-Line Utilities
  12. Avro Schema Formats
  13. Message Reference

User Guide

User Guide

Avro Generic Schema Format

Avro Generic Schema Format

An Avro schema that uses the generic format can be used for any source table. The schema represents the source columns as an array of fields for data and metadata. Most of the columns have the type "string" to be generic across multiple source table types. The column name and type is included in every Avro message along with the data.
A generic schema has the following format:
{"name" : "columns", "type" : [ "null", { "type" : "array", "items" : { "type" : "record", "name" : "column", "doc" : "A column for the table", "fields" : [ {"name" : "name", "type" : [ "null", "string" ], "default" : null}, {"name" : "value", "type" : [ "null", "string" ], "default" : null}, {"name" : "isPresent","type" : [ "null", "boolean" ],"default" : null}, {"name" : "beforeImage","type" : [ "null", "string" ], "default" : null}, {"name" : "isPresentBeforeImage", "type" : [ "null", "boolean" ], "default" : null} ] } } ]

0 COMMENTS

We’d like to hear from you!