Is it possible to join spatial features to a MS SQL view table?

[EricHeinrichs]

I am wanting to run a join from my spatial data (parcels) to a SQL view table (attributes for the parcels). Is this something that's doable, or would I have to try and figure something else out?

Thanks!

[RyanUthoff]

Yes it is doable as long as you have a matching attribute to link the two data sources to each other. It is possible once you get the SQL table in the GIS, you might have to export it to a .dbf or geodatabase table for the join to work correctly, but it is possible.

[EricHeinrichs]

It looks like I must have been doing something wrong before, because I couldn't get it working at all last week. But, when I tried it this morning, and everything worked as it should! I didn't even have to export it.

Thanks!

[RyanUthoff]

Glad it worked! Sometimes if I do an attribute join and don't export the SQL table first, it will match the records, but all of the matched records will be null values for the attributes. But if I do a simple export, it works perfectly!

[EricHeinrichs]

That's what was happening to me, as well. I want to maintain a "live" connection, so that every time something changes in the SQL database, my parcel attributes are instantly updated. I was able to run the join and publish the parcels, and it maintains all the attributes. Not sure why it worked this time, but I'm glad that it did!