Automate CRUD operations in Kognitos with the Database Book.
The following documentation is for the Legacy Database book. Refer to the latest version here.
Overview
The Database book allows you to connect to a database in Kognitos and automate creating, retrieving, updating, and deleting records.
This book currently only supports Microsoft SQL Server (MSSQL). Other database types are not currently supported.
Adding the Legacy Database Book
Before using the Legacy Database book, you must first install it on your agent, which will require configuration. You will need the following credentials:
#
Field
Description
Example
1
Database Username
The database username used for authentication.
db_user
2
Database Password
The password for the database user.
secureP@ss123
3
Database Host
The database server host.
dummy-host.database.net
4
Database Name
The name of the database to connect to.
my_database
5
Database Engine
The type of database engine being used.
mssql
After successfully learning the Book, you can use its procedures in your automations.