Documentation

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.

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:

1. Enter a name for your Destination connection in the Title.
2. Enter the Host.
3. Enter the Port.
4. Enter the User Name.
5. Enter the Password.
6. Enter the Database Name. {%dropdown-button name="database-name"%}

{%dropdown-body name="database-name"%}

Database Name must satisfy the following regular expression: ```r'^[a-zA-Z@_#]([\w@$#])*$'```.

{%dropdown-end%}

7. Specify the Schema of your database.
8. Select the necessary Use static IP option from the dropdown. {%dropdown-button name="use-static-ip"%}

{%dropdown-body name="use-static-ip"%}

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

{%dropdown-end%}

9. Select the necessary Use Columnstore Index option from the dropdown.
10. Select the necessary Use binary strings option from the dropdown. {%dropdown-button name="use-binary-strings"%}

{%dropdown-body name="use-binary-strings"%}

The "Use binary strings" determines whether string fields are encoded in binary format when loading data.

Recommended setting: "No" (default).

{%dropdown-end%}

‍