I wrote a scheduled script that mostly uses arcpy for data access. We have our data in an on-site enterprise geodatabase and have an on-site ArcGIS Server with Portal.
Now we need to move the script to a Linux environment, so arcpy won't be available. I think I have 3 options:
- Direct database access. Using native SQL to insert/update/delete records. I know this isn't recommended, but what would it take to do this 100% safely? From what I can tell, it will only require correctly handling the OJBECTID, which means using and updating the correct i tables. Is there anything I'm missing?
- Using ArcGIS API for Python. This is just a Python package that wraps the REST services made available by ArcGIS Server, correct?
- Getting arcpy to work on Linux. Is there any reliable way to get arcpy running on Linux requiring ArcGIS Server for Linux? I'm trying to avoid needing a new server license.
Thanks in advance for any advice!