topic Publish a map service using a feature class(SDE) join to sql tables views located on a different server in Developers Questions https://community.esri.com/t5/developers-questions/publish-a-map-service-using-a-feature-class-sde/m-p/139620#M860 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>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.</P><P></P><P>How goal is to publish a map service but It doesn't work so far.</P><P></P><P>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.</P><P></P><P>Anyone as any suggestions to make the process less complicated ?</P><P></P><P>thank you</P><P>Em</P></BODY></HTML> Mon, 14 Sep 2015 15:53:10 GMT ÉmilieLamontagne 2015-09-14T15:53:10Z Publish a map service using a feature class(SDE) join to sql tables views located on a different server https://community.esri.com/t5/developers-questions/publish-a-map-service-using-a-feature-class-sde/m-p/139620#M860 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>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.</P><P></P><P>How goal is to publish a map service but It doesn't work so far.</P><P></P><P>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.</P><P></P><P>Anyone as any suggestions to make the process less complicated ?</P><P></P><P>thank you</P><P>Em</P></BODY></HTML> Mon, 14 Sep 2015 15:53:10 GMT https://community.esri.com/t5/developers-questions/publish-a-map-service-using-a-feature-class-sde/m-p/139620#M860 ÉmilieLamontagne 2015-09-14T15:53:10Z