---
title: DB - Microsoft SQL Server
slug: litmusedge-v2/product-features/integration/integration-connectors/databases/db-microsoft-sql-server
description: Review parameters for the DB - Microsoft SQL Server connector. 
docTags: 
createdAt: 2023-12-01T18:43:28.238Z
---

Review the [Microsoft SQL Server Integration Guide](docId\:L-KGb5S37xJw2CFL7Kho0). 

## Overview

Microsoft SQL Server integration enables an Edge System to connect with an MSSQL database. 

## Supported Communication

- Outbound (Edge to SQL Server) - Yes
- Inbound (SQL Server to Edge) - No

## Configurations

| **Variable**         | **Detail**                                                                                                                                                                                                                                                                                                   | **Required** |
| -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ |
| Name                 | Enter a name for the connector                                                                                                                                                                                                                                                                               | Yes/No       |
| Hostname             | IP Address or Hostname of the MSSQL Server (Must be reachable from the Edge system)                                                                                                                                                                                                                          | Y            |
| Port                 | MSSQL Server port                                                                                                                                                                                                                                                                                            | Y            |
| Username             | User name (optional)                                                                                                                                                                                                                                                                                         | N            |
| Password             | User password (optional)                                                                                                                                                                                                                                                                                     | N            |
| Database             | Database name                                                                                                                                                                                                                                                                                                | Y            |
| Table                | Table name                                                                                                                                                                                                                                                                                                   | Y            |
| Show mapping         | Data from a predefined table could be mapped into a custom one. Example: \{"from": "to"} where "from" is a column from predefined table, and "to" is a column from destination table. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](docId\:aRn_eb7JkOU2tCNsNyQnw) to learn more.  | N            |
| Create table         | If selected and table doesn't exist, the table is created with the necessary format. See [Work with Tables in SQL Connectors (Create Table and Show Mapping)](docId\:aRn_eb7JkOU2tCNsNyQnw) to learn more.                                                                                                   | N            |
| Commit timeout       | Transaction commit timeout (ms)                                                                                                                                                                                                                                                                              | N            |
| Max transaction size | Maximum number of messages before a transaction is committed regardless of timeout                                                                                                                                                                                                                           | N            |
| Bulk insert count    | To enable this option, enter the number of messages to group together and send as one bulk insert statement. Enabling this option can improve how quickly data is processed when dealing with high volumes of tags.                                                                                          | N            |
| Throttling limit     | Set a limit on the number of outbound messages per second. If sending data to a server that has restrictions on the rate of incoming messages, this ensures that no messages are lost.                                                                                                                       | N            |
| Queue mode           | Select the sequence of data transfer: FIFO or LIFO. Selecting FIFO (First In First Out) will send the earliest message first. Selecting LIFO (Last In First Out) will send the latest message first.                                                                                                         | N            |
| Persistent storage   | If enabled, messages in the outbound queue are stored on disk. If there are interruptions in connection or power loss, messages will be retained and eventually sent when the connection is restored.                                                                                                        | N            |

## Compatibility Validation

This information is just for reference. More products and versions may be supported.

| **Product**          | **Version** |
| -------------------- | ----------- |
| Microsoft SQL Server | v15 (2019)  |
| Microsoft SQL Server | v14 (2017)  |

:::hint{type="info"}
**Note**: When the *Create table* checkbox is not selected, the table format (columns) that you will create must still adhere to the following format. 
:::

```sql
IF NOT EXISTS(SELECT *
              FROM sysobjects
              WHERE NAME = '"TABLE_NAME"'
                AND xtype = 'U')
CREATE TABLE "TABLE_NAME"
(
    id          BIGINT IDENTITY(1,1) NOT NULL,
    record_uuid CHAR(36)       NOT NULL,
    arrived_at  DATETIME       NOT NULL,
    device_id   VARCHAR(64)    NULL,
    register_id VARCHAR(64)    NULL,
    tag_name    VARCHAR(64)    NULL,
    datatype    VARCHAR(32)    NULL,
    value       TEXT           NULL,
    success     BIT            NULL,
    PRIMARY KEY (id)
)
```