idea Provide a way to disconnect database connections from ArcGIS Pro in ArcGIS Pro Ideas

Provide a way to disconnect database connections from ArcGIS Pro

ajelenGDi — Thu, 07 Jan 2021 15:05:50 GMT

Please return Disconnect option for enterprise databases to the ArcGIS Pro as was in ArcMap. With one click in Catalog Pane.

Closing the ArcGIS Pro does not disconnect the user from enterprise geodatabase. Removing connection or showing users and locks is not appropriate solution.

This issue had already the enhancement submitted: #ENH-000084097

Re: Provide a way to disconnect database connections from ArcGIS Pro

Frank_Veldhuis_MCGOV — Tue, 06 Jul 2021 18:57:50 GMT

@KoryKramer This is the same issue that prevents us from using Pro to maintain SDE.

Re: Provide a way to disconnect database connections from ArcGIS Pro

Frank_Veldhuis_MCGOV — Tue, 06 Jul 2021 18:59:29 GMT

Here are the buttons that are missing in Pro for enterprise database connections.

Re: Provide a way to disconnect database connections from ArcGIS Pro

Anonymous User — Tue, 31 Aug 2021 16:40:55 GMT

Here is why Disconnect is helpful to me: Let's say I need to make a change to a feature class but it's got an exclusive lock on it. I have an administrative database connection I can use to see who has those locks. In our organization, knowing the user name is not enough; I have to know the machine name. One user name used throughout our organization is for read-only access to the geodatabase. The machine name tells me who I really need to contact and ask to close ArcGIS while I make the change. With related ArcGIS Server services stopped, there are now just two connections to the feature class: the connection using the feature class owner's credentials and the connection from the administrator. In ArcGIS Pro, I can't disconnect the administrator connection to allow the data owner to make their change. But I can do this workflow in ArcGIS Desktop classic. And that's why this feature would be great. I essentially have to disconnect myself as administrator in order to allow myself as object owner to make the change.

[P.S. The reason I assign job-title user name and passwords rather than personal ones is to avoid the situation where someone leaves, the geodatabase objects are named after them, and a new person is now in charge of the data, whose name is not in the object names. Once turnover occurs more than three times, it's tough to know who really maintains an object. The computer's name indicates to IT who has that asset, and I use other software to get that information.]

Re: Provide a way to disconnect database connections from ArcGIS Pro

HCL_GISHCL — Thu, 11 Nov 2021 04:22:35 GMT

I agree and want this idea to be implemented in ArcGIS Pro. Our organization is having restrictions for the DB connection time say 60 minute. User idle for those minutes will be disconnected in database. In a way ArcGIS Pro is not aware of the db connection timeout until the user access the layer, sometime the connection is available but map not showing features is an added problem.

Now i believe the disconnect connection is one key function that will allow the user to disconnect from SDE, Also i want the reconnect to SDE with credentials entered again. This will allow users to connect to SDE from the same project again and again even if the Database is disconnecting them after idle time.

Re: Provide a way to disconnect database connections from ArcGIS Pro

MKF62 — Fri, 21 Jan 2022 16:57:12 GMT

+1. I really need this functionality in order to publish my services. To not have it makes my workflow much more difficult.

Re: Provide a way to disconnect database connections from ArcGIS Pro

fkhan242 — Thu, 07 Apr 2022 11:28:57 GMT

The disconnect option would be a nice enhancement for sde administrators.

Re: Provide a way to disconnect database connections from ArcGIS Pro

Martijnde_Boer — Wed, 06 Jul 2022 08:53:21 GMT

please do implement this option soon

Re: Provide a way to disconnect database connections from ArcGIS Pro

MarceloMarques — Fri, 07 Oct 2022 22:59:30 GMT

I agree the ability to connect and disconnect to an enterprise geodatabase in Pro is absolutely needed.
I posted this idea back in 2019 - Pro Contents Window Connected Geodatabases

Re: Provide a way to disconnect database connections from ArcGIS Pro

BenFerguson — Tue, 18 Oct 2022 19:31:14 GMT

I haven't been using Pro a lot yet but am migrating towards it so I just encountered this today.

I agree this is a must have as very often you need to not have any other connections active to administer SDE functions.

Re: Provide a way to disconnect database connections from ArcGIS Pro

Waan — Wed, 11 Jan 2023 20:05:53 GMT

It's 2023 and my organization is on Pro 3.0, but we still have no simple means of rapidly disconnecting from SDEs. I'm commenting here just to keep this topic active as this would be an extremely useful piece of ArcMap/ArcCatalog functionality to port over for those of us who administer SDEs now with ArcGIS Pro.

Re: Provide a way to disconnect database connections from ArcGIS Pro

MarceloMarques — Wed, 11 Jan 2023 21:10:29 GMT

I agree the ability to connect and disconnect to an enterprise geodatabase in Pro is absolutely needed.
I posted this idea back in 2019 - Pro Contents Window Connected Geodatabases

This issue already has an enhancement submitted: #ENH-000084097

This is in the queue and under consideration, just do not know when it might be implemented yet.

Re: Provide a way to disconnect database connections from ArcGIS Pro

KoryKramer — Wed, 11 Jan 2023 21:22:57 GMT

Thank you for the comment @Waan I took a look and it doesn't appear that you added your kudos to the idea. While comments are important, kudos (the number of votes) that an idea receives is one of the primary pieces of data that we use to determine traction and trends as we monitor idea activity over time.

Please see https://community.esri.com/t5/custom/page/page-id/arcgis-ideas for a high level overview of how ArcGIS Ideas works. For more details, see

Thank you for your participation in the community and for helping us prioritize future development efforts for ArcGIS Pro.

Re: Provide a way to disconnect database connections from ArcGIS Pro

AryamanB_EGS — Tue, 13 Jun 2023 12:09:18 GMT

Hi ESRI,
Any updates on when ENH-000084097 will be implemented ? This is a desired functionality for most ArcGIS Pro users especially with ArcGIS Desktop being phased away.

Re: Provide a way to disconnect database connections from ArcGIS Pro

MarceloMarques — Tue, 13 Jun 2023 16:40:38 GMT

#ENH-000084097 - it is still in the queue but there is no estimate when this will be implemented yet.

I agree the ability to connect and disconnect to an enterprise geodatabase in Pro is absolutely needed.
I posted this idea back in 2019 - Pro Contents Window Connected Geodatabases

Re: Provide a way to disconnect database connections from ArcGIS Pro

JamieHawk — Tue, 19 Sep 2023 22:38:55 GMT

This is one of the primary reasons we cannot fully migrate from ArcMap/ArcCatalog. Please prioritize implementing the sde connect/disconnect functionality in ArcGIS Pro. It is absolutely critical for database administration.

Re: Provide a way to disconnect database connections from ArcGIS Pro

AmberWittner — Tue, 12 Dec 2023 21:16:45 GMT

All Bureaus within the Department of Interior will have ArcGIS Desktop REMOVED from all machines on February 1, 2024 - less than 2 months from now. The data management team behind The National Map is migrating to a SOA(Services based architecture) for internal data management. We use PostgreSQL and have an On Prem Portal deployment in support of Branch Versioning.

As a Portal Admin and one tasked with training our team how to publish a BV from a connection file, this functionality is essential. We have a massive amount of corporate enterprise databases, replications of these databases, services for internal use and data pipelines to the cloud in support of National Map Service Delivery.

Please. Implement. this. Now. @JeremyKirkendall FYI This has been requested for years and an enhancement logged...#ENH-000084097 but no intel on which version of Pro will have this essential functionality.

Re: Provide a way to disconnect database connections from ArcGIS Pro

Frank_Veldhuis_MCGOV — Tue, 12 Dec 2023 21:40:55 GMT

I was told during UC that it can't be done due to indexing that runs in the background. I'd rather turn off indexing and have the ability to disconnect from a SDE database. Just my opinion.

C'mon ESRI enable the disconnect button!!!

Re: Provide a way to disconnect database connections from ArcGIS Pro

Martijnde_Boer — Wed, 03 Jan 2024 15:24:34 GMT

Please Esri fix soon! we are allready looking at QGIS instead..

Re: Provide a way to disconnect database connections from ArcGIS Pro

AllanBenvin_yyc — Mon, 13 May 2024 14:08:12 GMT

This is basic functionality that should be included. It is very difficult to maintain an enterprise geodatabase without the ability to disconnect the current session. ArcGIS Pro likes to lock everything and providing no way to clear locks other than killing sessions as the SDE user is impractical.