Connecting Survey123 form to internally hosted SQL database table

743
3
02-24-2022 03:00 PM
DrewskiFog
New Contributor

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. 

 

Tags (3)
0 Kudos
3 Replies
ZacharySutherby
Esri Regular Contributor

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.h...

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

Thank you,
Zach
RobertAnderson3
Occasional Contributor II

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.

0 Kudos
ClaudiaGIS
New Contributor III

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

Thanks.

0 Kudos