Governed Knowledge Assistant - Azure Teams (Dubai)
2025•Case Study
Hybrid RAG + Text-to-SQL assistant with permissions for 1,500+ enterprise users.
The Challenge
- Seven departments working in silos
- Data spread across ERP, CRM, SharePoint, and ad-hoc exports
- Need secure answers with enforced access control
The Solution
Teams bot interface
Hybrid RAG over unstructured content and Text-to-SQL over curated data
Row-level security and metadata-based filtering at query time
Impact
Reporting turnaround reduced from days to seconds
Single governed entry point for about 1,500 users
Increased compliance through permission enforcement
Technical
Implementation Details
Azure Data Factory and Synapse pipelines, ADLS Gen2 zones, Azure AI Search hybrid index, embeddings via Azure OpenAI, GPT-4o SQL generation, Azure Functions orchestration, adaptive card responses with citations and redaction.