Hi all,

I have to create a workflow where we are retrieving public data, either through download or URL and running it through FME for data processing and publishing to our SDE.

The idea is then that this process should be fully automated by adding the FME script as a spatial ETL tool in ArcGIS Pro, and then publishing it as a web tool to an ArcGIS server with DI extension for server.

This way we can just schedule that tool to run on a monthly basis, where new data is downloaded and being published to our SDE without us having to do anything :-)

My problem is this: How do I handle the data and data connections in my script? Can I set up some parameters ensuring that even though my script is now running as a web tool on a different server, it still has a data connection to my SDE? And can I ensure that access to my "downloaded" or URL data is still intact through the web tool on the server, for instance using some kind of scratch folder?

Should I set a FME_TEMP Environment variable on the server where the web tool is?

Some of this is probably more relevant to ask on the Esri community, but if there is something I can do already at the workbench stage, that would be very helpful.

thanks :-)