Get list of database connections in arcpy

Question

Hi guys,

I want to get list of my database connections (see pic.)  in Arcpy to display them in my tool dropdown list, i try next code:

workspaces = arcpy.ListWorkspaces("*", "SDE")
    for workspace in workspaces:
        print workspace

but it does not give any result.  How can i do that?

Thank you

WilliamChandler · Answer

If I was looking for a list of SDE connection in the workspace I would do it this way

import arcpy, os
ROOT_DIR = os.path.dirname(arcpy.env.workspace)
for file in os.listdir(ROOT_DIR):
if file.endswith(".SDE"):
print(file)

DominicRobergeIADOT · Answer

Hello, for me all me SDE connections are in the same folder (workspace) so if you define the workspace, you should get your listing of SDE databases. Worked for me. 🙂 (in Catalog, right click the SDE connection, select properties and look at the path of the "name")

import arcpy

arcpy.env.workspace = r"C:\Users\USERNAME\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog"

# List all file geodatabases in the current workspace
workspaces = arcpy.ListWorkspaces("*", "SDE")

for workspace in workspaces:
    print workspace

DanPatterson · Answer

You will need to post the code that show that and the actual workspace so one can assess whether your database connections are associated with it