SQL Server
Connect & Ingest data from / to a SQL Server database
The following credentials keys are accepted:
host
(required) -> The hostname / ip of the instanceuser
(required) -> The username to access the instancedatabase
(required) -> The database name of the instanceschema
(optional) -> The default schema to usepassword
(optional) -> The password to access the instanceport
(optional) -> The port of the instance. Default is1433
.ssh_tunnel
(optional) -> The URL of the SSH server you would like to use as a tunnel (examplessh://user:[email protected]:22
)ssh_private_key
(optional) -> The private key to use to access a SSH server.
Here is an example of setting a connection named
MSSQL
. We must provide the type=sqlserver
property:$ sling conns set MSSQL type=sqlserver host=<host> user=<user> database=<database> password=<password> port=<port>
# Or use url
$ sling conns set MSSQL url=sqlserver://myuser:[email protected]:1433/mydatabase
export MSSQL='sqlserver://myuser:[email protected]:1433/mydatabase'
Last modified 1mo ago