Data source examples

The following are examples of valid RDBMS data source configurations:

RDBMS minimum data source configuration

{

"ConnectString": "DSN=MyDSN",

"DataProvider": "ODBC"

}

RDBMS data source configuration with username and password

Note: The ConnectString parameter will be encrypted, so it is safe to include a password or other secrets.

{

"ConnectString": "Server=ServerName\\SQLEXPRESS; UID=MyUser; PWD=Password",

"DataProvider": "sqlServer"

}

RDBMS data source configuration with Windows authentication

{

"ConnectString": "Server=ServerName\\SQLEXPRESS; Database=MyDB; trusted_connection=yes;",

"DataProvider": "SQLServer",

"WindowsUser": "MyDomain\\MyUser",

"WindowsPassword": "MyPassword"

}

RDBMS data source configuration with server-side failover

{

"ConnectString":"driver={MySQL ODBC 9.4 Unicode Driver};server=SQLMachine1;port=3308;",

"SecondaryConnectString": "driver={MySQL ODBC 9.4 Unicode Driver};server=SQLMachine2;port=3308;",

"enableServerFailover":"True",

"DataProvider":"ODBC",

"StreamIDPrefix":"MyImportantTags_",

"DataCollectionMode":"CurrentOnly"

}