topic Update SQL Server table from Survey123 in ArcGIS Survey123 Questions

Update SQL Server table from Survey123

HarmondSantos — Mon, 11 May 2020 23:20:01 GMT

Hi team, I'm pretty new working with SQL server databases. What's the easiest way to link my Survey123 results to an SQL Server database table? Is there an existing workflow for that? Basically, whenever a survey has been submitted, the SQL server table will be updated as well. Thank you in advance!

Re: Update SQL Server table from Survey123

ZhifangWang — Mon, 27 Jul 2020 11:37:54 GMT

Hi Harmond Santos‌,

Generally speaking, Survey123 submits data to a feature service. In your case, you may want to first publish your SQL Server database table as a feature service in ArcGIS Pro, and then create a survey from that feature service. Then data collected with this survey will be submitted to the underlying database table directly.

For how to create a survey from an existing feature service, Use Survey123 with existing feature services—Survey123 for ArcGIS | Documentation would help.

Re: Update SQL Server table from Survey123

DougBrowning — Mon, 27 Jul 2020 19:27:38 GMT

Check out this script if you want to download and sync on a regular basis between a hosted feature service and SQL.

https://community.esri.com/groups/survey123/blog/2016/12/14/migrating-data-from-the-survey-feature-service-to-an-enterprise-geodatabase