ArcGIS Pro Database Connections Folder - Organization

22242
9
Jump to solution
05-06-2015 07:59 AM
BenGrod
Occasional Contributor III

I'm a novice ArcGIS Pro user so forgive me for such a simple question but is there a way to put all of your Database Connection files in one location which is recognized by all Projects you open? Currently it appears that each Project has a list of Database Connection files saved under your My Documents\ArcGIS\Projects\MyProject1 folder. Is there a way to direct ArcGIS Pro to look in another folder which contains your complete set of Database Connection files (.sde). We have a ton of SDE connection files that need to be recreated in ArcGIS Pro and it would be nice to create them once and share them to all projects and users. Thanks in advance for your help.

0 Kudos
1 Solution

Accepted Solutions
WilliamPollock
New Contributor III

and there is a solution to access connections outside your Project described here:

Accessing existing .sde and .ags Connection Files in ArcGIS Pro

cheers.

View solution in original post

9 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Ben,

One thing you could do is add a folder connection (right-click on Folders > Add Folder Connection) to your project that contains all of the SDE connection files.  For example, if you have all of your SDE geodatabase connections stored under 'Database Connections' in ArcGIS Desktop, you would add the following folder:

C:\Users\<user name>\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog

Note:  It doesn't appear that ArcGIS Pro will show hidden folders (i.e. AppData) when adding a folder connection, so you will need to copy/paste the path into the Name dialog box:

screen1.png

BenGrod
Occasional Contributor III

Hey Jake, that was a good idea and in fact I thought it would work but the ArcGIS Pro application doesn't allow me to open the databases in the new folder I created. You can physically view the connections and they appear as a database but you can't open the database (see screen shot below). Not 100% sure on this one but it seems like the only way to access an enterprise database is when the connection file is in the "Databases" folder and not a normal folder connection. Any ideas? Thanks again for you help.

DB Connection Pro.png

JakeSkinner
Esri Esteemed Contributor

You're right.  I made the connection, but did not try connecting to the geodatabases.  Not sure if there is a way to do this.  Hopefully someone else may have a solution for you.

BenGrod
Occasional Contributor III

Thanks Jake, we'll figure this one out somehow, Esri must have considered this when they built ArcGIS Pro. I'll be sure to post the results to this thread,

0 Kudos
WilliamPollock
New Contributor III

Is it possible that your newly named old *.sde files cannot have periods/dots (".") to the left of the file extension?

For example, will it work  if you rename "gis.mobile.sde" to "gis_mobile.sde"?

0 Kudos
WilliamPollock
New Contributor III

i see you have one named that way already....ok, so how about copying/pasting the entire AGP "Databases" directory?

0 Kudos
WilliamPollock
New Contributor III

and there is a solution to access connections outside your Project described here:

Accessing existing .sde and .ags Connection Files in ArcGIS Pro

cheers.

BenGrod
Occasional Contributor III

Hi William, thank you for the link to the discussion Accessing Existing SDE and AGS Connection Files in ArcGIS Pro, shame on me for not finding that on my own. That pretty much answers my question and defines the workflow for adding multiple SDE or Database connections to an ArcGIS Pro project. The steps are a below and are a combination of what Jake suggested and William pointed out.

  1. Add a Folder Connection
    1. This folder should contain all of your previously created SDE/Database Connections
    2. The connections in this folder will not be immediately accessible to the project
  2. Select a Database Connection from this folder - right click - Add To Project
    1. The Database selected is added under your Databases Folder
    2. The Database and it's contents are now accessible

DB Connection Pro 2.png

JenniferKuntz1
New Contributor II

Another thing you might find useful is to create a project template that has the connections you need. The template will store the connections as well as other items you might want to have as a standard part of your projects. When you create a new project, you can use the template to add the connections and other items to the project.