Parsing Hierarchical Data
The connector offers three basic configurations to model nested data in XML as tables.
- 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 an XML document. Nested object arrays are returned as XML aggregates.