I have a non-spatial table in an external system. The table has X & Y columns.
The table will be synced to an Oracle 18c/10.7.1 geodatabase table or FC (via the ArcGIS REST API). There will be roughly 200 inserts or updates from the external system per day.
I would like to serve up the synced geodatabase object (table or FC) to a Portal web map as a spatial point layer.
Is it possible to convert the X & Y columns to a SHAPE column -- using a method that would perform well in Portal?
A feature class with an empty SDE.ST_GEOMETRY column. When rows are inserted or updated, a custom trigger would populate the value in the shape column (via st_point).
An XY event layer.
A registered spatial view that generates a calculated SDE.ST_GEOMETRY column (via the st_point function).
A registered spatial view that generates a calculated SDO_GEOMETRY column.