ODBC Db Store | beVault

Description	Connection to an ODBC database
Type	odbc
Category	Db

Configuration in States

The ODBC Db Store can be configured directly in the States interface via the Data Stores module. The following configuration modes are available:

Parameters

Name	Description	Mandatory	Default	Comment
DSN	The Data Source Name of the ODBC connection, as configured on the Worker's host	Yes	—	The DSN must exist on the machine where the Worker is deployed

Connection String

A connection string can be entered manually instead of using the parameter form. For the full list of supported connection string parameters, refer to the Microsoft OdbcConnection documentation.

Local Configuration

The local configuration is defined in a JSON file (stores.json) deployed directly on the Workers' server. A locally configured store takes priority over a store with the same name configured in the States interface.

Name	Description	Type	Mandatory	Comment
ConnectionString	The connection string to connect to the database	string	True

JSON

{
    "Name": "propilot",
    "Type": "odbc",
    "HealthCheck": true,
    "Config": {
        "ConnectionString": "DSN=MyConnection"
    }
}