TDV Adapter for JSON

Build 22.0.8462

Parsing Hierarchical Data

The adapter offers three basic configurations to model object arrays as tables, described in the following sections. The adapter will parse the JSON document and identify the object arrays. Or, set JSONPath to specify the object arrays you want to model 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 a JSON document. Nested object arrays are returned as JSON strings.
See Modeling JSON Data to configure column discovery or customize the detected schemas.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462