Configuring Advanced Options

You can configure advanced options to modify the behavior of the connector.

For information about the configuration options available in the Simba Couchbase ODBC Driver, see Driver Configuration Options on page 1.

To configure advanced options:

  1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Advanced Options.
  2. In the Query Mode drop-down list, specify how the connector executes queries:
    • To execute all queries in SQL and then execute any failed queries in N1QL, select SQL.
    • To execute all queries in N1QL, select N1QL.
  3. In the Consistency drop-down list, specify the level of data consistency that the connector enforces during index scans.

    4. Note:

    Each setting in the connector corresponds to one of the settings available in Couchbase. For detailed information about each setting, see ScanConsistency in the Couchbase API documentation: http://docs.couchbase.com/sdk-api/couchbase-java-client-2.1.4/com/couchbase/client/java/query/consistency/ScanConsistency.html.

  4. In the String Column Length field, type the default column length to report for STRING columns.
  5. To enable load balancing and failover between nodes in a Couchbase cluster, select the Enable Load Balancing check box.
    6. Important:

    Important:

    • Couchbase Server requires at least three nodes in a cluster for failover to take effect.
    • If SSL is enabled and you are connecting to Couchbase Server prior to version 4.5, the connector does not support load balancing even if this option is enabled.
  6. To enable simulated transaction support in the connector, select Simulate Transaction Support.
  7. To use a specific schema definition for this connection, do one of the following:
    • To use a schema definition that is stored in the Couchbase database, from the Active Schema Location drop-down list, select Database.
    • Or, to use a schema definition that is stored in a local JSON file:
    1. In the Active Schema Location drop-down list, select Local Schema File.
    2. In the Local Schema File field, specify the full path of the JSON file containing the schema definition. You can manually type the path in the field, or click Choose Schema File and then browse to select the file.

    Note:

    Schema definitions that were created using connector version 1.1.2 or earlier are not supported, and must be recreated using the Schema Editor or the SchemaMapOperation connection property. For information about how to use the Schema Editor, see the Schema Editor User Guide located in the installation directory of the connector.

    • On Windows 7 or earlier, the guide is available from the Simba Couchbase ODBC Driver program group in the Start menu.
    • On Windows 8 or later, you can search for the guide on the Start screen.

    For information about using connection properties to work with schema definitions, see Working with Schema Definitions Using Connection Properties.

  8. To save your settings and close the Advanced Options dialog box, click OK.

Related topics