Dataverse or Sharepoint
posted 1 year ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
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.
Thank you very much for reading.
posted 1 year ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
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.
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.
posted 1 year ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
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.
A for whether there's an Java API library for those products, I don't know.
Experience keeps a dear School, but Fools will learn in no other.
---
Benjamin Franklin - Postal official and Weather observer
Thomas Griffith
Ranch Hand
Posts: 220
posted 1 year ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
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.
| Won't you be my neighbor? - Fred Rogers. tiny ad: The new gardening playing cards kickstarter is now live! https://www.kickstarter.com/projects/paulwheaton/garden-cards |








