Connecting Survey123 Results to Database in ArcPro

Question

Hi everyone!

I'm relatively new to Esri products but I just made my first survey in Survey123 and would like to have it where the results are automatically uploaded to a pre-existing database that exists in ArcPro. I know that Survey123 is compatible with ArcEnterprise and ArcOnline but is it wishful thinking to try and find a way to continuously upload those results from Survey123 into ArcPro? I know you can download your Survey123 results as a shapefile or geodatabase but is it possible to skip that step and just have the results upload straight to the database in ArcPro?

dougbrowning · Answer

Just open the service in Pro and look at it directly.  No need to download or copy anything.  You should see it in Catalog under Portal.

CodyPatterson · Answer

Hey @RachelWhittington

There are a few possible ways to do this, if you have access to an Enterprise environment, you can create a project with a database layer attached, and then share it up to the Portal in reference editable mode, and then connect the survey to the uploaded feature layer. This will directly put information from the survey into the DB.

Next, if this is Online, you can have a Python script perform a sync, taking the information from a layer that's attached to the survey, and inserting/updating to a database or FGDB.

Finally, you can also do this through a Python Notebook, and have it to run on a 5 minute schedule. A regular Python script may be more useful as it can update every minute.

I believe there are a few other ways, but I can look into that as well.

Cody