Data Model
The connector models the directories available over FTP as relational tables. Any changes to the remote data are immediately reflected in your queries, and the table definitions are dynamically retrieved from FTP when you connect.
The connector uses the FTP API to process supported filters, while unsupported filters are handled client-side.
- Tables specify which models can be modified and which are read-only. Modifiable models are represented as tables, allowing for reading, inserting, updating, and deleting data.
- Stored Procedures are function-like interfaces to the data source. You can use them to download files, upload files, and send protocol commands to the server.