topic Auto-update SQL views to REST daily with poly and point data in ArcGIS Enterprise Questions

Auto-update SQL views to REST daily with poly and point data

YOAVRAPPAPORT1 — Thu, 15 Sep 2016 15:25:15 GMT

I have SQL Views (tables) and I would like to "join" these to features (both poly and points) in a Geodatabase using a unique Identifier, and then publish to ArcGIS Server. The SQL Views are updated daily. Is there a way to automate this process and update the REST on a regular basis (one a day for example). This is similar to some posts i've seen by Jake Skinner any leads are much appreciated. #arcgisserver‌ #sql view‌ #sql‌ #auto-update‌ #rest service‌

Re: Auto-update SQL views to REST daily with poly and point data

JakeSkinner — Tue, 20 Sep 2016 11:40:57 GMT

Hi Yoav,

As long as your enterprise database is registered as a Data Store with ArcGIS Server, the service will update when view updates.

Re: Auto-update SQL views to REST daily with poly and point data

YOAVRAPPAPORT1 — Tue, 20 Sep 2016 16:48:19 GMT

Thank you jskinner-esristaff‌ for the response. Would this be the method to Join SQL Server Tables with a reference Geodatabase based on a Unique identifier and upadate records in a one or more feature classes? This is currently a manual process. We export a table of attributes from SQL, we join with a reference feature class, create a new feature class of only of joined features, and then publish to REST. I understand that registering the Geodatabase as a Data Store with ArcGIS Server will keep the REST updated when features are changed. I am wondering how to automate the creating of the features based on the change in the SQL table views (although it can be made spatial views we are finding it too slow).