Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with MongoDB.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from MongoDB, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for MongoDB Stored Procedures
| Name | Description |
| AddDocument | Inserts a JSON document into a MongoDB collection without modification, preserving its original structure. |
| CreateSchema | Generates a schema file based on the structure of a specified MongoDB collection, defining fields and data types. |
| CreateUserTable | Creates a schema definition for a MongoDB collection, mapping document structure to a tabular format. |
| GetDocument | Executes a pass-through query to retrieve specific documents from a MongoDB collection, allowing for advanced filtering and projection. |
| SearchDocument | Retrieves an entire MongoDB document as a JSON-formatted string, maintaining its native structure. |