---
title: "Data Cache Attributes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/invantivedatareplicator/attributes
original: https://documentation.invantive.eu/en/datamodels/invantivedatareplicator/attributes
updated: 2023-08-17T08:37:05Z
license: https://documentation.invantive.eu/en/
---

# Data Cache Attributes

## Other

### 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

### application-prefix-facts

A prefix applied after the environment prefix to every facts table, index and view.

- Default: `dcd_`
- Set from: connection string
- Defined by: Data Cache

### application-prefix-history

A prefix applied after the environment prefix to every history table, index and view.

- Default: `dcs_`
- Set from: connection string
- Defined by: Data Cache

### application-prefix-repository

A prefix applied after the environment prefix to every repository table, index and view.

- Default: `dc_`
- Set from: connection string
- Defined by: Data Cache

### backing-bulk-insert-page-size-bytes

Approximate maximum size in bytes of page when bulk inserting on backing database.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-bulk-insert-page-size-rows

Number of rows to insert per page when bulk inserting on backing database.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-bulk-insert-timeout-sec

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

- Default: `3600`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-command-timeout-sec

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

- Default: `3600`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-connection-string

The connection string for the backing database.

- Set from: connection string, provider file
- Defined by: Data Cache

### backing-force-case-sensitive-identifiers

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

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-forced-casing-identifiers

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

- Default: `Unset`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-maximum-length-identifiers

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

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-maximum-number-of-pooled-connections

Maximum number of concurrent pooled connections on backing database.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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.

- Default: `300000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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.

- Default: `600000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-minimum-connection-timeout-sec

Minimum number of seconds after which a newly requested connection on backing database times out.

- Default: `300`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-preferred-number-of-pooled-connections

Preferred number of concurrent pooled connections on backing database.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-provider

Name of the Invantive connector for the backing database.

- Set from: connection string, provider file
- Defined by: Data Cache

### backing-sql-server-connect-retry-count

Number of connect retries on connection failed on the backing SQL Server database (SQL Server only).

- Default: `60`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-sql-server-connect-retry-interval-sec

Interval between connect retries on connection failed on the backing SQL Server database (SQL Server only).

- Default: `15`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### backing-standardize-identifiers

Rewrite all identifiers on the backing database 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: Data Cache

### 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.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-compress-facts-on-disk

Whether to compress facts in the disk cache.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-encrypt-facts-on-disk

Whether to encrypt facts in the disk cache.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-store-facts-in-database

Whether to store facts in the database containing the repository.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-store-facts-on-disk

Whether to store facts on the disk cache.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-use-facts-in-database

Whether to use facts in the database cache.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### beta-use-facts-on-disk

Whether to use facts in the disk cache.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### cache-folder

Folder to store Data Cache cache files in.

- Default: `C:\Users\gle3.WS212\Invantive\Cache\datacache`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### default-skip-client-side-cacheable

Whether to skip client-side cacheable tables by default.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### default-use-ods

Whether to use the Operational Data Store when no hint is specified.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

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

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

- Default: `50`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### development-use-http-disk-cache

Whether to allow use of the disk cache for platform HTTP requests.

- Default: `False`
- Set from: connection string, set statement
- Defined by: Data Cache

### drop-backlog-factor

Maximum ratio between number of versions dropped and new versions loaded on refresh.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### environment-prefix-all

A prefix applied to repository, facts and history database tables, indexes and views.

- Set from: connection string
- Defined by: Data Cache

### environment-prefix-facts

A prefix applied to every facts table, index and view.

- Set from: connection string
- Defined by: Data Cache

### environment-prefix-history

A prefix applied to every history table, index and view.

- Set from: connection string
- Defined by: Data Cache

### environment-prefix-logical-view

A prefix applied to every logical view.

- Set from: connection string
- Defined by: Data Cache

### environment-prefix-repository

A prefix applied to every repository table, index and view.

- Set from: connection string
- Defined by: Data Cache

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

Number of rows to delete per batch on maintaining event log entries.

- Default: `1000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### event-log-memory-cache-flush-interval-sec

Maximum interval in seconds between flushes of in-memory cache of event log entries to database.

- Default: `15`
- Set from: connection string
- Defined by: Data Cache

### event-log-memory-cache-size

Size of in-memory cache of event log entries before they are written to the database.

- Default: `100`
- Set from: connection string
- Defined by: Data Cache

### facts-delete-page-size-characters

Number of characters to delete per batch on maintaining orphaned facts.

- Default: `10000000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### facts-delete-page-size-rows

Number of rows to delete per batch on purging orphaned facts during repository upgrade or maintenance.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### facts-insert-page-size-rows

Number of rows to insert per batch on maintaining facts.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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

### forced-casing-logical-view-column-name

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

- Default: `Unset`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### forced-casing-logical-view-name

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

- Default: `Unset`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### forwarded-incoming-messages-delete-max-runtime-sec

Maximum runtime of purge forwarded incoming messages in seconds.

- Default: `3600`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

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

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

- Default: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### garbage-collection-physical-memory-load-threshold

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

- Default: `80`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### garbage-collection-replication-interval-count

itgen_pae_garbage_collection_replication_minimum_interval_count_desc

- Default: `100`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### garbage-collection-replication-minimum-interval-sec

{res:itgen_pae_garbage_collection_replication_minimum_interval_sec_desc
}

- Default: `30`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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-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

### 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-delete-facts-parallel

Maximum number of parallel deletes on facts tables.

- Default: `8`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### max-messages-per-customer-service-request

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

- Default: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### max-percentage-trickle-loading

Maximum percentage of incoming messages versus known rows to use trickle loading with. When exceeded, reverts to copy approach.

- Default: `2,5`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### max-refreshes-parallel

Maximum number of parallel refreshes.

- Default: `32`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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-length-logical-view-column-name

Maximum length of logical view column names.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### maximum-length-logical-view-name

Maximum length of logical view names.

- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### orphaned-facts-delete-page-size-rows

Number of rows to delete per batch on maintaining orphaned facts.

- Default: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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

### purge-interval-event-log-entries-minutes

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

- Default: `60`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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

### retention-event-log-entries-days

Retention of event log entries in days.

- Default: `35`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### session-terminated-threshold-hours

Number of hours after start a session is considered terminated.

- Default: `168`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### 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

### update-number-table-partition-versions-per-group

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

- Default: `1000`
- Set from: connection string, set statement, provider file
- Defined by: Data Cache

### upgrade-force-execute

Whether to force execution of possible upgrade steps, even when there are no reasons to perform an upgrade.

- Default: `False`
- Set from: connection string
- Defined by: Data Cache

### upgrade-force-repository-version-start

Specifies the repository version to start upgrade from when specified.

- Set from: connection string
- Defined by: Data Cache

### upgrade-force-specials

Execute special operations before the repository is opened.

- Set from: connection string
- Defined by: Data Cache



## Release Notes

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

- [Data Cache](/en/release-notes/drivers?driver=data-cache)

