Our great sponsors
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Over the past couple of days I was not able to do this using the Sql.Database() function, but I did find an ODBC DirectQueryForSQL sample under github.com/microsoft/DataConnectors that I was able to modify to do this. I would prefer to Sql.Database() so we don't have the SQL Native Client ODBC driver as prerequisite, so I am still trying to wrap my head around the authentication issues I had doing it that way, but I seem to have cleared my first couple of hurdles and am doing okay for now.
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.