Connecting SQL to Copilot Studio скачать в хорошем качестве

Connecting SQL to Copilot Studio

Learn how to connect your on-premise SQL Server to Copilot Studio using the Power Platform Data Gateway. In this session, I’ll demonstrate how you can query your local SQL database with natural language, as well as create and update records directly from Copilot Studio agents. We’ll start by walking through the setup of the on-premise data gateway, connecting it to Copilot Studio, and adding SQL tables as knowledge sources. Then I’ll show you how to enhance your agent with SQL actions and tools, so you can build powerful solutions that read and write back to your local systems in real time. Whether you’re looking to extend your agents with local data, integrate legacy systems, or simply learn how to bridge on-prem SQL with the Power Platform, this demo will give you everything you need to get started. 📌 Key Highlights: 0:00 - Introduction: Local SQL & Data Gateway 0:44 - Setting up SQL tables & schema 1:31 - Connecting to SQL Server with Data Gateway 3:18 - Adding SQL as Knowledge in Copilot Studio 5:00 - Querying SQL with Natural Language 6:20 - Retrieving contextual order data 8:13 - Real-time updates from SQL 8:48 - Adding SQL Actions & Tools 10:05 - Creating new customer records dynamically 11:51 - Wrap-up & next steps 🫠 About me: 👋 Hi, I'm Damien Bird - Power Platform Cloud Solution Architect at Microsoft ☁️ 🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022) 🎤 Speaker at conferences across Europe, the US, and local UK user groups 💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform! 📚 Explore more: 🔗 Blog: https://DamoBird365.com 🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube 🎓 Join the Community: https://DamoBird365.Teachable.com/p/D... 💖 Support the Channel:    / @damobird365   ☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365 💼 LinkedIn:   / damobird365   🐦 Twitter: https://x.com/DamoBird365 🌐 Bluesky: https://bsky.app/profile/DamoBird365.... 📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis