Secure Agent Services

Back Next

Database Ingestion Agent environment variables

To change or optimize the behavior of the Database Ingestion agent service, you can define environment variables:

To configure environment variables, open a Secure Agent in your runtime environment and click

Edit

. Under

System Configuration Details

Custom Configuration Details

, select

Database Ingestion

as the service and

DBMI_AGENT_ENV

as the type.

Environment Variable	Description
DBMI_REPLACE_UNSUPPORTED_CHARS	For Microsoft Azure Synapse Analytics targets, controls whether an application ingestion and replication job or database ingestion and replication job replaces characters in character data that the target cannot process correctly. To enable character replacement, set this environment variable to true. DBMI_REPLACE_UNSUPPORTED_CHARS=true Application Ingestion and Replication or Database Ingestion and Replication then uses the character that is specified in the DBMI_UNSUPPORTED_CHARS_REPLACEMENT environment variable to replace unsupported characters.
DBMI_UNSUPPORTED_CHARS_REPLACEMENT	If the DBMI_REPLACE_UNSUPPORTED_CHARS environment variable is set to true, specifies the character that replaces the characters in source data that a Microsoft Azure Synapse Analytics target cannot process correctly. Default value: ? (question mark) Define this environment variable only for Database Ingestion and Replication .
DBMI_WRITER_CONN_POOL_SIZE	Indicates the number of connections that an application ingestion and replication job or database ingestion and replication job uses to propagate the change data to the target. The default value is 8. Valid values are 4 through 8.
DBMI_WRITER_RETRIES_MAX_COUNT	If a network issue occurs while a database ingestion and replication job is loading source data to an Amazon S3 or Microsoft Azure Data Lake Storage Gen2 target, indicates the maximum number of times that the job retries a request to continue the initial load or incremental load. If all of the retries fail, the job fails. The default value is 5.
DBMI_WRITER_RETRIES_INTERVAL_IN_MILLIS	Specifies the time interval, in milliseconds, that a database ingestion and replication job waits before retrying the request to continue the initial load or incremental load to an Amazon S3 or Microsoft Azure Data Lake Storage Gen2 target if a network issue occurs. The default value is 1000.

After you define or change an environment variable, restart the Database Ingestion Agent for the changes to take effect.

Rename Saved Search

Table of Contents

Secure Agent Services

Secure Agent Services

Database Ingestion Agent environment variables

Database Ingestion Agent environment variables