Community
Select to view content in your preferred language

Connect to SQL Server through Arcpy in Advanced Notebook Server

959
2
06-26-2023 08:40 PM
Status: Closed
SamKeast2
by
Emerging Contributor

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.

2 Comments
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

NicholasGiner1
by Esri Contributor
‎01-22-2025 03:10 PM
Status changed to: Closed

Hello, we added SQL Server client libraries in the ArcGIS Enterprise 11.2 release (Nov. 9, 2023).  Please see this document detailing the specific enhancement (ENH-000155341) in the Notebook Server section.

https://downloads.esri.com/support/downloads/other_/112-IssuesAddressedList_11072023.pdf

thank you,

Nick Giner, Product Manager