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?
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.
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.
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!
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!
Retrieving data ...