TDV Adapter for SFTP

Build 21.0.8137

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


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.
SSHAuthModeThe authentication method to be used to log on to an SFTP server.
SSHClientCertA certificate to be used for authenticating the user.
SSHClientCertPasswordThe password of the SSHClientCert certificate if it has one.
SSHClientCertTypeThe type of SSHClientCert certificate.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseMLSDUses listings for machine processing. Used only for FTP servers.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137