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