Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with SFTP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SFTP, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for SFTP Stored Procedures
| Name | Description |
| DeleteFile | Deletes a specified file from the remote SFTP server. This is useful for removing outdated or unneeded files from a given directory. |
| Download | Transfers files from a remote SFTP server to the local system, allowing both individual file retrieval and larger workflows for synchronizing remote data locally. |
| MoveFile | Moves a file from one directory to another on the remote SFTP server, preserving the file but changing its location. |
| RenameFile | Renames a file on the remote SFTP server without altering its contents or location. |
| Upload | Transfers a file from the local system to the remote SFTP server, making it available for downstream processes or users. |