Community
Select to view content in your preferred language

Connect to SQL Server through Arcpy in Advanced Notebook Server

527
1
06-26-2023 08:40 PM
Status: Open
SamKeast2
by
New Contributor II

Our organisation has ArcGIS Portal 10.9.1 and an advanced ArcGIS Notebook license. We are not able to connect to our Enterprise geodatabase that is built on top of SQL Server - using Arcpy in Notebook server. It would be great to have the ability to connect to SQL Server Enterprise databases in a future version of Notebook server under ArcGIS enterprise.

1 Comment
Justin_Greco
by
‎06-19-2024 09:56 AM

This is possible, though not out of the box, you will need to extend the Advanced image and install the SQL ODBC driver on a custom image.  Out of the box the Docker images don’t install database drivers (probably because of the variety of DBs supported).  There are instructions in the documentation:

https://enterprise.arcgis.com/en/notebook/latest/administer/windows/extend-a-notebook-runtime.htm

They give a specific example for the SQL Drivers in the 11.1 documentation, though I had to make some adjustments to get it to work.

https://enterprise.arcgis.com/en/notebook/11.1/administer/windows/extend-a-notebook-runtime.htm