We have a Copilot agent that is connected to on-prem MS SQL server through a MS Graph Connector. The Graph Connector is able to see the SQL data and it is able to index it through daily crawl. However, the Copilot agent does not seem to have access to MS Search and the semantic index created by Grpah Connector as it is not able to answer any questions about the SQL data. How can we ensure Copilot agent has access to MS Search and indexed data so that it can answer questions given in natural language about the SQL data?
I'm not sure but I think that this custom connector is still in preview, probably it's not working as expected. But why not trying it another way?
1. Define a flow with the input paramter as SQL query and output with table contents/results.
2. Create a topic to call the flow.
3. Use Generative answers to generate an SQL query based on the user input prompt.
4. Return the results with Generative answers.
I've prepared something like that, but for ODATA queries and it worked quite well. Here I've also tested it with Claude Haiku model, it also worked very well: https://claude.ai/share/29ffa05c-7178-47f0-8131-91972824343b. It should be quite easy to integrate it with any model you like.
In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
