topic Re: How to use arcpy to list Database Connection Files in Geoprocessing Questions

How to use arcpy to list Database Connection Files

Anonymous User — Mon, 04 Jun 2018 21:19:41 GMT

On my own machine, I know that my Database Connections are in C:\Users\<username>\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog . I also know that %APPDATA% will take me half-way there. On another person's machine, the user name will be different, but the version of Desktop might be also. I need to write, distribute, and run a script in my organization on selected machines. The script has to find the full path to a database connection that we all have so that I can use it in arcpy.mapping. I tried arcpy.ListWorkspaces() but that returns None.

What arcpy function can I use to list the full Windows path to database connection files on the current user's machine?

Re: How to use arcpy to list Database Connection Files

CarlosNantes — Mon, 25 Mar 2019 18:12:19 GMT

This question has been asked for some time now. I had the same doubt today and it seems arcpy still doesn't have such a function, but here it goes an alternative:

import os

import arcpy

def sdeConnections():

appdata = os.getenv('APPDATA')

arcgisVersion = arcpy.GetInstallInfo()['Version']

arcCatalogPath = os.path.join(appdata ,'ESRI',u'Desktop'+arcgisVersion, 'ArcCatalog')

sdeConnections = []

for file in os.listdir(arcCatalogPath):

fileIsSdeConnection = file.lower().endswith(".sde")

if fileIsSdeConnection:

sdeConnections.append(os.path.join(arcCatalogPath, file))

return sdeConnections