Invantive Data Hub
Provider ExactOnlineAll: Exact Online (XML, REST and undocumented). |
Exact Online (XML, REST and undocumented).
Code for use in settings.xml: ExactOnlineAll
Alias: eol
Abbreviation: eol
Status: Production
Available in Editions: Paid
String-comparison is Case-sensitive: true
Use Catalog in Full Name: true
Use Schema in Full Name: true
Partition Column: division
Technical Documentation: https://support.exactonline.com/community/s/knowledge-base#All-All-HNO-Content-resources-eol-files-homeexactonlinehelpcentre
Provider Attributes
The following provider attributes are available for ExactOnlineAll:
Code |
Description |
Default Value |
Set from Connection String |
Set from Set SQL-Statement |
Set from Providers File |
Set from Log On |
|---|---|---|---|---|---|---|
api-client-id |
The client ID is a unique identifier of your application. It is generated by registering an application. |
|
✓ |
|
✓ |
✓ |
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. |
*** |
✓ |
|
✓ |
✓ |
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. |
*** |
✓ |
|
✓ |
✓ |
api-redirect-url |
The redirect URI is the website a browser session is redirected to after the OAuth2 authentication process has been completed. |
|
✓ |
|
✓ |
✓ |
totp-secret |
Shared secret key to generate one-time password using TOTP RFC 6238. For improved security, manually enter the one-time password asked during login. |
*** |
✓ |
|
✓ |
✓ |
api-token-url |
The token URI is the OAuth2 endpoint to exchange tokens. |
|
✓ |
|
✓ |
|
api-url |
URL to access the API. |
|
✓ |
|
✓ |
|
bulk-delete-page-size-rows |
Number of rows to delete per batch when bulk deleting |
10000 |
✓ |
✓ |
✓ |
|
bulk-insert-page-size-bytes |
Approximate maximum size in bytes of batch when bulk inserting |
10000000 |
✓ |
✓ |
✓ |
|
bulk-insert-page-size-rows |
Number of rows to insert per batch when bulk inserting |
250 |
✓ |
✓ |
✓ |
|
download-error-400-bad-request-max-tries |
Maximum number of tries when Akamai reports that the API server is unavailable during retrieval of data. |
30 |
✓ |
✓ |
✓ |
|
download-error-400-bad-request-sleep-initial-ms |
Initial sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data. |
5000 |
✓ |
✓ |
✓ |
|
download-error-400-bad-request-sleep-max-ms |
Maximum sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data. |
60000 |
✓ |
✓ |
✓ |
|
download-error-400-bad-request-sleep-multiplicator |
Multiplication factor for sleep between retries Akamai reports that the API server is unavailable during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
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. |
10 |
✓ |
✓ |
✓ |
|
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. |
5000 |
✓ |
✓ |
✓ |
|
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. |
60000 |
✓ |
✓ |
✓ |
|
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. |
2 |
✓ |
✓ |
✓ |
|
download-error-503-server-unavailable-max-tries |
Maximum number of tries when Akamai reports that the API server is unavailable during retrieval of data. |
30 |
✓ |
✓ |
✓ |
|
download-error-503-server-unavailable-sleep-initial-ms |
Initial sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data. |
5000 |
✓ |
✓ |
✓ |
|
download-error-503-server-unavailable-sleep-max-ms |
Maximum sleep in milliseconds between retries when Akamai reports that the API server is unavailable during retrieval of data. |
60000 |
✓ |
✓ |
✓ |
|
download-error-503-server-unavailable-sleep-multiplicator |
Multiplication factor for sleep between retries Akamai reports that the API server is unavailable during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-504-gateway-timeout-max-tries |
Maximum number of tries when the website reports a gateway timeout. |
10 |
✓ |
✓ |
✓ |
|
download-error-504-gateway-timeout-sleep-initial-ms |
Initial sleep in milliseconds between retries when the website reports a gateway timeout. |
5000 |
✓ |
✓ |
✓ |
|
download-error-504-gateway-timeout-sleep-max-ms |
Maximum sleep in milliseconds between retries when the website reports a gateway timeout. |
60000 |
✓ |
✓ |
✓ |
|
download-error-504-gateway-timeout-sleep-multiplicator |
Multiplication factor for sleep between retries when the website reports a gateway timeout. |
2 |
✓ |
✓ |
✓ |
|
download-error-argument-exception-max-tries |
Maximum number of tries when an argument exception is returned when downloading a blob. |
10 |
✓ |
✓ |
✓ |
|
download-error-argument-exception-sleep-initial-ms |
Initial sleep in milliseconds between retries when an argument exception is returned when downloading a blob. |
1000 |
✓ |
✓ |
✓ |
|
download-error-argument-exception-sleep-max-ms |
Maximum sleep in milliseconds between retries when an argument exception is returned when downloading a blob. |
60000 |
✓ |
✓ |
✓ |
|
download-error-argument-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when an argument exception is returned when downloading a blob. |
2 |
✓ |
✓ |
✓ |
|
download-error-internet-down-max-tries |
Maximum number of tries when the Internet connection seems down during retrieval of data. |
10 |
✓ |
✓ |
✓ |
|
download-error-internet-down-sleep-initial-ms |
Initial sleep in milliseconds between retries when the Internet connection seems down during retrieval of data. |
10000 |
✓ |
✓ |
✓ |
|
download-error-internet-down-sleep-max-ms |
Maximum sleep in milliseconds between retries when the Internet connection seems down during retrieval of data. |
60000 |
✓ |
✓ |
✓ |
|
download-error-internet-down-sleep-multiplicator |
Multiplication factor for sleep between retries when the Internet connection seems down during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-io-exception-max-tries |
Maximum number of tries when a network I/O connection failure occurs during retrieval of data. |
10 |
✓ |
✓ |
✓ |
|
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. |
10000 |
✓ |
✓ |
✓ |
|
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. |
60000 |
✓ |
✓ |
✓ |
|
download-error-io-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when a network I/O connection failure occurs during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-json-exception-max-tries |
Maximum number of tries when an invalid JSON body is returned. |
3 |
✓ |
✓ |
✓ |
|
download-error-json-exception-sleep-initial-ms |
Initial sleep in milliseconds between retries when an invalid JSON body is returned. |
1000 |
✓ |
✓ |
✓ |
|
download-error-json-exception-sleep-max-ms |
Maximum sleep in milliseconds between retries when an invalid JSON body is returned. |
10000 |
✓ |
✓ |
✓ |
|
download-error-json-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when an invalid JSON body is returned. |
2 |
✓ |
✓ |
✓ |
|
download-error-other-exception-max-tries |
Maximum number of tries when an unqualified error occurs during retrieval of data. |
3 |
✓ |
✓ |
✓ |
|
download-error-other-exception-sleep-initial-ms |
Initial sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data. |
5000 |
✓ |
✓ |
✓ |
|
download-error-other-exception-sleep-max-ms |
Maximum sleep in milliseconds between retries when an unqualified error ocurrs during retrieval of data. |
30000 |
✓ |
✓ |
✓ |
|
download-error-other-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when an unqualified error ocurrs during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-socket-exception-max-tries |
Maximum number of tries when the network connection is forcible dropped during retrieval of data. |
10 |
✓ |
✓ |
✓ |
|
download-error-socket-exception-sleep-initial-ms |
Initial sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data. |
10000 |
✓ |
✓ |
✓ |
|
download-error-socket-exception-sleep-max-ms |
Maximum sleep in milliseconds between retries when the network connection is forcible dropped during retrieval of data. |
60000 |
✓ |
✓ |
✓ |
|
download-error-socket-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when the network connection is forcible dropped during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-web-exception-max-tries |
Maximum number of tries when a web connection failure occurs during retrieval of data. |
10 |
✓ |
✓ |
✓ |
|
download-error-web-exception-sleep-initial-ms |
Initial sleep in milliseconds between retries when a web connection failure occurs during retrieval of data. |
10000 |
✓ |
✓ |
✓ |
|
download-error-web-exception-sleep-max-ms |
Maximum sleep in milliseconds between retries when a web connection failure occurs during retrieval of data. |
60000 |
✓ |
✓ |
✓ |
|
download-error-web-exception-sleep-multiplicator |
Multiplication factor for sleep between retries when a web connection failure occurs during retrieval of data. |
2 |
✓ |
✓ |
✓ |
|
download-error-web-not-implemented-max-tries |
Maximum number of tries when the connection reports not implemented. |
1 |
✓ |
✓ |
✓ |
|
download-error-web-not-implemented-sleep-initial-ms |
Initial sleep in milliseconds between retries when the connection reports not implemented. |
5000 |
✓ |
✓ |
✓ |
|
download-error-web-not-implemented-sleep-max-ms |
Maximum sleep in milliseconds between retries when the connection reports not implemented. |
60000 |
✓ |
✓ |
✓ |
|
download-error-web-not-implemented-sleep-multiplicator |
Multiplication factor for sleep between retries when the connection reports not implemented. |
2 |
✓ |
✓ |
✓ |
|
download-error-web-timeout-max-tries |
Maximum number of tries when the connection reports a timeout. |
10 |
✓ |
✓ |
✓ |
|
download-error-web-timeout-sleep-initial-ms |
Initial sleep in milliseconds between retries when the connection reports a timeout. |
5000 |
✓ |
✓ |
✓ |
|
download-error-web-timeout-sleep-max-ms |
Maximum sleep in milliseconds between retries when the connection reports a timeout. |
60000 |
✓ |
✓ |
✓ |
|
download-error-web-timeout-sleep-multiplicator |
Multiplication factor for sleep between retries when the connection reports a timeout. |
2 |
✓ |
✓ |
✓ |
|
download-error-web-unauthorized-max-tries |
Maximum number of tries when the connection reports an unauthorized error. |
1 |
✓ |
✓ |
✓ |
|
download-error-web-unauthorized-sleep-initial-ms |
Initial sleep in milliseconds between retries when the connection reports an unauthorized error. |
5000 |
✓ |
✓ |
✓ |
|
download-error-web-unauthorized-sleep-max-ms |
Maximum sleep in milliseconds between retries when the connection reports an unauthorized error. |
60000 |
✓ |
✓ |
✓ |
|
download-error-web-unauthorized-sleep-multiplicator |
Multiplication factor for sleep between retries when the connection reports an unauthorized error. |
2 |
✓ |
✓ |
✓ |
|
encrypt-http-disk-cache |
Whether to encrypt the contents of the disk cache when used. Disable only when performance is a premium above data security. |
True |
✓ |
✓ |
✓ |
|
exact-development-mode |
True if we have to connect to the Exact development instance |
|
✓ |
✓ |
✓ |
|
exact-online-url |
URL of Exact Online web service |
|
✓ |
|
✓ |
|
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. |
|
✓ |
✓ |
✓ |
|
hide-empty-columns |
Whether to exclude columns without a value from a result set when using 'select *' With this XML provider, often more than 95% of the columns are empty due to limitations of the XSD specification. Should be enabled in general. |
True |
✓ |
✓ |
✓ |
|
http-disk-cache |
Action: provide 'empty' to empty HTTP disk cache. |
|
|
✓ |
|
|
http-disk-cache-compression-level |
Compression level for the HTTP disk cache, ranging from 1 (little) to 9 (intense). Default is 5. |
5 |
✓ |
✓ |
✓ |
|
http-disk-cache-directory |
Directory where HTTP cache is stored. |
C:\Users\gle3\Invantive\Cache\http\gle3\shared |
✓ |
✓ |
✓ |
|
http-disk-cache-max-age-sec |
Maximum acceptable age in seconds for use of data in the HTTP disk cache. |
2592000 |
✓ |
✓ |
✓ |
|
http-get-timeout-ms |
HTTP GET timeout (ms). |
300000 |
✓ |
✓ |
✓ |
|
http-memory-cache |
Action: provide 'empty' to empty HTTP memory cache. |
|
|
✓ |
|
|
http-memory-cache-compression-level |
Compression level for the HTTP memory cache, ranging from 1 (little) to 9 (intense). Default is 5. |
5 |
✓ |
✓ |
✓ |
|
http-memory-cache-max-age-sec |
Maximum acceptable age in seconds for use of data in the HTTP memory cache. |
14400 |
✓ |
✓ |
✓ |
|
http-post-timeout-ms |
HTTP POST timeout (ms). |
300000 |
✓ |
✓ |
✓ |
|
ignore-document-download-errors |
Ignore all errors when fetching the document contents from Exact Online. |
False |
✓ |
✓ |
✓ |
|
ignore-http-400-errors |
Ignore HTTP 400 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
ignore-http-403-errors |
Ignore HTTP 403 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
ignore-http-429-errors |
Ignore HTTP 429 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
ignore-http-500-errors |
Ignore HTTP 500 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
ignore-xml-errors |
Ignore normal errors within the XML returned by the API. |
False |
✓ |
✓ |
✓ |
|
ignore-xml-fatal-errors |
Ignore fatal errors within the XML returned by the API. |
False |
✓ |
✓ |
✓ |
|
ignore-xml-no-access-errors |
Ignore no access errors within the XML returned by the API. |
False |
✓ |
✓ |
✓ |
|
ignore-xml-warnings |
Ignore warnings within the XML returned by the API. |
False |
✓ |
✓ |
✓ |
|
insert-allowed |
Allow use of the BETA functionality for inserts |
False |
✓ |
✓ |
✓ |
|
invalid-json-on-get-max-tries |
Maximum number of tries when the JSON received on GET is invalid. |
10 |
✓ |
✓ |
✓ |
|
invalid-json-on-get-sleep-initial-ms |
Initial sleep in milliseconds between retries when the JSON received on GET is invalid. |
10000 |
✓ |
✓ |
✓ |
|
invalid-json-on-get-sleep-max-ms |
Maximum sleep in milliseconds between retries when the JSON received on GET is invalid. |
60000 |
✓ |
✓ |
✓ |
|
invalid-json-on-get-sleep-multiplicator |
Multiplication factor for sleep between retries when the JSON received on GET is invalid. |
2 |
✓ |
✓ |
✓ |
|
invalid-json-on-post-max-tries |
Maximum number of tries when the JSON received on POST is invalid. |
1 |
✓ |
✓ |
✓ |
|
invalid-json-on-post-sleep-initial-ms |
Initial sleep in milliseconds between retries when the JSON received on POST is invalid. |
10000 |
✓ |
✓ |
✓ |
|
invalid-json-on-post-sleep-max-ms |
Maximum sleep in milliseconds between retries when the JSON received on POST is invalid. |
60000 |
✓ |
✓ |
✓ |
|
invalid-json-on-post-sleep-multiplicator |
Multiplication factor for sleep between retries when the JSON received on POST is invalid. |
2 |
✓ |
✓ |
✓ |
|
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 |
✓ |
✓ |
✓ |
|
join-set-points-per-request |
Maximum number of values in a request when executing a join set. |
60 |
✓ |
✓ |
✓ |
|
limit-partition-calls-left |
Minimum number of remaining API calls on a partition towards a hard limit. When below, an error is raised. |
500 |
✓ |
✓ |
✓ |
|
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. |
2800 |
✓ |
✓ |
✓ |
|
max-url-length-desired |
The maximum desired URL length. |
2500 |
✓ |
✓ |
✓ |
|
metadata-cache-max-age-sec |
Maximum acceptable age in seconds for re-use of metadata. |
|
✓ |
✓ |
✓ |
|
partition-slot-based-rate-limit-length-ms |
Total length in ms across all slots of a partition-based rate limit. |
66000 |
✓ |
|
✓ |
|
partition-slot-based-rate-limit-slots |
Number of slots per partition-based rate limit. Null means no slot-based rate limit |
272 |
✓ |
|
✓ |
|
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. |
16 |
✓ |
✓ |
✓ |
|
result-set-cache |
Action: provide 'empty' to empty. |
|
|
✓ |
|
|
simulate-http-400-errors |
Simulate HTTP 400 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-400-errors-percentage |
Percentage of simulated HTTP 400 errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
simulate-http-403-errors |
Simulate HTTP 403 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-403-errors-percentage |
Percentage of simulated HTTP 403 errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
simulate-http-429-errors |
Simulate HTTP 429 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-429-errors-percentage |
Percentage of simulated HTTP 429 errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
simulate-http-500-errors |
Simulate HTTP 500 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-500-errors-percentage |
Percentage of simulated HTTP 500 errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
simulate-http-protocol-errors |
Simulate HTTP protocol errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-protocol-errors-percentage |
Percentage of simulated HTTP protocol errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
simulate-http-timeout-errors |
Simulate HTTP timeout errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
|
simulate-http-timeout-errors-percentage |
Percentage of simulated HTTP timeout errors when exchanging results with the OData endpoint. |
0 |
✓ |
✓ |
✓ |
|
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 |
✓ |
✓ |
✓ |
|
update-allowed |
Allow use of the BETA functionality for updates |
False |
✓ |
✓ |
✓ |
|
use-batch-insert |
Whether to use batch insert. |
False |
✓ |
✓ |
✓ |
|
use-http-disk-cache |
Combination of use-http-disk-cache-read and use-http-disk-cache-write. |
|
✓ |
✓ |
✓ |
|
use-http-disk-cache-read |
Whether to use HTTP responses from previous queries stored on disk to answer the current query. |
True |
✓ |
✓ |
✓ |
|
use-http-disk-cache-write |
Whether to memorize HTTP responses on disk. |
True |
✓ |
✓ |
✓ |
|
use-http-memory-cache |
Combination of use-http-memory-cache-read and use-http-memory-cache-write. |
|
✓ |
✓ |
✓ |
|
use-http-memory-cache-read |
Whether to use HTTP responses from previous queries stored in memory that can answer the current query. |
True |
✓ |
✓ |
✓ |
|
use-http-memory-cache-write |
Whether to memorize HTTP responses from previous queries for use by future queries. |
True |
✓ |
✓ |
✓ |
|
use-metadata-cache |
Whether to use the metadata calculated previously Has only practical use during development on a XML provider. |
True |
✓ |
✓ |
✓ |
|
use-result-cache |
Whether to use result sets from previous queries that can answer the current query |
True |
✓ |
✓ |
✓ |
|
02-12-2019 15:4717.33.216-BETA+2512
