JDBC Driver for Couchbase

Build 20.0.7654

Data Model

Depending upon the connection settings being used, the driver can present several different mappings between Couchbase entities and relational tables and views. For more details on each of these capabilities, refer to the NoSQL portion of this documentation.

  • When connecting to the N1QL query service, the driver models Couchbase buckets as relational tables. In addition, if TypeDetectionScheme is set to DocType or Infer, the driver will present different document flavors in each bucket as their own tables.
  • When connecting to the Analytics service, the driver models Couchbase datasets as relational views. The driver can retrieve datasets from all available dataverses or just one, based upon the value of the Dataverse property.
  • When connecting with either service, the driver can also expose arrays of data within a bucket as their own tables or views.

All of the schemas provided by the driver are dynamically retrieved from Couchbase, so any changes in the buckets or fields within Couchbase will be reflected in the driver the next time you connect.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654