Please enable JavaScript to view this site.

FTP.

Code for use in settings.xml: Ftp

Alias: ftp

Abbreviation: ftp

Status: Production

Available in Editions: Paid

String-comparison is Case-sensitive: true

Use Catalog in Full Name: true

Use Schema in Full Name: true

Provider Attributes

The following provider attributes are available for Ftp:

Code

Description

Default Value

Set from Connection String

Set from Set SQL-Statement

Set from Providers File

Set from Log On

site

{res:itgen_ftp_site_description}

 

 

port

{res:itgen_ftp_port_description}

21

 

use-ssl

Use SSL for the connection (FTPS).

False

 

use-passive

Use passive FTP(S) instead of active.

True

 

use-binary

Use binary mode (true) or ASCII mode (false) transfers by default.

True

 

timeout-connection-sec

Seconds to wait for a connection attempt to succeed before giving up.

30

 

timeout-data-connection-sec

Seconds for a data connection to be established before giving up.

30

 

timeout-data-read-sec

Seconds the data channel should wait for the server to send data.

30

 

timeout-read-sec

Seconds for data to be read from the underlying stream.

30

 

socket-poll-interval-sec

Seconds between two poll intervals when enabled.

15

 

socket-keep-alive

Whether to keep the connection alive by polling.

False

 

special-connection-type

Special connection types for specialized use.

 

 

ssl-protocols

Comma-separated list of SSL protocols, defaults to TLS 1.1 and TLS 1.2.

 

 

force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

False

 

forced-casing-identifiers

Forced casing of identifiers. Choose from Unset, Lower, Upper and Mixed.

 

 

invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

True

 

invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

False

 

invantive-use-cache

Whether to cache the results of a query.

True

 

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

 

 

max-url-length-accepted

The maximum accepted URL length before raising an error.

8000

 

max-url-length-desired

The maximum desired URL length.

8000

 

partition-slot-based-rate-limit-length-ms

Total length in ms across all slots of a partition-based rate limit.

60000

 

 

partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit

 

 

 

pre-request-delay-ms

Pre-request delay in milliseconds per request.

0

 

requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

32

 

slot-based-rate-limit-length-ms

Total length in ms across all slots of a slot-based rate limit.

60000

 

 

slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit

 

 

 

standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

True

 

standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

True

 

trace-native-calls

Trace native calls to data container backend.

False

 

 

23-06-2019 19:4017.33.48-BETA+2173