Working with Schema Definitions Using Connection Properties

Connections to Couchbase require a schema definition that can map the denormalized data to a relational form. To create and work with schema definitions, you can use the Schema Editor application that is included with the connector. As an alternative, if you need to interact with schema definitions without using the application, you can use connection properties to configure the connector to operate on schema definitions.

The Simba Couchbase ODBC Driver provides connection properties that enable you to create, import, export, and delete schema definitions. You can set these properties in a connection string or in a DSN (the odbc.ini file). However, you must use the Schema Editor application if you want to make specific changes in the schema definition such as mapping a column to a different data type. The Schema Editor also supports all the functionalities that the connection properties provide. For information about how to use the Schema Editor, see the Schema Editor User Guide located in the installation directory of the connector.

The following topics describe how to work with schema definitions using connection properties:

• Creating a Schema Definition Using Connection Properties
• Specifying a Schema Definition Using Connection Properties
• Importing a Schema Definition Using Connection Properties
• Exporting a Schema Definition Using Connection Properties
• Deleting a Schema Definition Using Connection Properties