> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/guides/platform/integrations/mssql.md).

# MSSQL

Overview of the MSSQL integration.

{% hint style="info" %}
The following documentation is for **MSSQL v3.4.1**.
{% endhint %}

## Overview

The MSSQL integration provides comprehensive database connectivity for SQL Server-based data operations. This integration supports data querying, record creation, updates, deletions, and complex database transactions. Enable seamless data management and integration with Microsoft SQL Server databases.

## Setup

The following integrations need to be connected to your Kognitos workspace:

* **MSSQL**

### Steps

Follow these steps to connect the integration in Kognitos:

{% stepper %}
{% step %}

#### Navigate

Using the left navigation menu, go to **Integrations** → **Explore Integrations**.
{% endstep %}

{% step %}

#### Find

Search for the integration and click on it.
{% endstep %}

{% step %}

#### Connect

Click on <kbd>**Connect**</kbd> to add a connection to the integration.
{% endstep %}

{% step %}

#### Configure

Add a name for the connection. You'll be prompted for [**authentication**](#authentication) details if needed. Then, click on <kbd>**Connect**</kbd>.
{% endstep %}
{% endstepper %}

## Authentication

Use one of the following authentication methods to connect this integration in Kognitos. Each method has its own configuration requirements.

### Connect using Host, Port, Username, Password and Database Name

Connect to a Microsoft SQL Server database using the provided connection parameters.

| Label         | Description   | Type        |
| ------------- | ------------- | ----------- |
| Host          | Host          | `text`      |
| Port          | Port          | `text`      |
| Username      | Username      | `text`      |
| Password      | Password      | `sensitive` |
| Database Name | Database Name | `text`      |

### Connect using Host, Port, Database Name, Client ID, Client Secret and Tenant ID

Connect to an Azure SQL database using Microsoft Entra ID (Azure AD) authentication.

| Label         | Description                        | Type        |
| ------------- | ---------------------------------- | ----------- |
| Host          | Host                               | `text`      |
| Port          | Port                               | `text`      |
| Database Name | Database Name                      | `text`      |
| Client ID     | Azure AD Application Client ID     | `text`      |
| Client Secret | Azure AD Application Client Secret | `sensitive` |
| Tenant ID     | Azure AD Tenant ID                 | `text`      |