README.md
Overview
Before using the util/MsSqlServer algorithm to query databases, you must first configure your MsSqlServer credentials via this algorithm. The configuration will be stored in a Hosted Data collection accessible only by you.
Usage
Parameter | Description |
---|---|
server | MsSqlServer DB Host |
user | MsSqlServer Username |
password | MsSqlServer Password |
Any other parameter allowed in pymssql.connect(), such a port
, may be optionally added.
example:
{
"server":"fakeserver.net",
"user":"someuser",
"password":"somepass"
}
Specifying namespaces
You may wish to be able to store different sets of credentials; you can do so by specifying a namespace as follows:
Parameter | Description |
---|---|
namespace | any alphanumeric string |
config | server, user, and password |
example:
{
"namespace": "staging",
"config": {
"server":"fakeserver.net",
"user":"someuser",
"password":"somepass"
}
}
Contents