idea Defining Database Connection Name while creating in ArcGIS Pro Ideas

Defining Database Connection Name while creating

PiotrIwaniuk — Wed, 19 Apr 2023 23:21:55 GMT

I use many database servers, often with different instances and, of course, users. When you create new connection it is named automatically like "connection to -server-.sde". First of all the "connection to" part is totally needless, it's in Database Connection branch of the tree, isn't it. Name of the server is kind of insufficient and always needs editing. I think it would be really nice if the name of the connection could be defined in Add Database Connection dialog or at least automatically created in more useful way, i.e. server instance user.sde (or server database user.sde).

Re: Defining Database Connection Name while creating

AlainCOUTURIER — Wed, 10 Dec 2014 13:02:33 GMT

it would be really nice if the name of the connection could be defined in Add Database Connection dialog or at least automatically created in more useful way, i.e.my preference : server database (user).sde).

Re: Defining Database Connection Name while creating

PaulHoefflerGISS — Fri, 14 Feb 2020 20:47:49 GMT

Setting the name during new database connection creation would be an improvement, and/or to have the default name include the database name, the user, and the database instance - these are all important attributes of the connection. As mentioned by OP, the current default name is fairly useless.

Kory Kramer‌, have you seen an Idea that's more recent than this one and/or specific to Pro?

This is something that's bothered me and been a pain for years - I bet many would appreciate a simple improvement!

Re: Defining Database Connection Name while creating

KoryKramer — Fri, 14 Feb 2020 21:22:59 GMT

Like this? ArcGIS Pro Database Connection Naming based upon Database not Instance

As for naming as part of creating the connection, looking at this in Pro 2.5, as soon as the connection is created, it is highlighted and ready to rename

I realize that it isn't asking you to populate a parameter called "Connection name" as part of the Database Connection dialog, but the item is activated for editing as part of the process of creating the connection.

Anyway, for the actual default name to be different, I think that idea referenced above gets at that.

Hope this helps.

Re: Defining Database Connection Name while creating

PaulHoefflerGISS — Fri, 14 Feb 2020 21:28:08 GMT

Yep, that Idea seems a bit more relevant.

The immediate rename is helpful, but a more useful default name would be excellent.

Thanks for your quick and helpful response!

Set connection name in the create database connection dialog in ArcGIS Pro

Bud — Mon, 05 Jun 2023 17:56:30 GMT

ArcGIS Pro 2.6.8

When creating a database connection via the Catalog pane...

...there doesn't seem to be a way to define the connection name as part of the connection creation process:

The new connection is automatically given the name of the database:

But I want the connection to indicate the name of the database user/schema/owner too. Such as:

PROD OS Authentication.sde
PROD INFRASTR.sde
DEV INFRASTR.sde

I can manually rename the connection afterwards:

But that doesn't seem ideal. I might accidently choose the wrong connection to rename if there are lots of existing connections. Or I might forget to rename it.

It would be bad if the name was wrong or too vague and I accidently connected to the wrong user/schema/owner. Viewing the wrong data is confusing. Editing or modifying/deleting objects is worse.

I think it would be safer and more convenient to name the connection while creating the connection, not after-the-fact. It would work similarly to SQL clients like SQL Developer:

Could that functionality be added? Or am I missing something?

Thanks.

Re: Define database connection name during connection creation, not afterwards

MarceloMarques — Thu, 20 Apr 2023 00:07:46 GMT

Indeed. This is a good idea to be able to provide a name for the connection file in the dialog in ArcGIS Pro.

Re: Defining Database Connection Name while creating

SSWoodward — Thu, 20 Apr 2023 19:57:32 GMT

Thanks @Bud,

I've merged the two ideas. As mentioned by Kory, the focus should be on the new SDE connection file in the catalog right after leaving the database connection dialog, which allows you to rename the file that was just created without having to figure out which one is the one you want.

I know this is not the same as having a default naming convention auto populate, or having the option to name in the dialog, but hopefully it addresses one hurdle identified by your idea.

But that doesn't seem ideal. I might accidently choose the wrong connection to rename if there are lots of existing connections.

Re: Defining Database Connection Name while creating - Status changed to: In Product Plan

SSWoodward — Mon, 05 Jun 2023 17:53:46 GMT

Re: Defining Database Connection Name while creating - Status changed to: Implemented

KoryKramer — Mon, 18 Dec 2023 19:42:18 GMT

This Idea has been implemented in ArcGIS Pro 3.2. Please see the What's New documentation for more new features in Pro 3.2.

The Your Ideas in ArcGIS Pro 3.2 blog and video have been posted to the Esri Community blog. You can take a look at these to see your idea and all others that were implemented in this release of ArcGIS Pro.