Depending upon the connection settings being used, the connector 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 connector models Couchbase buckets as relational tables. In addition, if TypeDetectionScheme is set to DocType or Infer, the connector will present different document flavors in each bucket as their own tables.
- When connecting to the Analytics service, the connector models Couchbase datasets as relational views. The connector can retrieve datasets from all available dataverses or just one, based upon the value of the Dataverse property.
- When connecting with either service, the connector can also expose arrays of data within a bucket as their own tables or views.
All of the schemas provided by the connector are dynamically retrieved from Couchbase, so any changes in the buckets or fields within Couchbase will be reflected in the connector the next time you connect.