Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Couchbase.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Couchbase, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components 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 |
| CreateSearchIndex | Creates a search index with the Search Service API in Couchbase. |
| 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) |
| ExecuteSearchIndex | Execute a search on an index using the Search Service API in Couchbase. |
| 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. |