I am working with ArcGIS Pro 2.8.3 and ArcGIS Online.
We have an SQL server that contains a database with contact information that I'm interested in using as a data source for an online map. I have been able to gain permission to access the specific database with said contact information via an OLE DB connection, but I do not have any other permissions or direct access to the server. I can't build anything on the server and I publish maps and apps through ArcGIS Online. Network security will not allow computers outside the network to establish a connection to the database so any map hosted off site will not be allowed direct access.
Our partners are able to update their own database contact information through a web interface with the server.
My goal is to find an efficient way to integrate the database into a workflow to update an online map with less human involvement. I currently have a test map built in ArcGIS Pro that contains a polygon layer joined to the database. This layer is then exported as a new feature layer to embed the data to remove the local file connections. I then customized popups with telephone links, website links, google map address links, etc, and it works nicely, but I had to build it as a completely separate layer since ArcGIS Pro wont publish a map online with local file connections.
I'm trying to get some input to determine if this is the most efficient work flow. It seems like there should be a better way of doing this that doesn't require so much work to publish updates. I'm mostly self taught so I feel that I'm likely unaware of many useful methods. Please don't hesitate to suggest ideas or ask questions. You won't offend. Thanks!