Hi all,
I'm looking to push some data from hosted feature services to a legacy SQL Azure DB on a schedule. This DB is publicly exposed but secured.
When I try to open a connection using PyODBC, I get an error saying that the driver can't be found. In a desktop environment I've been able to connect using "SQL Server" as the driver in the connection string, but I've tried a few other variations of SQL Server driver names. I'm guessing that the driver isn't available within the Notebook environment and it can't be added, but looking for confirmation before I start building a workaround (Azure Functions to hit the DB or something probably)... has anyone successfully made this type of connection in an AGOL Notebook?
Thanks!