Documentation

Microsoft SQL Server

Updated on

Sep 5, 2024

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.

Schema information

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:

  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%}

  1. Specify the Schema of your database.
  2. 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%}

  1. Select the necessary Use Columnstore Index option from the dropdown.

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Microsoft SQL Server
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.