I have an external/separate enterprise database i.e. oracle and I want to join the table with an existing layer inside ArcGIS Data Store 10.6 just by attributes relationship using ArcGIS Pro and I want to publish this joined table as a service so that I can access it via ArcGIS Server REST service call. When the record value in the table is changed, the changes should be reflected when calling the service as well.
Is this possible to achieve with no limitation ?
Understand that this can be achieved in earlier ArcGIS version when without ArcGIS Data Store.