MSSQL

Overview of the MSSQL BDK Book.

Overview

Relational database integration provides comprehensive database connectivity for SQL-based data operations. This integration supports data querying, record creation, updates, deletions, and complex database transactions. Enable seamless data management and integration across various database systems.

Prerequisites

1. Add the Book to Your Agent

To use the MSSQL (BDK) Book, you need to add it to your agent. This allows the agent to learn and execute the automation procedures in the Book. Follow the steps below to get started:

1. Go to Books from the left navigation menu.

2. Click on + New Book.

3. Search for MSSQL (BDK) and click on the book.

4. You'll be prompted for connectivity details if the book requires configuration.

5. Click on Add to finish adding the book to your agent.

6. Publish your agent.

Connectivity

This section outlines the available methods for connecting to the Book, along with the required configuration details for each.

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

Establishes a connection to the MSSQL database using the provided connection parameters.

Label	Description	Type
Host	Host	text
Port	Port	text
Username	Username	text
Password	Password	text