Publish editable service from combined non-spatial and spatial datasource

[GlibaRoland]

Hy! We'd like to solve a follow issue. There must be two main data store for perfect performance. One of them contains only spatial data as a one column data and the otherone has the attributes as a table without any spatial information. It is needed to be published as a service to Portal for ArcGIS and must be editable by the clients. The main question is that is is possible in any way or we shouldn't try that? We would be very thankful for any help.

https://community.esri.com/groups/geodatabase?sr=search&searchId=ef40dd5e-3451-4d6d-9dd2-b1b39a0c356...‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=02bb7c64-8d4a-4b6a-96e1-f...‌

[JonathanQuinn]

So there are two approaches to publishing a feature service, neither of which seems like you'll be able to accomplish in your current architecture.  If you were going the route of a hosted feature service in Portal, the data would be copied from your original source location into the ArcGIS Data Store registered to the hosting server.  It then wouldn't be referenced from the original location, (and this is assuming that there wouldn't be a problem copying the data from two separate tables).  Another approach is to publish a traditional map service with feature access, but that requires that the data reside in the same workspace.

[GlibaRoland]

First, thank you for the help. Both of the datasource are in SDE gdb (MSSQL). It is necessery by the clients cause of their IT infastructure. Any advice? Thank you!

[JonathanQuinn]

Unfortunately, the first requirement for a feature service is that the data is in the same workspace.  You may need to rethink the architecture of the databases if you want feature access.