topic Re: Export data from ArcGIS Enterprise relational datastore in ArcGIS Survey123 Questions

Export data from ArcGIS Enterprise relational datastore

deleted-user--2hDb5YTmQS1 — Wed, 09 Oct 2019 12:55:56 GMT

Hello,

I know that this question came up before, several times.

https://community.esri.com/thread/160435#comment-772773

https://community.esri.com/message/847741-re-how-to-access-andor-query-arcgis-datastore-tablesdata-from-third-party-reporting-software-crystalreports-etc?commentID=847741#comment-847741?q=access%20datastore

I have a customer that wants to, for a proof on concept, export his Survey123 data from the relational datastore to use it in a reporting tool. The survey is huge and complex, so setting up a feature service with an enterprise geodatabase is no option. Neither is using the REST API an option due to restricted knowhow and resources.

I tried to access the datastore via pgadmin as described by Elijah Robison (first blog post link): "I can access Portal's PostGRESql db if I create an SSH connection with Putty, tunneling port 7654 between the host and localhost, then creating a connection with pgAdmin III (or whatever client you want) to a database named "gwdb" with my Portal admin username and password."

So, at least it seems that there are guys out there that have managed to directly access the datastore. If so, can anyone help how to do this?

Or, in the direction of ESRI: Are there any plans to provide an easy to use export functionality for datastore?

Any help is highly appreciated, thank you very much.

Best regards,

Jürgen

Re: Export data from ArcGIS Enterprise relational datastore

GeoJosh — Wed, 09 Oct 2019 14:00:25 GMT

Jürgen,

Since the service is hosted in Data Store, can the user just export the data from the Portal home application? (Item Details > Export).

I understand that the user does not want to use the REST API, but that may be the easiest solution if they are looking to do this programmatically. (/createReplica)

-Josh

Re: Export data from ArcGIS Enterprise relational datastore

DougBrowning — Wed, 09 Oct 2019 14:02:15 GMT

I export to a GDB. All the relationships and such come with. I have 9 forms all with over 100 lines and it works fine. I can then just copy and paste into SQL SDE.

Also check our James script for syncing. https://community.esri.com/groups/survey123/blog/2016/12/14/migrating-data-from-the-survey-feature-service-to-an-enterprise-geodatabase