idea Connect to SQL Server through Arcpy in Advanced Notebook Server in ArcGIS Notebooks Ideas

Connect to SQL Server through Arcpy in Advanced Notebook Server

SamKeast2 — Tue, 27 Jun 2023 03:40:45 GMT

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.

Re: Connect to SQL Server through Arcpy in Advanced Notebook Server

Justin_Greco — Wed, 19 Jun 2024 16:56:14 GMT

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

Re: Connect to SQL Server through Arcpy in Advanced Notebook Server - Status changed to: Closed

NicholasGiner1 — Wed, 22 Jan 2025 23:10:37 GMT

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