topic Re: ArcGIS Pro Set/Update Data source for all layers in a Map in ArcGIS Pro Questions

ArcGIS Pro Set/Update Data source for all layers in a Map

TauhidulIslam1 — Wed, 18 Sep 2019 02:06:55 GMT

I have to change the data source of all the layers of an ArcGIS Pro project map because of data migration from one sde to another sde. Is there any ArcGIS pro functionality to replace the data source of all the layers using one tool similar to ArcCatalog set data source functionality for .mxd?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

KoryKramer — Tue, 22 Jun 2021 08:17:46 GMT

That isn't in Pro yet. See this issue which we have tagged as an ArcMap equivalency issue.

https://community.esri.com/ideas/12449

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

MichaelVolz — Wed, 18 Sep 2019 15:29:11 GMT

This idea has been around for over 3 years now. Do you know if a solution to this issue is even on the ESRI Road Map for Pro as an equivalency item that the Pro development will be working on?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

TauhidulIslam1 — Fri, 10 Dec 2021 21:52:02 GMT

Kory Kramer‌Michael Volz

I found a solution. One of the ESRI Tech Support article it has the solution. I have tested it and it replaced my data sources. Because of my projects has only one data source for each, it worked for me. Still we need to have the multiple data source replace capability for the situation. ESRI ArcGIS Pro development team should put this a bit of higher priority because it actually is a very important tool. below my code-

import arcpy as py

aprx = py.mp.ArcGISProject(r'project_location')

find_dict = {'connection_info': {'instance': 'sde:sqlserver:server_instance',
                                 'server': 'server_name'}}
replace_dict = {'connection_info': {'instance': 'sde:sqlserver:server_instance',
                                    'server': 'server_name', 'authentication_mode': 'OSA'}}
try:
    aprx.updateConnectionProperties(find_dict, replace_dict)
    py.AddMessage("Data Source Updated")
except NameError:
    py.AddMessage(' does not replaced SQL data Source!!!')
aprx.save()

Hopefully this will help others.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

SeanPhayakapong1 — Thu, 18 Jun 2020 21:35:35 GMT

Hi I tried to replicate this and I could not update my connection property with a different version. I followed the technical guide. Are you able to update versions?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

DavidHoy — Thu, 22 Oct 2020 04:12:37 GMT

Hi Sean Phayakapong,

My reading of the documentation Updating and fixing data sources—ArcGIS Pro | Documentation

tells me you should be able to update the version in the connection dictionary. But you would need to be sure the user accessing the Project (or the Server service account using the published .msd) has access to the version you are trying to use. It is possible that a new version is only accessible to the creator of the version.

Did you get this resolved?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

DavidHoy — Thu, 22 Oct 2020 05:02:03 GMT

More news - at Pro 2.6, a tool is provided to update simple parts of the data source path for all layers in a project.
But there is a bug https://my.esri.com/#/support/bugs/BUG-000134033 (maybe will be fixed at 2.7) that prevents this working for changes to enterprise geodatabase connections (using .sde files) unless the connections use the data owner or sde user - so not generally helpful when using OSA connections.

see this thread in the Ideas forum Need Ability to Replace Data Source for Multiple Layers for up to date info.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

ChrisTaylor2 — Wed, 20 Oct 2021 19:13:17 GMT

Hi DavidHoy,

Do you have any new information on this? I tried going to the thread you referenced, but it's saying it's a Hidden or Archived page now. I've been trying to build out a python script to handle my enterprise geodatabase connections, but between layers, tables and views, with or without joins, versioned or unversioned, I'm finding every time I feel like I'm getting close I come across another case I have to handle. I'd love to put the script to bed and do this all out of the box!

Thank you.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

Anonymous User — Wed, 05 Jan 2022 17:59:13 GMT

@DavidHoy Bug - 0001340033 says it's fixed at 2.8.0 but I'm using 2.8.3 and I am unable to change enterprise geodatabase connections from one version to another version changing from OSA authentication to database authentication. It works for the first feature class in the aprx and then fails out on the rest. So I have to go manually and set the data source on the rest.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

KAKS — Sun, 05 Jun 2022 15:31:14 GMT

Not sure if this was available when the problem was originally encountered, but in Pro 2.9.3, you can right-click on the map in the catalog pane and choose "Update Data Sources". There is a find and replace function you can use to batch update links to all the layers in the map. Hope this helps!

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

Anonymous User — Thu, 24 Nov 2022 20:54:58 GMT

I followed the process outlined here (Update data sources—ArcGIS Pro | Documentation) but when I open my layouts I see the dreaded red exclamation mark and still need to update some of the data sources manually:

Has a solution been found?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

LorindaGilbert — Wed, 29 Mar 2023 20:39:14 GMT

I'm using 3.1 and following these steps and also still getting the dreaded red exclamation mark as well. It is mighty annoying to have to change the source data by going and selecting the feature dataset, then the feature class for some 50 items in a project. EXTREMELY tempted to go back to the source doc in arcmap and change it there and then re-import back into pro. At least in desktop catalog IT WORKS RELIABLY for the change in data source.

I echo, Has a solution been found?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

CordulaGöke — Tue, 18 Jul 2023 13:42:17 GMT

Now in 3.1.1 I can only find it in the menu, not via right click. But it saved my day, to know that I have to search on map level and not for the whole project.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

GeorgeBrown1 — Tue, 27 Feb 2024 12:45:28 GMT

Still have not found the equivalent to AM that will work in AGP 3.2.2. So annoying.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

ChrisWesson — Tue, 21 May 2024 19:22:25 GMT

Open Catalog View from within your project.
From the ribbon that opens at the top, click on Data Sources.
On the new ribbon, click to highlight Workspace.
Now you can enter a new path for each data source, rather than each layer (which is hopefully a far shorter list).
Click on Apply in the ribbon.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

GeorgeBrown1 — Wed, 22 May 2024 10:37:59 GMT

Yes, this does work. Not quite as simple as the method we use within AM, but gets the job done.

Thank you for the reply.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

ChrisWesson — Wed, 22 May 2024 16:56:21 GMT

Glad it helped George.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

DEAF_PROBERT_68 — Thu, 11 Jul 2024 17:14:28 GMT

The link is dead, Kory.

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

JohannaKraus2 — Tue, 30 Jul 2024 00:28:52 GMT

Do you mean from the Contents View?

Re: ArcGIS Pro Set/Update Data source for all layers in a Map

AndrewBarker3 — Wed, 11 Dec 2024 03:16:15 GMT

Not that one, you need to click the View Menu at the top. Then in there choose Catalog View (not Catalog Pane). From there click the Data Sources icon in the ribbon. Then the Workspace icon near the top left in the ribbon.