This section details a selection of advanced features of the SFTP component.

User Defined Views

The component supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

Firewall and Proxy

Configure the component for compliance with Firewall and Proxy, including Windows proxies. You can also set up tunnel connections.

Query Processing

The component offloads as much of the SELECT statement processing as possible to SFTP and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.