Microsoft SQL Server

Updated on May 12, 2025

Note: Microsoft SQL Server is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Microsoft SQL Server.

Description

Microsoft SQL Server is a robust relational database management system designed to store, retrieve, and manage data efficiently, widely used for various enterprise-level applications.

Setup guide

Follow our setup guide to connect Microsoft SQL Server to Improvado.

Database creation

Make sure your Microsoft SQL Server database supports COLUMNSTORE.

Permissions

You should have write access to the database and the following permissions:

BULK INSERT
INSERT
CREATE
UPDATE
DELETE
ALTER INDEX
SELECT (for tables and data)
Access to the system tables, like:

sys.partition_functions
sys.partition_schemes
sys.columns
sys.tables
sys.schemas
sys.types
sys.partition_range_values
sys.dm_db_partition_stats
sys.objects
it is recommended to have access to the whole sys schema

Usage permission on the schema dbo

Complete configuration

On the Microsoft SQL Server connection page, fill in the following fields:

Enter a name for your Destination connection in the Title.
Enter the Host.
Enter the Port.
Enter the User Name.
Enter the Password.
Enter the Database Name.

Specify the Schema of your database.
Select the necessary Use static IP option from the dropdown.

Select the necessary Use Columnstore Index option from the dropdown.
Select the necessary Use binary strings option from the dropdown.

‍