topic Updating the data source of a query layer with ArcPy in Python Questions https://community.esri.com/t5/python-questions/updating-the-data-source-of-a-query-layer-with/m-p/294388#M22784 <HTML><HEAD></HEAD><BODY><P>I am using ArcPy to update data sources of all layers across several MXDs using (1) findAndReplaceWorkspacePaths() and (2) replaceDataSource().&nbsp;</P><P></P><P>The workspace path, and dataset name,&nbsp;seem to update fine when I run my script, but the database connection (right-click on layer -&gt; Properties -&gt; Change Query -&gt; Connections... -&gt; Edit... -&gt; Database) does not, and the layer can not find the data to display because it is using the old database connection and not using the newly directed workspace path.</P><P></P><P>So, I change the workspace path, not see any error, and have the layer metadata (workspace and dataset name = data source) reflect the updates in layer properties, but&nbsp;the database connection isn't actually updating? Is there a property or method that I am missing? Can I do something with the system tables?</P><P></P><P>I should also note that I can indeed update the database connection and have the data show up in ArcMap, but I have go to each query layer properties <SPAN>(right-click on layer -&gt; Properties -&gt; Change Query -&gt; Connections... -&gt; Edit... -&gt; Database)&nbsp;</SPAN>and update it manually (like outlined here <A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/10.6/map/working-with-layers/modifying-a-query-layer.htm" title="https://desktop.arcgis.com/en/arcmap/10.6/map/working-with-layers/modifying-a-query-layer.htm">Modifying a query layer—Help | ArcGIS Desktop</A>&nbsp;), but I need to do this programmatically.</P><P></P><P>Any insight or recommendations?</P></BODY></HTML> Tue, 21 Jan 2020 16:26:52 GMT AlexanderSt__John 2020-01-21T16:26:52Z Updating the data source of a query layer with ArcPy https://community.esri.com/t5/python-questions/updating-the-data-source-of-a-query-layer-with/m-p/294388#M22784 <HTML><HEAD></HEAD><BODY><P>I am using ArcPy to update data sources of all layers across several MXDs using (1) findAndReplaceWorkspacePaths() and (2) replaceDataSource().&nbsp;</P><P></P><P>The workspace path, and dataset name,&nbsp;seem to update fine when I run my script, but the database connection (right-click on layer -&gt; Properties -&gt; Change Query -&gt; Connections... -&gt; Edit... -&gt; Database) does not, and the layer can not find the data to display because it is using the old database connection and not using the newly directed workspace path.</P><P></P><P>So, I change the workspace path, not see any error, and have the layer metadata (workspace and dataset name = data source) reflect the updates in layer properties, but&nbsp;the database connection isn't actually updating? Is there a property or method that I am missing? Can I do something with the system tables?</P><P></P><P>I should also note that I can indeed update the database connection and have the data show up in ArcMap, but I have go to each query layer properties <SPAN>(right-click on layer -&gt; Properties -&gt; Change Query -&gt; Connections... -&gt; Edit... -&gt; Database)&nbsp;</SPAN>and update it manually (like outlined here <A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/10.6/map/working-with-layers/modifying-a-query-layer.htm" title="https://desktop.arcgis.com/en/arcmap/10.6/map/working-with-layers/modifying-a-query-layer.htm">Modifying a query layer—Help | ArcGIS Desktop</A>&nbsp;), but I need to do this programmatically.</P><P></P><P>Any insight or recommendations?</P></BODY></HTML> Tue, 21 Jan 2020 16:26:52 GMT https://community.esri.com/t5/python-questions/updating-the-data-source-of-a-query-layer-with/m-p/294388#M22784 AlexanderSt__John 2020-01-21T16:26:52Z Re: Updating the data source of a query layer with ArcPy https://community.esri.com/t5/python-questions/updating-the-data-source-of-a-query-layer-with/m-p/1301526#M68008 <P>Looking for the same thing here</P> Wed, 21 Jun 2023 14:40:29 GMT https://community.esri.com/t5/python-questions/updating-the-data-source-of-a-query-layer-with/m-p/1301526#M68008 RoyJackson_AlertMedia 2023-06-21T14:40:29Z