topic Re: ETL for data with attachments in ArcGIS Enterprise Questions

ETL for data with attachments

Anonymous User — Wed, 19 Jul 2023 19:12:33 GMT

Re: ETL for data with attachments

A_Wyn_Jones — Thu, 20 Apr 2023 09:10:42 GMT

The append geoprocessing tool can be used from ArcGIS Pro (along with several others) to transfer attachments from one feature class to another - here's the documentation:https://pro.arcgis.com/en/pro-app/latest/tool-reference/environment-settings/maintain-attachments.htm

Essentially, the target feature class needs the "enable attachments" tool run on it before it's able to accept attachments.

This could then be run by a python script via Task scheduler to automate this and mitigate high resource usage in the middle of the night.

Great blog on this automation here:

https://www.esri.com/arcgis-blog/products/arcgis-pro/analytics/schedule-a-python-script-or-model-to-run-at-a-prescribed-time-2019-update/

Re: ETL for data with attachments

Scott_Tansley — Thu, 04 May 2023 20:03:59 GMT

Have you considered Data Interoperability or FME? Neither are an area of specialty for me, but most of my clients use FME for activities like this.

Re: ETL for data with attachments

AnibalMmartinez — Thu, 11 May 2023 18:09:30 GMT

Tengo una situación similar a resolver, y el mismo planteo económico, no nos darán mas plata para una nueva herramienta, nuestra Geodatabase esta montada sobre Microsoft SQL Server, el ETL de este motor de BD propio, ¿alguien sabe si sirve para mover Feature Class y TableClass como el FME?

Saludos,

Anibal