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

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:

example:

{
	"namespace": "staging",
	"config": {
		"server":"fakeserver.net",
		"user":"someuser",
		"password":"somepass"
	}
}