I have lots of structured data in an onprem local MS SQL Server. How do i add it as a ”realtime updated” knowledge data source to copilot studio? I.e to list orders in september 2024 with status= unpaid, or details of a specific orderid.
The use case of local SQL server appears sufficiently common but i havent found a standard feature to do it.
1. is there a simple standard nocode way to do it?
2. or do i need to use prompt flow and ai search? How?
3. Or should i write a rest api over the sql db backend and just make http requests from a topic?
any ideas most appreciated!