Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT 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 Power BI Connector for MongoDB Stored Procedures
Name | Description |
AddDocument | Insert entire JSON documents to MongoDB as-is. |
CreateSchema | Creates a schema file for the collection. |
CreateUserTable | Creates a schema file for the collection. |
GetDocument | Take a pass-through query to retrieve documents. |
SearchDocument | Get the entire document as a string. |