topic SQL Data Connection in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-data-connection/m-p/716120#M40556 <HTML><HEAD></HEAD><BODY><P>I have access to an SQL database and I have made a connection to the data tables. When I drag the table into my toc the table pops and I can join the table to a set of features. That is perfect to have real time data.</P><P></P><P>Now, if I leave the table in the map, is the table dynamic back to the SQL database. Meaning if someone edits the table while its in my map will the table change?</P><P></P><P>My thought is I will have to create a new join to update my joined features but I am hoping the data table will have&nbsp; a live connection back to the database. Is this just wishful thinking?</P></BODY></HTML> Mon, 01 May 2017 22:05:04 GMT GISDepartment9 2017-05-01T22:05:04Z SQL Data Connection https://community.esri.com/t5/data-management-questions/sql-data-connection/m-p/716120#M40556 <HTML><HEAD></HEAD><BODY><P>I have access to an SQL database and I have made a connection to the data tables. When I drag the table into my toc the table pops and I can join the table to a set of features. That is perfect to have real time data.</P><P></P><P>Now, if I leave the table in the map, is the table dynamic back to the SQL database. Meaning if someone edits the table while its in my map will the table change?</P><P></P><P>My thought is I will have to create a new join to update my joined features but I am hoping the data table will have&nbsp; a live connection back to the database. Is this just wishful thinking?</P></BODY></HTML> Mon, 01 May 2017 22:05:04 GMT https://community.esri.com/t5/data-management-questions/sql-data-connection/m-p/716120#M40556 GISDepartment9 2017-05-01T22:05:04Z Re: SQL Data Connection https://community.esri.com/t5/data-management-questions/sql-data-connection/m-p/716121#M40557 <HTML><HEAD></HEAD><BODY><P>ArcMap Joins are dynamic meaning when you close and reopen the *.mxd, the relationship is current.&nbsp; Same if you export the ArcMap Join (FC/Table) to a *.lyr file.&nbsp; When you add the *.lyr file to ArcMap, it refreshes the relationship.&nbsp; If you're using ArcMap while the Table is being edited elsewhere, you may need to refresh the database connection to see the latest data.</P></BODY></HTML> Mon, 01 May 2017 22:13:03 GMT https://community.esri.com/t5/data-management-questions/sql-data-connection/m-p/716121#M40557 Robert_LeClair 2017-05-01T22:13:03Z