Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE 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 Tableau 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.