Specifying a Schema Definition Using Connection Properties

If a valid schema definition for the connection already exists in the database or in a JSON file, you can configure the connector to use it.

Note:

Schema definitions that were created using connector version 1.1.2 or earlier are not supported, and must be recreated. For more information, see Creating a Schema Definition Using Connection Properties.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN.

To specify a schema definition using connection properties:

  1. Depending on where the schema definition is stored, do one of the following:
    • To use a schema definition that is stored in the Couchbase database, connect to the database without specifying the LocalSchemaFile property.
    • Or, to use a schema definition that is stored in a JSON file, set the LocalSchemaFile property to the full path and name of the file and then connect to the database.
  2. Set the SchemaMapOperation property to 0.

When you connect to the database using the settings described above, the connector uses the specified schema definition to map the Couchbase data to an ODBC-compatible format.