The CData Excel Add-In for SFTP models SFTP data as an easy-to-use SQL database with tables and stored procedures. Any changes to the remote data are immediately reflected in your queries, and the table definitions are dynamically retrieved.

The add-in uses the SFTP API to process supported filters. The add-in processes other filters client-side within the add-in.

• The Tables section, which details standard SQL tables, contain samples of what you might have access to in your SFTP account.
• Stored Procedures are actions that are invoked via SQL queries. They perform tasks that extend beyond merely downloading, uploading files, and sending protocol commands to the server.