ArcGIS Pro

Database Connection dialog updates for ArcGIS Pro 3.2

The database connection dialog is the gateway used to make connections in ArcGIS Pro to a variety of database platforms. These include platforms that support database access (you may sometimes hear these referred to as non-gdb) as well as platforms that support both database access + additional advanced capabilities if enabled as an enterprise geodatabase.

Platform support

In the ArcGIS Pro 3.2 release, we’ve made some updates to the database connection dialog. While some enhancements you may notice right away, others are quite subtle. If you blink you may miss them, or begin to think you are going crazy wondering… “Has it always been this way?”  

🌟 To prevent this from happening, let’s run through these changes together. 

  1. Geodatabase Connection Properties tab 
  2. Connection File Name parameter 
  3. Additional Properties section 
  4. Validate button 
Database Connection properties

1. Geodatabase Connection Properties tab

The Geodatabase Connection Properties are now part of a tab on the Database Connection dialog. You’ll find this tab at the top of the Connection Properties dialog box. This is helpful when creating new connections, as you don’t have to access this dialog as a separate step.  

You can access this tab using the following workflows:

Database connection right click context menu
ArcGIS Pro 3.1 vs. ArcGIS Pro 3.2

Platforms that support geodatabases will have this tab enabled once the Validate button is used to check if the database is an enterprise geodatabase. For platforms that only provide database access support and do not support enterprise geodatabases, this tab will not be visible. 

Database

2. Connection File Name parameter

We’ve added a new parameter in the dialog that allows you to name the connection file while typing into the properties. This eliminates having to rename the connection file after it is created.  

Connection File Name parameter

📑Tip – You can select and delete the entire text string in the Connection File Name parameter to restore the default hint. This is useful when copying existing connection files to modify properties such as user name.

Rename

3. Additional Properties

A new section has been added for additional properties that are needed as part of the connection. This could be specifying the port used, or other specific ODBC connection parameters. Once populated, this section will be expanded when accessing the Connection Properties. 

Previously these properties were appended to the server/instance parameter string value separated by commas or semicolons. You’ll notice that if you continue using this syntax as part of the instance/server parameter string, we will parse this and place it in the Additional Properties section. You can see this when accessing the Connection Properties dialog for saved connections. 

📑 Note that the Additional Properties are not validated like the rest of the connection properties. The only way you will receive an error is if an additional property is required to establish a database connection. For example, if a non-standard port needs to be specified.

Additional Properties

4. Validate button

Anyone remember the days of the ‘Test’ button? You may notice a new Validate button near the bottom of the Database Connection dialog. In addition to giving you a warm fuzzy feeling by validating the connection properties, the Validate button also determines if the Geodatabase Connection Properties tab will be enabled. This tab is enabled when you click Validate if your connection properties are pointing to an enterprise geodatabase.  

You’ll see a visual indicator after you click Validate to let you know the status. 

If you don’t want to click Validate, you can still click OK and we will perform the validation as part of the connection file creation. 

Validate states

💎 Extra credit

Everyone likes a little extra credit. We’ve included a few gems to help improve the user experience when working with the Database Connection dialog.

UI element link to help

A question mark appears in the top right section of the Database Connection dialog that links to the Set up a database connection topic in the core help.  This is nice if you need guidance with establishing a database connection for a specific platform.

Link to help

Intellisense for Database Platform

For the Database Platform parameter, you have the ability to simply start typing the name of the database. Using the characters entered and supported databases, the value will automatically pre-populate. Then, use the TAB key to progress to the next parameter!  You can still use the dropdown and click on the desired platform from the picklist, but if you know your platform give this a try. 

Errors in the banner

Instead of receiving errors in a popup, errors are now provided in the banner of the dialog.

Errors in banner

We hope that you find these usability improvements helpful. I am always interested in hearing what features you enjoy or hearing your ideas on the Esri Community Ideas page on future enhancements that our team can consider to help make your work more efficient.


If you want to find out what’s new and improved in this release, watch the ArcGIS Pro 3.2 video the development teams and the product support teams produced to highlight new functionality.

About the author

Product Engineer on the Geodatabase team - specializing in enterprise databases, versioning, and all things geodatabase. A true southerner // Chick-fil-A lover // Beach bum

Connect:

Next Article

Analyze stormwater networks using the ArcGIS Utility Network

Read this article