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; } } }

explore GIS Connections with arcpy

KoenBOULPAEP1

Dear all,

Has anyone tried to list the different GIS connections in the catalog side window using python?

I want to run a little script that lists all my ArcGIS, WMS, etc connections, so I can share it with colleagues.

I did some research and found nothing.

Can you point me in the right direction?

Kind regards,

Koen

ERCC

Trouver plus de publications taguées avec

Accepted answers

All comments

KoenBOULPAEP1

Dear all,

I thank you kindly for the answers.

I didnt know the links were in a folder stored. This would have made my life easier.

Now I will test it (when I'm back on this project).

Kind regards,

Koen

ERCC

RebeccaStrauch__GISP

As Jonathan mentioned, they are all physically in C:\Users\<username>\AppData\Roaming\ESRI\Desktop<version>\ArcCatalog unless you have connections in non-default folders.

Why not just copy and paste? Is there a reason you need it in a script? You can copy them to a shared network location and write a simple script to copy and paste to their Roaming file, or just have them share them from that location. Just giving an alternative.

XanderBakker

Probably not the way to do it, ... but you could do this:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> os
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> glob

&nbsp;&nbsp;&nbsp; fldr_user <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>expanduser<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'~'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'AppData\Roaming\ESRI'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; lst_desktop <SPAN class="operator token">=</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fldr_user<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Desktop*'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; fldr_desktop <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN>lst_desktop<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN>len<SPAN class="punctuation token">(</SPAN>lst_desktop<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; fldr_catalog <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fldr_desktop<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ArcCatalog"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fldr_user
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fldr_desktop
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fldr_catalog

&nbsp;&nbsp;&nbsp; wildcards <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'*.sde'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*.ags'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*.wms'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> wildcard <SPAN class="keyword token">in</SPAN> wildcards<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> wildcard
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lst_conn <SPAN class="operator token">=</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fldr_catalog<SPAN class="punctuation token">,</SPAN> wildcard<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> conn <SPAN class="keyword token">in</SPAN> lst_conn<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> conn

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In my case with 10.3 installed at home it returns this:

C:\Users\Xander\AppData\Roaming\ESRI
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog
*.sde
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\PROD.sde
*.ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on epm-app25 (user) (2).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on epm-app25 (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on geo.molg.pna.ps_6080 (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on imagery.arcgisonline.com (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on mapas.catastrobogota.gov.co (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\ArcGIS on sampleserver1.arcgisonline.com (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\ArcGIS on sampleserver3.arcgisonline.com (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\ArcGIS on server.arcgisonline.com (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\arcgis on www.medellin.gov.co (user).ags
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\saint on sagisservices.thempc.org (user).ags
*.wms
C:\Users\Xander\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\Specialty_ESRI_StatesCitiesRivers_USA on sampleserver1.arcgisonline.wms<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

There are probably more searches (wildcards) you could include.

JonathanQuinn

Only the names, unfortunately. The arcpy.Describe function can return workspace properties for an SDE connection, but nothing currently exists for GIS connections.

Asrujit_SenGupta

Well, after reading Jonathan's reply, I re-read the question and looks like you were not asking for a way to list the active connections to an Enterprise geodatabase. Rather the GIS connections on a particular machine. That was a hurried response on my part.

If I understand correctly, looping through the contents of the folder will just give the name. Or it can list the properties as well through some functions?

JonathanQuinn

Those connections are physically stored under C:\Users\<username>\AppData\Roaming\ESRI\Desktop<version>\ArcCatalog, so you can loop through the contents of that folder to find what you need.

Asrujit_SenGupta

The examples below are for SQL Server and Oracle, but others will be similar:

Manage connections in SQL Server—Help | ArcGIS for Desktop

Manage connections in Oracle—Help | ArcGIS for Desktop

You can also directly query the Process_information table in the database, which will also provide the list of active connections.

https://community.esri.com/groups/geodatabase?sr=search&searchId=61d436cb-0eb1-4a29-a573-888872215f13&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=094efce3-b418-4de4-8db9-82c80f19170e&searchIndex=1‌

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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