MSSQL

Overview of the MSSQL integration.

The following documentation is for MSSQL v2.0.1.

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:

1

Navigate

Using the left navigation menu, go to Integrations → Explore Integrations.

2

Find

Search for the integration and click on it.

3

Connect

Click on Connect to add a connection to the integration.

4

Configure

Add a name for the connection. You'll be prompted for authentication details if needed. Then, click on Connect.

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