Microsoft SQL Server

This quickstart describes how to create a Microsoft SQL Server connection.

Create a connection to Microsoft SQL Server

To ingest data from Microsoft SQL Server using Upsolver, you must first create a connection that provides the appropriate credentials to access your database.

Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.

Here’s the code for creating a connection to SQL Server:

// Syntax
CREATE MSSQL CONNECTION <connection_identifier> 
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = 'your username'
    PASSWORD = 'your password';

// Example
CREATE MSSQL CONNECTION my_sqlserver_connection
  CONNECTION_STRING = 'jdbc:sqlserver://ms-sqlserver-1.myendpoint.us-east-1.rds.amazonaws.com:1433;DatabaseName=mydb'
  USER_NAME = 'your_username'
  PASSWORD = 'your_password'

After you complete this step, you should see the my_sqlserver_connection connection in your navigation tree.

---

Learn More

Please see the SQL command reference for Microsoft SQL Server for the full list of connection options, and examples.