Invantive Data Hub
Provider Ftp: FTP. |
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
