topic Publish Feature Layer with 2 sql server tables join in ArcGIS Pro Questions

Publish Feature Layer with 2 sql server tables join

abhishek_choudhary — Wed, 01 May 2024 18:25:23 GMT

Hi,

I attempted to create a feature layer by joining two tables, one containing spatial data, and the other with additional attributes. However, I encountered an issue when trying to publish it. The error message indicated that the join operation was being performed in local memory, preventing successful publication.

I want to utilitize this feature layer with the geoevent server where the feature data will be updated in real time.So does the changes should be reflected in the sql database.

Can someone please suggest a better approach how can we publish the feature layer .

Re: Publish Feature Layer with 2 sql server tables join

Ed_ — Wed, 01 May 2024 18:34:35 GMT

That's because the join is temporary.

Right click on the spatial data that contains the join data and then click on data and then click on Export and create a new feature class (spatial data). Now publish the newly created spatial data which now has the joined data permanently.

Re: Publish Feature Layer with 2 sql server tables join

VinceAngelo — Wed, 01 May 2024 20:24:16 GMT

The other option is to use a true JOIN clause in a VIEW, but doing so is tricky, since you need to preserve a unique rowid column.

- V