We have two tables:
[Server1].[Instance1].[Database1].[dbo].[Districts]-- a versioned polygon feature class with only two fields: a shape and a foreign key
[Server1].[Instance2].[Database2].[dbo].[vwDistricts]-- a rather straightforward view on a non-spatial table containing the other end of the foreign key and useful information about the districts.
I have created a map service--on a standalone ArcGIS Server instance running v 10.6.1--that contains a join between these two tables. The view is fed by a separate table in
[Database2] that holds the authoritative values for these data so it is necessary to maintain this join to keep the data fresh. The problem is that the resulting map service publishes fully qualified field names (
Database2.dbo.vwDistricts.Name), and I'd like very much to avoid revealing specific database names & table names to the world.
I've tried publishing from ArcMap and from ArcGIS Pro (v 2.6.1). In ArcGIS Pro, I unchecked the Join Tool's "Maintain Fully Qualified Field Names" setting; but that gives me no love, not even intermittently. Is there a reliable way (either in ArcMap or Pro or elsewise) to get that map service published with unqualified names?