How to update data copied to ArcGIS server

Question

In the scenario where you copy data to the server when publishing services for ArcGIS Server (we are not using an enterprise data environment, can't give ArcGIS server permissions to local drives), what is the best way to provide a daily update to the service, when the data editing can only happen on the local drives?

We have a stand alone table joined to polygon features. The stand alone table is updated daily by multiple people and we want the daily updates to be reflected in a web app. If the data is moved to the server, how can we access it for updates? Can I treat the "data store" as an enterprise environment and connect with a normal database connection on my local ArcCatalog? I am using Enterprise 10.6.

JonathanQuinn · Answer

Unregistering a folder is straightforward, just click the X next to the data store within Manager.

Since your webmap is configured separately from your service, it won't be affected by rebublishing. If the schema of your data changes, (field order, field names, layer order, etc), then you'll need to configure the popups again. As long as just data changes, you'll be fine.

I'll reiterate that this is probably the most difficult way to keep data updated in a service so hopefully the SQL Express approach or policies change to make this easier.

JillSlater3 · Answer

Hi Jonathan,

They are editing an excel file, and they don't want to change this workflow, so I was just planning on making a script that runs each day to somehow get the edits of just the one field I need into a gdb table - haven't figured out this part yet but I'm not as concerned about that step (for now anyway). The permission issue is regarding the location of the excel file, it's a shared folder in our office and I have been told I can not give our ArcGIS server permission to that drive, so was looking for alternatives. What is the process for un-registering a folder with the server?

If I automate republishing the service every night, doesn't it drop the pop up configurations I set up in any web apps? This was one thing I considered but re-configuring anything in the web app stopped me there.

I suggested a web app too as a replacement for updating the excel file, but in the end they really just want to continue with the excel file updates.

Thanks,

Jill

JillSlater3 · Answer

Thanks for the response. The reason for not being able to provide permissions is because it would have to be to a shared folder and the organization that I work in keeps the permissions tightly constrained on shared folders. I have been told it won't be possible but I haven't pushed the issue yet so I was just curious if I had any good alternatives. You have confirmed that it will be difficult to work with the data once it is copied to the server, but I will keep the SQL Server express option as a backup if I am totally blocked with permissions. Thanks.