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:
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!
I used live weather feed from Environment Canada and embed it within my app:
What are you trying to accomplish by copying the data from the live feed to your SQL database?
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.