I am very new to Python and very excited. Moving from VBA. The first mini project is to update my ArcGIS Server files. I've heard you can do this with Python Scripting. It would be great if I could automate this process.
Here is what I need to do:
Open up new project
Import a table from an SQL DB called "GISWEB.VW_MCYWEB" using an ODBC connection called "AR"
Convert this file to a shapefile called MCYWEB.shp
Then open up an MXD and Publish that MXD to the server. The layers in the map are linked to the shapefile created earlier and already have symbology.
If possible have this run once a week.
So is python this powerful?