Data Model
The CData Tableau Connector 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 connector uses the SFTP API to process supported filters. The connector processes other filters client-side within the connector.
- 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.