topic Re: Refresh Database Connection in modelbuilder or python in Python Questions

Refresh Database Connection in modelbuilder or python

SharonZastre — Thu, 26 May 2016 20:10:02 GMT

I have created a model that will select features in an enterprise db and export to a dbf table. This feature class is versioned and when edited, the updated data is not automatically recognized when I run the model. I need to refresh the database (in ArcCatalog, right click db connection > refresh) before the feature class table will update. Is there a tool that I can add to modelbuilder that will refresh the database before the Table Select tool runs so that it is running on updated data. Ultimately this needs to run as a scheduled task so no manual process should be used.

ArcGIS 10.2.2

SQL Server db

Thanks,

Sharon

Re: Refresh Database Connection in modelbuilder or python

WesMiller — Thu, 26 May 2016 20:48:22 GMT

Not sure if this will work. Have a look at RefreshCatalog—Help | ArcGIS for Desktop

Re: Refresh Database Connection in modelbuilder or python

SharonZastre — Fri, 27 May 2016 19:43:36 GMT

Thanks Wes. Adding that code to the exported python script works.

arcpy.refreshcatalog({file path to database connection file})