SSIS Components for Avro

Build 21.0.7930

Parsing Hierarchical Data

The component offers three basic configurations to model object arrays as tables, described in the following sections. The component will parse the document and identify the object arrays.

  • Flattened Documents Model: Implicitly join nested object arrays into a single table.
  • Relational Model: Model object arrays as individual tables containing a primary key and a foreign key that links to the parent document.
  • Top-Level Document Model: Model a top-level view of a document. Nested object arrays are returned as strings.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930