# Exchanging data with Microsoft SQL Server (MSSQL)  
  
**Cognigy Support**  
  
March 29, 2021  
  
## Challenge  
  
You want to read data from a SQL Server database table or write data to a SQL Server database table.  
  
## Solution  
  
### Create a Database Connection  
  
In order to use the database inside Cognigy.AI, a Connection needs to be created. In this case, the following values are required:  
  
- **host**  
  - _The database server, such as sqlserver.database.windows.net_  
- **port**  
  - _The database port, such as 1433 for secured connections_  
- **username**  
  - _The database username_  
- **password**  
  - _The password of the user_  
- **database**  
  - _The name of the database, such as Products or MyDatabase_  
  
The above-listed values can be extracted from a database instance, for example in Microsoft Azure. Please read the following documentation in order to set up a Microsoft database:  
- [Azure: Create a single database](https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?tabs=azure-portal)  
  
### Use SQL Flow Nodes  
  
One can query MSSQL using Cognigy.AI's inbuilt SQL nodes: [https://docs.cognigy.com/docs/sql-node](https://docs.cognigy.com/docs/sql-node)  
  
### QnA  
- [Exchanging data with Microsoft SharePoint](https://support.cognigy.com/hc/en-us/articles/360017535580-Exchanging-data-with-Microsoft-SharePoint)  
- [Exchanging data with Microsoft SQL Server (MSSQL)](https://support.cognigy.com/hc/en-us/articles/360017591799-Exchanging-data-with-Microsoft-SQL-Server-MSSQL)  
- [Using CognigyScript in Twilio Twiml XML](https://support.cognigy.com/hc/en-us/articles/360017594519-Using-CognigyScript-in-Twilio-Twiml-XML)  
- [How can I adjust the style of the Webchat Widget](https://support.cognigy.com/hc/en-us/articles/360017744619-How-can-I-adjust-the-style-of-the-Webchat-Widget)  
- [Accessing Information about the Cognigy.AI API](https://support.cognigy.com/hc/en-us/articles/360017847180-Accessing-Information-about-the-Cognigy-AI-API)  
- [Trigger Microsoft Power Automate Flows](https://support.cognigy.com/hc/en-us/articles/360018426159-Trigger-Microsoft-Power-Automate-Flows)  
- [Handling HTTP Request Errors](https://support.cognigy.com/hc/en-us/articles/360018593139-Handling-HTTP-Request-Errors)  
- [How to add a member to your virtual agent](https://support.cognigy.com/hc/en-us/articles/360018858279-How-to-add-a-member-to-your-virtual-agent)  
- [Add a new user to your Cognigy.AI organization](https://support.cognigy.com/hc/en-us/articles/360018858559-Add-a-new-user-to-your-Cognigy-AI-organization)  
- [Identifying a Unique Endpoint via analytics](https://support.cognigy.com/hc/en-us/articles/360020000099-Identifying-a-Unique-Endpoint-via-analytics)