How can I access my data when arcpy isn't an option?

MWhizzy — Tue, 14 Jun 2022 15:58:54 GMT

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!

topic How can I access my data when arcpy isn't an option? in Developers Questions

How can I access my data when arcpy isn't an option?