Microsoft SQL Server

This page describes how to create and maintain connections to your SQL Server database.

Before ingesting your data from Microsoft SQL Server, you must establish a connection to your database.

Create a SQL Server connection

Simple example

A SQL Server connection can be created as follows:

CREATE MSSQL CONNECTION my_sqlserver_connection
  CONNECTION_STRING = 'jdbc:sqlserver://ms-sqlserver-1.myendpoint;DatabaseName=MyDb'
  USER_NAME = '<user_name>'
  PASSWORD = '<password>';

Alter a SQL Server connection

Some connection options are considered mutable, meaning that in some cases, you can run a SQL command to alter an existing SQL Server connection rather than create a new one.

To change the database you are connecting to but keep everything else the same without having to create an entirely new connection, you can run the following command:

ALTER MSSQL CONNECTION my_sqlserver_connection
    SET CONNECTION_STRING = 
       'jdbc:sqlserver://ms-sqlserver-1.myendpoint;DatabaseName=customers'

Drop a SQL Server connection

If you no longer need a connection you can easily drop it with the following SQL command:

DROP CONNECTION my_sqlserver_connection;

However, note that if existing tables or jobs depend upon the connection, the connection cannot be dropped.

---

Learn More

To discover which connection options are mutable, and to learn more about the options, please see the SQL command reference for Microsoft SQL Server.