BizTalk Adapter for SFTP

Build 21.0.7930

Miscellaneous

This section provides a list of the Miscellaneous properties you can configure in the connection settings 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.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
ReadonlyYou can use this property to enforce read-only access to SFTP from the provider.
RTKThe runtime key used for licensing.
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.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930