topic Connecting Survey123 form to internally hosted SQL database table in ArcGIS Survey123 Questions

Connecting Survey123 form to internally hosted SQL database table

DrewskiFog — Thu, 24 Feb 2022 23:00:18 GMT

Is it possible to use an internally hosted SQL database (PostgreSQL or MS SQL) table as the source for the Survey123 form? Rather than a feature service that lives in AGO?

We'd like to have internal access to the table rather than a feature service. So basically each time a user submits records to the Survey123 form, we could preview the data/manipulate in our desktop software from our local database.

Re: Connecting Survey123 form to internally hosted SQL database table

ZacharySutherby — Fri, 25 Feb 2022 01:18:40 GMT

Hello @DrewskiFog,

It's not possible to have Survey123 point directly to a SQL database table, Survey123 requires the use of an ArcGIS feature service.

What you can do to consume the data in your SQL database in Survey123 is enable an Enterprise Geodatabase in your SQL database, register that Enterprise Geodatabase with an ArcGIS Enterprise organization and publish the data as a feature service, then point your survey to that feature service.

Please see these links for reference: https://pro.arcgis.com/en/pro-app/2.8/tool-reference/data-management/enable-enterprise-geodatabase.htm

https://doc.arcgis.com/en/survey123/desktop/create-surveys/survey123withexistingfeatureservices.htm

Re: Connecting Survey123 form to internally hosted SQL database table

RobertAnderson3 — Fri, 25 Feb 2022 18:30:14 GMT

Are you looking at having the submitted data in SQL, or have the Survey123 form pull from existing SQL data for something like a choice list?

If it's getting submitted data in SQL I've been working with Microsoft Power Automate webhooks to push the data into a SQL table.

If using existing tables for the survey, then I have that question as well, I'd love to use this instead of creating CSVs for choice lists.

Re: Connecting Survey123 form to internally hosted SQL database table

ClaudiaGIS — Mon, 14 Mar 2022 19:32:35 GMT

Hello, did you find a way to have the Survey123 form pull from existing SQL data for something like a choice list?

Thanks.