MSSQL

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Reads data from Microsoft SQL Server tables.

Configuration

source:
  kind: mssql
  connection_string: ${MSSQL_CONNECTION_STRING}

Field	Default	Description
connection_string	(required)	ADO.NET connection string

Namespace: mssql.{database}.{schema}.{table}

CLI

skippr connect source mssql \
  --connection-string '${MSSQL_CONNECTION_STRING}'

Or run without flags to be prompted interactively.

Flag	Description
--connection-string	ADO.NET connection string

Config output

Running connect source mssql writes the following to skippr.yaml:

source:
  kind: mssql
  connection_string: ${MSSQL_CONNECTION_STRING}

Set the env var before running skippr:

macOS / Linux

export MSSQL_CONNECTION_STRING="server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true"

Windows PowerShell

$env:MSSQL_CONNECTION_STRING = "server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true"

Windows Command Prompt

set MSSQL_CONNECTION_STRING=server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true

Authentication

Variable	Description
MSSQL_CONNECTION_STRING	ADO.NET connection string for SQL Server

Connection string format

export MSSQL_CONNECTION_STRING="server=tcp:127.0.0.1,1433;database=testdb;user id=sa;password=YourPass;TrustServerCertificate=true"

Common parameters:

Parameter	Description
server	Hostname and port (for example tcp:myserver.database.windows.net,1433)
database	Database name
user id	SQL Server login
password	Login password
TrustServerCertificate	Set to true for self-signed certs in dev or test
Encrypt	Set to true for Azure SQL or production workloads

Azure SQL

For Azure SQL Database, use the fully qualified server name:

export MSSQL_CONNECTION_STRING="server=tcp:myserver.database.windows.net,1433;database=mydb;user id=myuser@myserver;password=MyPass;Encrypt=true;TrustServerCertificate=false"

Local dev with Docker

Spin up a local MSSQL instance for testing:

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=YourStrong!Passw0rd' \
  -p 1433:1433 --name mssql-dev \
  -d mcr.microsoft.com/mssql/server:2022-latest

export MSSQL_CONNECTION_STRING="server=tcp:127.0.0.1,1433;database=master;user id=sa;password=YourStrong!Passw0rd;TrustServerCertificate=true"

Permissions or Network Requirements

The SQL Server login needs read access to the tables or views you want to ingest, and the machine running skippr must be able to reach the SQL Server endpoint on the configured port.

Troubleshooting

Symptom	Fix
Login failed for user	Verify username and password in the connection string
Cannot open server	Check the server hostname, port, and network access
SSL Provider: certificate verify failed	Add TrustServerCertificate=true for self-signed certs, or install the server CA certificate

Next steps

• Pair this source with a destination from Destination Connectors.
• Start with Quick Start: Snowflake for a production-style evaluation path.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy