How to periodically update my SQL Server database with a live layer?

Question

Hello,

My first post in this community.  My apologies if I've posted this in the wrong section...if so, please advise the correct section!

I'm using ArcMap10.6 (do not have Pro).

I'm using a live weather layer from here:

https://services9.arcgis.com/RHVPKKiFTONKtxq3/arcgis/rest/services/Active_Hurricanes_v1/FeatureServer

This live layer updates from time to time and works well.

I'd like to periodically update my own SQL Server database (which can be an enterprise geodatabase if necessary, but if not necessary, that'd be good too).

I have tried using ModelBuilder to make a script that:

1) Deletes the table from my enterprise GDB

2) Adds the (live, updated) table to my enterprise GDB

This works, but when I try to save it as a python script so I can run it on a schedule (once a day), that script does not work.  ESRI tech support says the ability to use a URL in python does not work in ArcMap and I need Pro.

Am I making this too complicated?  Is there a way to simply update the SQL Server database (whether geodatabase or not) table with the live layer ?  (Perhaps once a day)?

Any help appreciated!

thanks!

TimStone · Answer

Still looking for a solution to periodically update my SQL Server database table (which could be anenterprise GDB) with the data from a live layer service!

TimStone · Answer

I have a requirement to populate the data into a SQL table for the users so they can interact with it in their usual way, use their stored procedures, etc.

IvanKozoletov1 · Answer

Then all you need is that Feature Service as it is publicly shared and available to any user. You embed it in your app or as a URL in the attributes. Take a look at that Little Red River app I shared above which was built using ArcGIS Experience Builder. I simply embed the Environment Canada feature service right within my app and live weather available to anyone without ArcMap or ArcGIS Pro. First you add that Feature Service to your web map. Then build your web app on utilizing this web map with feature service.

No need to copy it to your own SQL database and update it daily! I'm thinking you're overcomplicating this.