Excel Add-In for Couchbase

Build 21.0.7930

Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData Excel Add-In for Couchbase Stored Procedures

Name Description
AddDocument Upsert entire JSON documents to Couchbase as-is.
CreateBucket Creates a new bucket in CouchBase.
CreateCollection Creates a collection under an existing scope
CreateSchema Creates a schema definition of a table in Couchbase. Results may change depending of the value of FlattenObjects, FlattenArrays, and TypeDetectionScheme.
CreateScope Creates a scope under an existing bucket
CreateUserTable An internal operation used when GenerateSchemaFiles=OnCreate
DeleteBucket Deletes a bucket (and all its collections and scopes, where supported)
DeleteCollection Deletes a collection (Couchbase 7 and up)
DeleteScope Deletes a scope and all its collections (Couchbase 7 and up)
FlushBucket Removes all documents from a bucket in Couchbase.
ListIndices Lists all indices available in Couchbase
ManageIndices Creates/Drops an index in a target bucket in Couchbase.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930