Comment on page

Microsoft SQL Server

This page describes how to create a connection to Microsoft SQL Server using a SQL command.

To ingest data from Microsoft SQL Server using Upsolver, you must first create a connection that provides the appropriate credentials to access your database.
Syntax
CREATE MSSQL CONNECTION <connection_identifier> 
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = 'your username'
    PASSWORD = 'your password' 
    [ COMMENT = '<comment>' ]
Jump to
​CONNECTION_STRING​
​USER_NAME​
​PASSWORD​
​COMMENT​
Connection options
CONNECTION_STRING — editable
Type: text
The connection string to use when connecting to the database. This string can be copied directly from your SQL Server. The connection string should include the database name at the end of the string.
USER_NAME — editable
Type: text
The user to authenticate to the database with.
PASSWORD — editable
Type: text
The password for the user.
COMMENT — editable
Type: text
(Optional) A description or comment regarding this connection.
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'
  COMMENT = 'Connection to SQL Server';

Hive Metastore

MongoDB

Last modified 3mo ago

Microsoft SQL Server

Syntax

Jump to

Connection options

`CONNECTION_STRING` — editable

`USER_NAME` — editable

`PASSWORD` — editable

`COMMENT` — editable

Example