Copilot Studio: Connect Azure SQL As Knowledge

SQL is where the worlds data is stored. And in this video I’m going to show you how to connect your #CopilotStudio agent to #AzureSql knowledge.

We are going to do the complete setup process from end to end starting with a new SQL server and database in Azure. We will create tables and data in SQL Server Management Studio. Then we will setup a service principal for authentication.

And finally, we will connect to the database in Copilot Studio and learn how to properly configure SQL knowledge using synonyms, column descriptions and the database glossary

Table Of Contents 🎬
00:00 Introduction
01:07 Create A New Azure SQL Database
02:43 Configure Network Security Settings On The SQL Server
03:56 Install SQL Server Management Studio
04:37 Connect To An Azure SQL Database In SSMS
05:50 Create SQL Tables For Real Estate Listings And Real Estate Agents
08:41 Register A New Application in Azure
10:41 Setup A New External User In SQL Server Management Studio
11:40 Add Azure SQL Server As A Knowledge Source In Copilot Studio
14:56 Test The Agent's Ability To Answer Questions
16:25 Add Synonyms And Descriptions To Table Columns
20:10 Build A Data Glossary For The Azure SQL Knowledge

Follow along with these written instructions ✍
https://www.matthewdevaney.com/copilot-studio-connect-an-azure-sql-database-as-knowledge/

Get the tutorial files on Github ⭐
https://github.com/matthewdevaney/Copilot-Studio-Tutorials/tree/main/Copilot%20Studio%20Connect%20To%20Azure%20SQL%20Knowledge