Publish Feature Layer with 2 sql server tables join

Question

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 .

VinceAngelo · Answer

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

Ed_ · Answer

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.