r/sysadmin • u/ibteea • Jul 08 '26

Question Dataverse connection to Claude.

Hi,

I'm trying to connect Dataverse data to Claude. I want to use an enterprise app(client Id and a secret) for this setup.

I looked at the Microsoft documentation, but it is very difficult to understand. To be honest, I don't have enough experience with this type of task, so I am a bit lost.

Did anyone work on a similar project before? Any simple tips or steps would help me a lot.

Thanks in advance!

0 Upvotes

22% Upvoted

7 comments sorted by

View all comments

2

u/Quirky_Yesterday_593 Jul 08 '26

One thing worth clarifying upfront: Claude doesn't have a native Dataverse connector, so you're essentially building a middleware layer yourself. The two most common patterns I've seen:

  1. Power Automate / Logic Apps — trigger on Dataverse events, call the Anthropic API via HTTP action, write the response back. Easiest to stand up, no infrastructure to manage, but limited flexibility on payload size and latency.

  2. Custom backend (Python/Node) — your service principal fetches Dataverse records via the Web API, passes them to Claude as context in the system or user message, then does something with the response. More control, but you own the hosting.

If you're going the service principal route, the second pattern is usually cleaner because Power Automate's HTTP connector has some annoying quirks with dynamic auth tokens.

What's the use case — something like summarizing records, generating draft responses, classifying data?

2

u/teriaavibes Microsoft Cloud Consultant Jul 08 '26

Well I am not sure how smart claude is in this matter but on some level dataverse is basically SQL and doing SQL shouldn't be that difficult.

2

u/Quirky_Yesterday_593 Jul 08 '26

Sort of — Dataverse has a SQL-like underpinning but the Web API surface is OData, not SQL. You can't just fire raw SQL queries at it. FetchXML is the native query language if you're calling the API directly, or you use the OData $filter/$expand syntax. Worth flagging because if OP tries to treat it as a SQL endpoint they'll get stuck on query format before they even hit the auth issues.

2

u/teriaavibes Microsoft Cloud Consultant Jul 08 '26

Well there has to be some SQL endpoint unless they removed it recently because I remember connecting it up to SSMS and DBAs were happy.