topic Connect to SDE with arcpy in Geoprocessing Questions

Connect to SDE with arcpy

ChrisMathers — Fri, 13 Aug 2010 18:40:28 GMT

All I can find in the help for connecting to an SDE with arcpy is how to make a SDE connection file. I already have one of those because the SDE is available in catalog (C:\Documents and Settings\cmathers\Application Data\ESRI\ArcCatalog\OSA@sde@bay-gis.sde). I just want to know how to read that file with arcpy and then read some data from the server. How do I connect to the SDE from python?

Re: Connect to SDE with arcpy

AndrewChapkowski — Sun, 12 Dec 2021 06:42:07 GMT

To list data from the server, you can do something like this:


import arcpy
from arcpy import env
env.overwriteOutput = True
env.workspace = r"C:\Documents and Settings\cmathers\Application Data\ESRI\ArcCatalog\OSA@sde@bay-gis.sde"
fcList = arcpy.ListFeatureClasses()

# Copy shapefiles to a file geodatabase
#
for fc in fcList:
    print fc

That's just one example of how you can use sde connection files.

If you wanted to reference a feature class, you could do something like this:
fc = r"C:\Documents and Settings\cmathers\Application Data\ESRI\ArcCatalog\OSA@sde@bay-gis.sde\<FeatureClassName>"

Hope this helps.

Re: Connect to SDE with arcpy

ChrisMathers — Mon, 16 Aug 2010 13:17:38 GMT

Thanks a lot. Using the sde file as the workspace is just what I needed to know!