MSSQL

The MSSQL connector allows you to connect directly to Microsoft SQL Servers. Once connected, you can create tabular assets that pull data from your source database into the platform.

Unlike storage connectors (e.g., Amazon S3 or Google Cloud Storage), which connect to data in files or object stores, the Microsoft SQL connector is a database connector that enables access to structured data stored in relational databases. It currently supports creating tabular assets and cannot be used as an export location.

Prerequisites

Before setting up a Microsoft SQL you must have the following information:

Host – Your database host’s IP (e.g., 1.1.1.2) or domain (e.g., my.server.com)
Port – Typically 1433 for SQL Server (this is the standard default; update if your environment uses a different port)
Database (optional for SQL Server) – Specify this to limit the connector’s scope or target a specific database
Username and Password – Credentials for the user account with read access to the required data
Firewall Rules – Ensure the platform’s IP ranges are permitted in your database or Synapse workspace firewall

Microsoft SQL Server supports encrypted connections using TLS. By default, the JDBC driver enforces encryption when connecting to Synapse.

Supported Versions:

Microsoft SQL Server 2019, 2022

Setting	Microsoft SQL
Username Format	username
Database	Optional
Default Connection (no database specified)	Connects to the default or master database
Firewall Configuration	Allow inbound connections from platform IPs

Creating the Connector

Navigate to Manage from the navigation bar.
Select Connectors to open the Manage Connectors screen.
Click Create Connector in the top right corner.
Enter a Name for your connector and an optional Description.
Select Type → Microsoft SQL
Enter the required connection details:
- Host
- Port
- Database (if applicable)
- Username
- Password
Add any Integration Metadata if needed for programmatic integration.
Click Create to save the connector.
Click Close to return to the Connectors screen.

Creating an Asset

To create a tabular asset using your Microsoft SQL or Synapse connector:

Select Create Asset from the navigation bar.
Choose Tabular as the asset type.
Select your Microsoft SQL connector from the list.
If your connector does not have a database specified, choose a database from the dropdown.
Select a Schema and Table/View.
Complete the remaining configuration steps and Release the asset.

Once released, the asset can be:

Shared directly with other users
Added to a data product
Consumed via data sharing or integrations

The database user configured in the connector must have read access to all schemas and tables intended for asset creation. For best practice, use a service account created specifically for the platform integration, rather than a personal or admin account.