nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to crawl for SDEs based on a server instance?

DavidWasserman

This question comes from a couple places.
There are several threads about automating SDE compression, and good python examples on how to get started too.
To my understanding, the ListWorkspaces functions can find SDEs in a work space (in this case Database Connections). However, what I want is something similar to the DA walk function that discovers workspaces, except I want it to discover all possible database connections associated with a server instance (assuming I could deal with the UN/PW concerns). I know I could create database connections, if I had the SDE names, but I am sure I have found anything that enables you to list them in python. Is this something that requires ArcObjects? Is there just some function or step I am missing related to the DB connections?

Thanks in advance Data Management Community.

David

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

DavidWasserman

Hey Joshua,

Sorry for the confusion. As some background I am familiar with working with ArcGIS server in the desktop environment, but not necessarily in python directly. I am imagining that in order to connect to an SDE that is using SQLServer, I need to use the Create DB Connection tool (using 10.3 or later correct?). The issue is I am assuming in only know the instance name, but not the name of the SDE which is also required by the tool.
The goal is to run a compression tool on all SDEs encountered in the instance essentially.

A script I am thinking about would look like this.

# Name: CreateDatabaseConnections.py
# Description: Will use a server instance and authentication to derive SDEs connections that will then have the Compress tool ran on them as 
# as part of on going server maintance. 
# Import system modules
import arcpy

def find_sdes_from_server_instance(server_instance):

     "Function will look at all SDEs on a server instance and return their names as a list"
     return ["Roads.sde","Bikes.sde","BuiltEnv.sde", SomeOther.sde] # Example return

sde_name_list=find_sdes_from_server_instance("MYSQL_SERVER")
for sde in sde_name_list:
     arcpy.CreateDatabaseConnection_management("Database Connections", sde, "SQL_SERVER", "utah", "DATABASE_AUTH", "gdb", "gdb", "SAVE_USERNAME", "garfield", "#", "TRANSACTIONAL", "sde.DEFAULT")
     .... more stuff

     arcpy.Compress_management(connection_file)
clean up....

JoshuaBixby

Honestly, I am more confused than ever as to what you are trying to do. Yes, an SDE connection file has to exist in order to see the properties within the file. If you want to "spontaneously create the SDE connection files," why do you need to search for them?

If you could try elaborating again, I am willing to take another stab and offering a suggestion.

DavidWasserman

Hey Joshua,

I guess I do want the files or specifically the SDE names, but I guess I want to spontaneously create the SDE connection files based on the server instance. I think were were interested in one server in particular, but I understand it is a risky proposition generally. I will give walk a try then and report back.

I guess do the SDE connection files have to exist before you look for them (IE have you had to connect to the SDE before). My assumption is the script will only know the server instance to crawl.

It might be what I want already exists, so I think I will give the walk function more scrutiny in this example.

JoshuaBixby

It appears you are talking crawling file systems and not connections from layers in map documents or similar. The ArcPy Walk function will see/find SDE connection files if followlink is True, but I always hesitate to enable that because I usually don't want it following link to GIS servers and what not.

If you use the regular Python walk and search for SDE connection files (*.sde), you can use ArcPy Describe to check the connection properties of the connection file for the server instance of interest.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.