util

util / MsSqlServerConfig / 1.0.0

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

ParameterDescription
serverMsSqlServer DB Host
userMsSqlServer Username
passwordMsSqlServer 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:

ParameterDescription
namespaceany alphanumeric string
configserver, user, and password

example:

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