Please enable JavaScript to view this site.

Manual Invantive Data Cache

Navigation: » No topics above this level «

Provider DataCache: Persistent data cache, data replication or data vault.

Scroll Comments Prev Top Next More

Persistent data cache, data replication or data vault.

Code for use in settings.xml: DataCache

Alias: cache

Status: Production

Available in Editions: Paid

Technical Documentation: https://documentation.invantive.com/2017R2/data-cache-data-model/webhelp/index.html

Provider Attributes

The following provider attributes are available for DataCache:

Code

Description

Default Value

Set from Connection String

Set from Set SQL-Statement

Set from Providers File

backing-command-timeout-sec

Number of seconds after which a command on backing database times out.

3600

backing-connection-string

The connection string for the backing database

 

 

backing-force-case-sensitive-identifiers

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

False

backing-forced-casing-identifiers

Forced casing of identifiers on the backing database. Choose from Unset, Lower, Upper and Mixed.

Unset

backing-maximum-length-identifiers

Non-default maximum length on the backing database in characters of identifier names.

 

backing-maximum-number-of-pooled-connections

Maximum number of concurrent pooled connections on backing database.

 

backing-maximum-sleep-acquire-pooled-connection-ms

Maximum time in ms to wait for acquiring a free connection from a pool of connections on backing database.

300000

backing-maximum-sleep-acquire-unpooled-connection-ms

Maximum time in ms to wait for acquire a free connection when there is no connection pooling on backing database.

600000

backing-preferred-number-of-pooled-connections

Preferred number of concurrent pooled connections on backing database.

 

backing-provider

The data provider for the backing database

 

 

backing-standardize-identifiers

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

True

backing-standardize-identifiers-casing

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

True

delete-number-table-partition-versions-per-group

Maximum number of table partition versions selected in the IN-clause for a delete of facts.

50

event-log-entries-delete-page-size-rows

Number of rows to delete per batch on maintaining facts.

1000

facts-delete-page-size-rows

Number of rows to delete per batch on maintaining facts.

10000

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.

 

forced-casing-logical-view-column-name

Forced casing of logical view column names. Choose from Unset, Lower, Upper and Mixed.

Unset

forced-casing-logical-view-name

Forced casing of logical view names. Choose from Unset, Lower, Upper and Mixed.

Unset

forwarded-incoming-messages-delete-page-size-rows

Number of rows to delete per batch on maintaining forwarded incoming messages.

10000

garbage-collection-physical-memory-load-threshold

Percentage of physical memory load above which a full garbage collection is run after replication.

80

garbage-collection-replication-interval-count

Number of replications after last garbage collection after which a full garbage collection is run.

100

garbage-collection-replication-minimum-interval-sec

Minimum interval in seconds between two full garbage collections..

30

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

max-delete-facts-parallel

Maximum number of parallel deletes on facts tables.

8

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

 

maximum-length-logical-view-column-name

Maximum length of logical view column names.

 

maximum-length-logical-view-name

Maximum length of logical view names.

 

max-messages-per-customer-service-request

Maximum number of messages to download from Customer Service per request.

10000

max-refreshes-parallel

Maximum number of parallel refreshes.

32

pre-request-delay-ms

Pre-request delay in milliseconds per request.

0

purge-interval-event-log-entries-minutes

Interval in minutes between completed purges of ancient event log entries.

60

requests-parallel-max

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

32

retention-event-log-entries-days

Retention of event log entries in days.

95

slot-based-rate-limit-length-ms

Length in ms 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-number-table-partition-versions-per-group

Maximum number of table partition versions selected in the IN-clause for an update of metadata.

1000