invantive documentation
Invantive Support ForumsLog In / Sign Up

Chargebee Attributes

Advanced

page-size-rows

Number of rows to retrieve per page.

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

Other

server

Name of the Chargebee site.

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

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-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: 56000
  • 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: 60000
  • 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.

  • 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

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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: