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"

}