We have a multiple feature class which are part of a environment ArcSDE that we join with views of sql tables, which are located on different servers than ArcSDE.
How goal is to publish a map service but It doesn't work so far.
We know we could create a new feature class with the feature class and the sql tables view but we try to not duplicate the data and make that a dynamic process so there is less manipulation as possible. We are now trying to do a view combining the view of the feature class and the sql table.
Anyone as any suggestions to make the process less complicated ?