The CData ADO.NET Provider 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 provider uses the SFTP API to process supported filters. The provider processes other filters client-side within the provider.

• 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.