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!
... View more