Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with CSV.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from CSV, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for CSV Stored Procedures
| Name | Description |
| CopyFile | Copies a specified file from a local directory or supported cloud-storage provider to another location. This procedure is useful for automating data migration and replication tasks in workflows that rely on multiple storage environments. |
| CreateSchema | Generates a schema file for the current data source. This procedure defines the structure of tables, views, and columns to enable consistent mapping and metadata management for CSV-based integrations. |
| DeleteFile | Removes a file from a local folder or supported cloud-storage provider. This procedure helps maintain storage hygiene by programmatically deleting obsolete or temporary files from integrated systems. |
| DownloadFile | Retrieves and downloads a file from a cloud-storage location or remote source to a specified local directory. This procedure supports automation of data retrieval and backup operations. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with data sources using OAuth. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL used for authentication with data sources using OAuth. |
| ListFiles | Returns a list of available CSV or related data files within a designated local or cloud-based directory. This procedure enables browsing, validation, or synchronization of available files before data processing or import operations. |
| MoveFile | Transfers a file from one location to another within local or supported cloud storage. This procedure is useful for reorganizing file structures or moving processed files to archival or staging areas. |
| RefreshOAuthAccessToken | Exchanges a refresh token for a new access token. |
| UploadFile | Uploads a file from a local system to a designated destination, such as a cloud-storage service or remote data repository. This procedure supports data publishing, synchronization, and integration workflows. |