Table of Contents

Search

  1. Preface
  2. Introducing Administrator
  3. Organizations
  4. Licenses
  5. Ecosystem single sign-on
  6. SAML single sign-on
  7. Metering
  8. Source control and service upgrade settings
  9. Users and user groups
  10. User roles
  11. Permissions
  12. Runtime environments
  13. Serverless runtime environments
  14. Secure Agent services
  15. Secure Agent installation
  16. Schedules
  17. Bundle management
  18. Event monitoring
  19. File transfer
  20. Troubleshooting

Administrator

Administrator

Database Ingestion Agent environment variables

Database Ingestion Agent environment variables

To change or optimize the behavior of the Database Ingestion (DBMI) Agent, define the following environment variables:
Environment Variable
Description
DBMI_REPLACE_UNSUPPORTED_CHARS
For Microsoft Azure SQL Data Warehouse targets, controls whether a database ingestion 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
Mass Ingestion Databases
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 SQL Data Warehouse target cannot process correctly.
Default value: ? (question mark)
DBMI_WRITER_CONN_POOL_SIZE
Indicates the number of connections that a
database ingestion
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
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
database ingestion
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
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.


Updated October 29, 2020