Dataverse or Sharepoint

[Thomas Griffith]

Hello. If you have a minute, is it possible to use JDBC to query either Dataverse or Sharepoint? I read that Dataverse uses SQL Azure underneath and I think that would use the same JDBC driver as on-prem SQL Server. However, SQL Azure seems to be only one component of Dataverse (it seems to store data all over the place) and it's probably impossible to access SQL Server tables by end-running the Dataverse layers. I was hoping MS would publish drivers for either product.

Thank you very much  for reading.

[Tim Moores]

A quick search finds https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query, which mentions read-only SQL access. That should mean that JDBC is a possibility.

As to SharePoint, https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-connect-sql-table-with-sharepoint-365/e48e2913-ad00-47e0-a196-d6625db4fc26 sounds to me like some hoops would have to be jumped through (if it's possible at all), but I'm not a Microsoft guy and may be misreading this.

[Tim Holloway]

I think that considering that those are exclusively Microsoft products for Windows, you're going to be better off using the Microsoft APIs rather than what limited features you can get from JDBC.

A for whether there's an Java API library for those products, I don't know.

[Thomas Griffith]

thanks, guys/ Yeah, I was going that way with the api, as I did find that site early on but it'd only GUI stuff and couldn't find an actual Java driver.  Was hoping just to get to underling SQL Azure but that's going to be totally locked down.