TDV Adapter for SFTP

Build 22.0.8462

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Basic Tab.

Authentication


PropertyDescription
TableDepthThe depth level to display subfolders as views.
RemoteHostSet this to the host name or address of the server.
RemotePathThe current path in the SFTP server.
UserThe SFTP user account used to authenticate.
PasswordThe password used to authenticate the user.
RemotePortThe port the SFTP server is running on.
PassiveControls whether to direct the server into passive mode. Recommended if behind a firewall.

SSH


PropertyDescription
SSHAuthModeThe authentication method to be used to log on to an SFTP server.
SSHClientCertA private key to be used for authenticating the user.
SSHClientCertPasswordThe password of the SSHClientCert key if it has one.
SSHClientCertSubjectThe subject of the SSH client certificate.
SSHClientCertTypeThe type of SSHClientCert private key.
SSHServerFingerprintThe SSH server fingerprint.

Firewall


PropertyDescription
FirewallTypeThe protocol used by a proxy-based firewall.
FirewallServerThe name or IP address of a proxy-based firewall.
FirewallPortThe TCP port for a proxy-based firewall.
FirewallUserThe user name to use to authenticate with a proxy-based firewall.
FirewallPasswordA password used to authenticate to a proxy-based firewall.

Logging


PropertyDescription
LogModulesCore modules to be included in the log file.

Schema


PropertyDescription
LocationA path to the directory that contains the schema files defining tables, views, and stored procedures.

Miscellaneous


PropertyDescription
FileRetrievalDepthSpecify the depth level of folders you want to query from the Root table.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
ReadonlyYou can use this property to enforce read-only access to SFTP from the provider.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseMLSDUses listings for machine processing. Used only for FTP servers.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462