I wanted to check if anyone has had experience running any geoprocessing tool on-demand using Oracle and ArcGIS Pro. So my scenario is this (this is the simplified and most relevant version):
I already built the geoprocessing tool needed to process the spatial data using a model and can run it manually and it behaves as expected. But my question is, is there a way for the tool to automatically detect new records in the Oracle table in step 3 so that it can run by itself without my direct intervention?
I'm open to ideas and would very much appreciate your input!
Look into database 'triggers'. What's the geoprocessing tool doing? If the GP tool functionality can be done using Oracle spatial methods you could just create a database view which would be relatively simpler.
The tool calculates different types of district areas in which an address falls, and the 5 nearest service locations for said address. In addition to that, it also performs a join to capture other attributes from a different table before storing the result back into Oracle.