invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Autotask Attributes

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

Advanced

swagger-specification-url

The Swagger URL such as https://example.org/rest/swagger.json.

  • Set from: connection string, set statement, provider file, log on

swagger-specification-file

The Swagger file path, such as C:\temp\swagger.json.

  • Set from: connection string, set statement, provider file, log on

ignore-values-unknown-path

Whether to ignore values outside of processed paths. An error will be generated when a value occurs outside a path otherwise.

  • Default: True
  • Set from: connection string, set statement, provider file, log on

ignore-unknown-path-type

Whether to ignore path types not yet supported. An error will be generated when an unsupported type occurs.

  • Default: True
  • Set from: connection string, set statement, provider file, log on

maximum-discovered-column-count

Maximum number of discovered columns. An error will be generated when the column exceeds this value.

  • Default: 250
  • Set from: connection string, set statement, provider file, log on

duplicate-row-mode

Configure behaviour when multiple rows are discovered during a limited search based upon a fingerprint generated from the primary key value, or all column values when no primary key is known..

The following values can be used: "error" to raise error on duplicate fingerprint values in an API-page of rows, "keep" to ignore duplicate fingerprint values silently, "skip" like "keep" but with logging to trace of duplicate values or "null" for default behaviour (typically "error")..

  • Set from: connection string, set statement, provider file, log on

api-client-id

The client ID is a unique identifier of your application. It is generated by registering an application.

  • Set from: connection string, provider file, log on
  • Defined by: OData

api-client-secret

The client secret is to be kept confidential. Such as a password for a logon code, the client secret is the confidential part of an app identified by a client ID. It is needed during the OAuth2 Code Grant Flow together with the refresh token to get access.

  • Set from: connection string, provider file, log on
  • Defined by: OData

api-access-token

Access Token is a security token for multiple OAuth2 Flows. With an Access Token you can access protected resources. An Access Token must be stored securely since once compromised allows access to your protected resources.

  • Set from: connection string, set statement, provider file, log on
  • Defined by: OData

api-refresh-token

Refresh Token is a security token for the OAuth2 Code Grant Flow. With a Refresh Token and client secret you can retrieve a renewed access token to access protected resources. A Refresh Token and client secret must be stored securely since once compromised allows access to your protected resources.

  • Set from: connection string, provider file, log on
  • Defined by: OData

api-redirect-url

The redirect URI is the website a browser session is redirected to after the OAuth2 authentication process has been completed.

  • Set from: connection string, provider file, log on
  • Defined by: OData

Other

api-integration-code

The integration code uniquely identifies the Autotask application and vendor.

  • Set from: connection string, provider file, log on
  • Defined by: Autotask

add-odata-mandatory-filters

Whether to automatically add OData filters deemed necessary by the platform.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: OData

analysis-enforce-row-uniqueness

Enforce rows to be unique for software analysis. A fingerprint is calculated from the whole row of data when the primary key column is unknown.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

api-pre-expiry-refresh-sec

The number of seconds before the token expires to acquire a new token.

  • Set from: connection string, set statement, provider file
  • Defined by: OData

api-scope

The authorization scope(s) to request an OAuth token for.

  • Set from: connection string, provider file
  • Defined by: OData

api-token-url

The token URI is the OAuth2 endpoint to exchange tokens with.

  • Set from: connection string, provider file
  • Defined by: OData

api-url

URL of web service.

  • Set from: connection string, provider file
  • Defined by: OData

bulk-delete-page-size-rows

Number of rows to delete per batch when bulk deleting.

  • Default: 10000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

bulk-insert-page-size-bytes

Approximate maximum size in bytes of batch when bulk inserting.

  • Default: 10000000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

bulk-insert-page-size-rows

Number of rows to insert per batch when bulk inserting.

  • Default: 250
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

download-error-400-bad-request-max-tries

Maximum number of tries when HTTP server reports bad format during retrieval of data.

  • Default: 3
  • Set from: connection string, set statement, provider file

download-error-400-bad-request-sleep-initial-ms

Initial sleep in milliseconds between retries when HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 500
  • Set from: connection string, set statement, provider file

download-error-400-bad-request-sleep-max-ms

Maximum sleep in milliseconds between retries when HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 5000
  • Set from: connection string, set statement, provider file

download-error-400-bad-request-sleep-multiplicator

Multiplication factor for sleep between retries HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-408-request-timeout-max-tries

Maximum number of tries when the website reports a HTTP status 408.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-408-request-timeout-sleep-initial-ms

Initial sleep in milliseconds between retries when the website reports a HTTP status 408.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-408-request-timeout-sleep-max-ms

Maximum sleep in milliseconds between retries when the website reports a HTTP status 408.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-408-request-timeout-sleep-multiplicator

Multiplication factor for sleep between retries when the website reports a HTTP status 408.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-422-bad-request-max-tries

Maximum number of tries when HTTP server reports unprocessable entity during retrieval of data.

  • Default: 30
  • Set from: connection string, set statement, provider file

download-error-422-bad-request-sleep-initial-ms

Initial sleep in milliseconds between retries when HTTP server reports unprocessable entity during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-422-bad-request-sleep-max-ms

Maximum sleep in milliseconds between retries when HTTP server reports unprocessable entity during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-422-bad-request-sleep-multiplicator

Multiplication factor for sleep between retries HTTP server reports unprocessable entity during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-429-too-many-requests-max-tries

Maximum number of tries when the website reports that too many requests have been made during a timeslot of one minute or one day.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-429-too-many-requests-sleep-initial-ms

Initial sleep in milliseconds between retries when the website reports that too many requests have been made during a timeslot of one minute or one day.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-429-too-many-requests-sleep-max-ms

Maximum sleep in milliseconds between retries when the website reports that too many requests have been made during a timeslot of one minute or one day.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-429-too-many-requests-sleep-multiplicator

Multiplication factor for sleep between retries when the website reports that too many requests have been made during a timeslot of one minute or one day.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-500-internal-server-error-max-tries

Download Error 500 Internal Server Error Maximum Tries

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-500-internal-server-error-sleep-initial-ms

Download Error 500 Internal Server Error Sleep Initial ms

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-500-internal-server-error-sleep-max-ms

Download Error 500 Internal Server Error Sleep Maximum ms

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-500-internal-server-error-sleep-multiplicator

Download Error 500 Internal Server Error Sleep Multiplicator

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-502-server-unavailable-max-tries

Maximum number of tries when HTTP server reports a bad gateway during retrieval of data.

  • Default: 30
  • Set from: connection string, set statement, provider file

download-error-502-server-unavailable-sleep-initial-ms

Initial sleep in milliseconds between retries when HTTP server reports a bad gateway during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-502-server-unavailable-sleep-max-ms

Maximum sleep in milliseconds between retries when HTTP server reports that a bad gateway during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-502-server-unavailable-sleep-multiplicator

Multiplication factor for sleep between retries HTTP server reports a bad gateway during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-503-server-unavailable-max-tries

Maximum number of tries when HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 30
  • Set from: connection string, set statement, provider file

download-error-503-server-unavailable-sleep-initial-ms

Initial sleep in milliseconds between retries when HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-503-server-unavailable-sleep-max-ms

Maximum sleep in milliseconds between retries when HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-503-server-unavailable-sleep-multiplicator

Multiplication factor for sleep between retries HTTP server reports that the API server is unavailable during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-504-gateway-timeout-max-tries

Maximum number of tries when the website reports a gateway timeout.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-504-gateway-timeout-sleep-initial-ms

Initial sleep in milliseconds between retries when the website reports a gateway timeout.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-504-gateway-timeout-sleep-max-ms

Maximum sleep in milliseconds between retries when the website reports a gateway timeout.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-504-gateway-timeout-sleep-multiplicator

Multiplication factor for sleep between retries when the website reports a gateway timeout.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-590-network-connect-timeout-max-tries

Maximum number of tries when the website reports a HTTP status 590.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-590-network-connect-timeout-sleep-initial-ms

Initial sleep in milliseconds between retries when the website reports a HTTP status 590.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-590-network-connect-timeout-sleep-max-ms

Maximum sleep in milliseconds between retries when the website reports a HTTP status 590.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-590-network-connect-timeout-sleep-multiplicator

Multiplication factor for sleep between retries when the website reports a HTTP status 590.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-599-network-connect-timeout-max-tries

Maximum number of tries when the website reports a HTTP status 599.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-599-network-connect-timeout-sleep-initial-ms

Initial sleep in milliseconds between retries when the website reports a HTTP status 599.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-599-network-connect-timeout-sleep-max-ms

Maximum sleep in milliseconds between retries when the website reports a HTTP status 599.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-599-network-connect-timeout-sleep-multiplicator

Multiplication factor for sleep between retries when the website reports a HTTP status 599.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-argument-exception-max-tries

Maximum number of tries when an argument exception is returned when downloading a blob.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-argument-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an argument exception is returned when downloading a blob.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-argument-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an argument exception is returned when downloading a blob.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-argument-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an argument exception is returned when downloading a blob.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-internet-down-max-tries

Maximum number of tries when the Internet connection seems down during retrieval of data.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-internet-down-sleep-initial-ms

Initial sleep in milliseconds between retries when the Internet connection seems down during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-internet-down-sleep-max-ms

Maximum sleep in milliseconds between retries when the Internet connection seems down during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-internet-down-sleep-multiplicator

Multiplication factor for sleep between retries when the Internet connection seems down during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-io-exception-max-tries

Maximum number of tries when a network I/O connection failure occurs during retrieval of data.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-io-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when a network I/O connection failure occurs during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-io-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when a network I/O connection failure occurs during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-io-exception-sleep-multiplicator

Multiplication factor for sleep between retries when a network I/O connection failure occurs during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-json-exception-max-tries

Maximum number of tries when an invalid JSON body is returned.

  • Default: 3
  • Set from: connection string, set statement, provider file

download-error-json-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an invalid JSON body is returned.

  • Default: 1000
  • Set from: connection string, set statement, provider file

download-error-json-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an invalid JSON body is returned.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-json-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an invalid JSON body is returned.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-name-resolution-failure-max-tries

Maximum number of tries when the host name could not be resolved during retrieval of data.

  • Default: 5
  • Set from: connection string, set statement, provider file

download-error-name-resolution-failure-sleep-initial-ms

Initial sleep in milliseconds between retries when the host name could not be resolved during retrieval of data.

  • Default: 5000
  • Set from: connection string, set statement, provider file

download-error-name-resolution-failure-sleep-max-ms

Maximum sleep in milliseconds between retries when the host name could not be resolved during retrieval of data.

  • Default: 5000
  • Set from: connection string, set statement, provider file

download-error-name-resolution-failure-sleep-multiplicator

Download Error Name Resolution Failure Sleep Multiplicator

  • Default: 1
  • Set from: connection string, set statement, provider file

download-error-other-exception-max-tries

Maximum number of tries when an unqualified error occurs during retrieval of data.

  • Default: 3
  • Set from: connection string, set statement, provider file

download-error-other-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-other-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-other-exception-sleep-multiplicator

Multiplication factor for sleep between retries when an unqualified error ocurrs during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-socket-exception-max-tries

Maximum number of tries when the network connection is forcible dropped during retrieval of data.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-socket-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-socket-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-socket-exception-sleep-multiplicator

Multiplication factor for sleep between retries when the network connection is forcible dropped during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-web-exception-max-tries

Maximum number of tries when a web connection failure occurs during retrieval of data.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-web-exception-sleep-initial-ms

Initial sleep in milliseconds between retries when a web connection failure occurs during retrieval of data.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-web-exception-sleep-max-ms

Maximum sleep in milliseconds between retries when a web connection failure occurs during retrieval of data.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-web-exception-sleep-multiplicator

Multiplication factor for sleep between retries when a web connection failure occurs during retrieval of data.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-web-not-found-max-tries

Download Error Web Not Found Maximum Tries

  • Default: 1
  • Set from: connection string, set statement, provider file

download-error-web-not-found-sleep-initial-ms

Download Error Web Not Found Sleep Initial ms

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-web-not-found-sleep-max-ms

Download Error Web Not Found Sleep Maximum ms

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-web-not-found-sleep-multiplicator

Download Error Web Not Found Sleep Multiplicator

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-web-not-implemented-max-tries

Maximum number of tries when the connection reports not implemented.

  • Default: 1
  • Set from: connection string, set statement, provider file

download-error-web-not-implemented-sleep-initial-ms

Initial sleep in milliseconds between retries when the connection reports not implemented.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-web-not-implemented-sleep-max-ms

Maximum sleep in milliseconds between retries when the connection reports not implemented.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-web-not-implemented-sleep-multiplicator

Multiplication factor for sleep between retries when the connection reports not implemented.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-web-timeout-max-tries

Maximum number of tries when the connection reports a timeout.

  • Default: 10
  • Set from: connection string, set statement, provider file

download-error-web-timeout-sleep-initial-ms

Initial sleep in milliseconds between retries when the connection reports a timeout.

  • Default: 1000
  • Set from: connection string, set statement, provider file

download-error-web-timeout-sleep-max-ms

Maximum sleep in milliseconds between retries when the connection reports a timeout.

  • Default: 30000
  • Set from: connection string, set statement, provider file

download-error-web-timeout-sleep-multiplicator

Multiplication factor for sleep between retries when the connection reports a timeout.

  • Default: 2
  • Set from: connection string, set statement, provider file

download-error-web-unauthorized-max-tries

Maximum number of tries when the connection reports an unauthorized error.

  • Default: 1
  • Set from: connection string, set statement, provider file

download-error-web-unauthorized-sleep-initial-ms

Initial sleep in milliseconds between retries when the connection reports an unauthorized error.

  • Default: 10000
  • Set from: connection string, set statement, provider file

download-error-web-unauthorized-sleep-max-ms

Maximum sleep in milliseconds between retries when the connection reports an unauthorized error.

  • Default: 300000
  • Set from: connection string, set statement, provider file

download-error-web-unauthorized-sleep-multiplicator

Multiplication factor for sleep between retries when the connection reports an unauthorized error.

  • Default: 2
  • Set from: connection string, set statement, provider file

force-case-sensitive-identifiers

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

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

forced-casing-identifiers

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

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

http-disk-cache-compression-level

Compression level for the HTTP disk cache, ranging from 1 (little) to 9 (intense). Default is 5.

  • Default: 5
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

http-disk-cache-directory

Directory where HTTP cache is stored.

  • Default: C:\Users\guido\Invantive\Cache\http\guido\shared
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

http-disk-cache-ignore-write-errors

Whether to ignore write errors to disk cache.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

http-disk-cache-max-age-sec

Maximum acceptable age in seconds for use of data in the HTTP disk cache.

  • Default: 2592000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

http-get-timeout-max-ms

HTTP GET maximum timeout on retry (ms).

  • Default: 24000
  • Set from: connection string, set statement, provider file

http-get-timeout-ms

HTTP GET timeout (ms).

  • Default: 298000
  • Set from: connection string, set statement, provider file

http-memory-cache-compression-level

Compression level for the HTTP memory cache, ranging from 1 (little) to 9 (intense). Default is 5.

  • Default: 5
  • Set from: connection string, set statement, provider file
  • Defined by: OData

http-memory-cache-max-age-sec

Maximum acceptable age in seconds for use of data in the HTTP memory cache.

  • Default: 14400
  • Set from: connection string, set statement, provider file
  • Defined by: OData

http-post-timeout-max-ms

HTTP POST maximum timeout on retry (ms).

  • Default: 58000
  • Set from: connection string, set statement, provider file

http-post-timeout-ms

HTTP POST timeout (ms).

  • Default: 57000
  • Set from: connection string, set statement, provider file

ignore-http-400-errors

Ignore HTTP 400 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-401-errors

Ignore HTTP 401 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-402-errors

Ignore HTTP 402 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-403-errors

Ignore HTTP 403 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-404-errors

Ignore HTTP 404 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-422-errors

Ignore HTTP 422 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-429-errors

Ignore HTTP 429 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-500-errors

Ignore HTTP 500 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-502-errors

Ignore HTTP 502 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

ignore-http-503-errors

Ignore HTTP 503 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

invalid-json-on-get-max-tries

Maximum number of tries when the JSON received on GET is invalid.

  • Default: 1
  • Set from: connection string, set statement, provider file

invalid-json-on-get-sleep-initial-ms

Initial sleep in milliseconds between retries when the JSON received on GET is invalid.

  • Default: 1000
  • Set from: connection string, set statement, provider file

invalid-json-on-get-sleep-max-ms

Maximum sleep in milliseconds between retries when the JSON received on GET is invalid.

  • Default: 10000
  • Set from: connection string, set statement, provider file

invalid-json-on-get-sleep-multiplicator

Multiplication factor for sleep between retries when the JSON received on GET is invalid.

  • Default: 2
  • Set from: connection string, set statement, provider file

invalid-json-on-post-max-tries

Maximum number of tries when the JSON received on POST is invalid.

  • Default: 1
  • Set from: connection string, set statement, provider file

invalid-json-on-post-sleep-initial-ms

Initial sleep in milliseconds between retries when the JSON received on POST is invalid.

  • Default: 1000
  • Set from: connection string, set statement, provider file

invalid-json-on-post-sleep-max-ms

Maximum sleep in milliseconds between retries when the JSON received on POST is invalid.

  • Default: 10000
  • Set from: connection string, set statement, provider file

invalid-json-on-post-sleep-multiplicator

Multiplication factor for sleep between retries when the JSON received on POST is invalid.

  • Default: 2
  • Set from: connection string, set statement, provider file

invantive-sql-compress-sparse-arrays

Whether to compress sparse arrays in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-correct-invalid-date

Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-execution-profile-disk-path

Folder to write the execution profile of statements to.

  • Default: c:\temp\profiles
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-execution-profile-to-disk

Whether to write the execution profile of statements to disk.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

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

Whether to forward filters to data containers.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-share-byte-arrays

Whether to share the memory used by identical byte arrays in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-share-strings

Whether to share the memory used by identical strings in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

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

Whether to shuffle results fetched from data containers.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-use-cache

Whether to cache the results of a query.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

join-set-points-per-request

Maximum number of values in a request when executing a join set.

  • Default: 60
  • Set from: connection string, set statement, provider file
  • Defined by: OData

limit-partition-calls-left

Minimum number of remaining API calls on a partition towards a hard limit. When below, an error is raised.

  • Default: 500
  • Set from: connection string, set statement, provider file
  • Defined by: OData

log-native-calls-to-disk-max-events

Maximum number of call events to register from last activation.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-max-seconds

Maximum number of seconds to register calls from last activation.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-on-error

Registers native calls to data container backend as disk files when the call raised an error.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-on-success

Registers native calls to data container backend as disk files when the call raised no error.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-trace

Log native calls to data container backend on the trace.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

max-odata-filters

Maximum number of OData filter elements.

  • Default: 100
  • Set from: connection string, set statement, provider file
  • Defined by: OData

max-url-length-accepted

The maximum accepted URL length before raising an error.

  • Default: 8000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

max-url-length-desired

The maximum desired URL length.

  • Default: 8000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

maximum-url-length

Maximum URL Length

  • Set from: connection string, set statement, provider file

metadata-cache-max-age-sec

Maximum acceptable age in seconds for re-use of metadata.

  • Set from: connection string, set statement, provider file
  • Defined by: OData

oauth-unauthorized-max-tries

Maximum number of tries when an OAuth exception occurs.

  • Default: 2
  • Set from: connection string, set statement, provider file
  • Defined by: OData

oauth-unauthorized-sleep-initial-ms

Initial sleep in milliseconds between OAuth reauthentication tries when the OAuth authentication fails.

  • Default: 10000
  • Set from: connection string, set statement, provider file
  • Defined by: OData

oauth-unauthorized-sleep-max-ms

Maximum sleep in milliseconds between OAuth reauthentication tries when the OAuth authentication fails.

  • Default: 1000
  • Set from: connection string, set statement, provider file
  • Defined by: OData

oauth-unauthorized-sleep-multiplicator

Multiplication factor for sleep between OAuth reauthentication tries when the OAuth authentication fails.

  • Default: 2
  • Set from: connection string, set statement, provider file
  • Defined by: OData

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

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

  • Default: 60000
  • Set from: connection string, provider file
  • Defined by: Shared

partition-slot-based-rate-limit-slots

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

  • Set from: connection string, provider file
  • Defined by: Shared

pre-request-delay-ms

Pre-request delay in milliseconds per request.

  • Default: 0
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

requested-page-size

Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

requests-parallel-max

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

  • Default: 32
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

simulate-http-400-errors

Simulate HTTP 400 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-400-errors-percentage

Percentage of simulated HTTP 400 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-401-errors

Simulate HTTP 401 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-401-errors-percentage

Percentage of simulated HTTP 401 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-403-errors

Simulate HTTP 403 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-403-errors-percentage

Percentage of simulated HTTP 403 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-408-errors

Simulate HTTP 408 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-408-errors-percentage

Percentage of simulated HTTP 408 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-429-errors

Simulate HTTP 429 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-429-errors-percentage

Percentage of simulated HTTP 429 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-500-errors

Simulate HTTP 500 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-500-errors-percentage

Percentage of simulated HTTP 500 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-502-errors

Simulate HTTP 502 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-502-errors-percentage

Percentage of simulated HTTP 502 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-503-errors

Simulate HTTP 503 errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-503-errors-percentage

Percentage of simulated HTTP 503 errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-504-errors

Simulate HTTP 504 Errors

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-504-errors-percentage

Simulate HTTP 504 Errors Percentage

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-522-errors

Simulate HTTP 522 Errors

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-522-errors-percentage

Simulate HTTP 522 Errors Percentage

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-524-errors

Simulate HTTP 524 Errors

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-524-errors-percentage

Simulate HTTP 524 Errors Percentage

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-protocol-errors

Simulate HTTP protocol errors when exchanging results with the HTTP endpoint.

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-protocol-errors-percentage

Percentage of simulated HTTP protocol errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

simulate-http-timeout-errors

Simulate HTTP timeout errors when exchanging results with the HTTP endpoint..

  • Default: False
  • Set from: connection string, set statement, provider file

simulate-http-timeout-errors-percentage

Percentage of simulated HTTP timeout errors when exchanging results with the HTTP endpoint.

  • Default: 0
  • Set from: connection string, set statement, provider file

slot-based-rate-limit-length-ms

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

  • Default: 3600000
  • Set from: connection string, provider file
  • Defined by: Shared

slot-based-rate-limit-slots

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

  • Default: 10000
  • Set from: connection string, provider file
  • Defined by: Shared

standardize-identifiers

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

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

standardize-identifiers-casing

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

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

swagger-specification-download-tries

Specification Download Tries

  • Default: 5
  • Set from: connection string, set statement, provider file

swagger-specification-http-disk-cache-max-age-sec

Maximum acceptable age in seconds for use of Swagger specification data in the HTTP disk cache.

  • Default: 86400
  • Set from: connection string, set statement, provider file

use-batch-insert

Whether to use batch insert.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: OData

use-http-disk-cache-read

Whether to use HTTP responses from previous queries stored on disk to answer the current query.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

use-http-disk-cache-write

Whether to memorize HTTP responses on disk.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

use-http-memory-cache-read

Whether to use HTTP responses from previous queries stored in memory that can answer the current query.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: OData

use-http-memory-cache-write

Whether to memorize HTTP responses from previous queries for use by future queries.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: OData

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: