Export data from ArcGIS Enterprise relational datastore

Question

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 datastore

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

dougbrowning · Answer

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

GeoJosh · Answer

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