Skip to content

Common connection properties:

This is list of common properties.

They are inside given data source configuration file. For example: postgresTest-source_1.conf These properties are saved in this format there:

"properties": {
    "ApplicationName": "testApp",
    "testQuery": "SELECT 1",
    "defaultCatalog": "test",
    "url": "jdbc:postgresql://localhost:5432/${database}"
},

⚠️ Note: You can use SHIFT with mouse scroll to scroll horizontally!

Key Description Possible values Default
initSQLAsync When using an Async rule, a SQL statement to execute on initializing the connection String -
authJdbcUrl Alternate JDBC URl to use when pulling authentication information for SQL Auth Boolean -
dbChanges Query to use to pull database changes String -
dbTimeMs a query to retrieve the current time per the DB in milliseconds since Epoch String -
dbTriggerTracking If table based tracking should be used Boolean false
hdConnectRetryCount For Heimdall connections, how many retries are to be performed before flagging a failure Integer 3
hdConnectRetryDelay For Heimdall connection retries, what should the delay be between retries (in ms)--this value will be doubled on every retry Integer 0
hdConnectTimeout For Heimdall connections, the connection timeout (in ms, but some drivers will only honor at per-second increments) Integer 1000
hdPasswordRotate Enable password rotation logic to roll DB passwords during rotation windows Boolean false
hdRewriteInserts When using an Async rule, rewrite multi-row inserts into a single command Boolean -
defaultCatalog Used when a database/catalog is not provided, i.e. for health-checks when ${catalog} or ${database} is specified in a URL String -
defaultSchema Used when a schema is not provided, i.e. for health-checks when ${schema} is specified in a URL String -
defaultHost Used when a hostname is not provided, i.e. for health-checks when ${host} is specified in a URL String -
hdUseServerInfo Should use heimdall.server_info table (provides an alternative control point to manage values for load balancing) Boolean false