Attribute

SchemaFormat (sfmt)

Purpose

Specifies to which model of the relational view the driver maps data.

Valid Values

0 | 1 | 2

Behavior

If set to 0 (NormalizeAll), the driver generates a normalized relational view of your data, mapping subdocuments and arrays as child tables with foreign key relationships to parent tables.

If set to 1 (Flatten), the driver generates a flattened relational view of your data, mapping subdocuments and arrays as columns within a single, comprehensive relational table for each collection.

If set to 2 (Mixed), the driver generates a normalized view of data that flattens certain objects into columns in the parent table. For example, subdocuments are mapped as columns in the parent table, while arrays and nested subdocuments are mapped to separate child tables. Refer to the "Mapping objects to tables" for details on how the mixed schema format normalizes or flattens subdocuments and arrays.

Notes

  • The setting for this option is written to the configuration file when generating the schema map. If you attempt a subsequent connection using the configuration file and specify a different value for this option, the driver will return an error.

Default Value

2 (Mixed)