ArcGIS Data Store and RDBMS?

14749
19
Jump to solution
03-13-2017 05:28 AM
MartinAmeskamp
Occasional Contributor II

Hi,

I'm getting a bit lost in the new ArcGIS Enterprise terminology - can someone point me to some document that explains what the ArcGIS Data Store and specifically the relational data store have to do with the good old Enterprise Geodatabase based on RDBMS products such as Oracle, MS SQL Serverv or Postgres? Is this just a new name for the same thing, or is a relational data store truly a new relational database implementation?

From the current documentation I get the rough idea the a "managed database" is the old (ArcSDE) Enterprise Geodatabase, so this would indeed indicate that the relational data store is something new. If so, what?

Thanks, Martin

19 Replies
CodyBarrett1
New Contributor II

Hi Derek,

Can the enterprise geodatabase(oracle) release( in our case 10.5.1) be higher than the ArcGIS Server release( in our case 10.4.1)?

0 Kudos
DerekLaw
Esri Esteemed Contributor

Hi Cody,

Apologies for the late reply, I was working at a conference last week.

> Can the enterprise geodatabase(oracle) release( in our case 10.5.1) be higher than the ArcGIS Server release( in our case 10.4.1)?

If you mean to use the enterprise geodatabase as a valid data source to power web services - I think this should be ok. Although any new functionality available in the higher release geodatabase would NOT be accessible within the web service. I'm not even sure if there were any major functional changes.

While I have not personally tested this configuration, I am not aware of any issues that would arise from this deployment. Although the best and recommended option would be to have both your enterprise geodatabase and ArcGIS Server site at the same release.

Hope this helps,

AndiDerhemi1
New Contributor II

How to access and/or query ArcGIS DataStore tables/data from third party Reporting Software (CrystalReports, etc.)?

Hello,

I would like to know, if is there a way to access and/or query ArcGIS DataStore tables/data from third party Reporting Software like CrystalReports or other business intelligence software?

We are using ArcGIS DataStore as the managed database for ArcGIS Server, and the server is configured as a hosting server for Portal for ArcGIS. The DataStore has been configured as tilecache, relational and spatiotemporal database!

We can add registered databases (SQL Server) to ArcGIS Server, but the data collected through Survey123 are saved in the DataStore, and we need to access those data with CrystalReports.

Please send any info on how to achieve this.

Thank you!
Andi

0 Kudos
George_Thompson
Esri Frequent Contributor

I would not suggest (or recommended) to access/query the DataStore tables as it could cause issue or make the DataStore unusable. As Derek Law‌ mentioned above it is managed by ArcGIS Enterprise and not an "open" DB to view.

--- George T.
AndiDerhemi1
New Contributor II

Hi George,

Thank you for your reply.

Yes, that may be the case, but when you use Survey123, the data (form collected data) can be stored only in an ArcGIS DataStore. And, I need to access such collected data through a third party reporting software in real time.

How can I achieve this by using this combination ArcGIS Server + Portal for ArcGIS + ArcGIS DataStore + Survey123 + Crystal Reports?

Best regards,

Andi

0 Kudos
George_Thompson
Esri Frequent Contributor

Based on what I understand, I would say it is not possible at this time. You could create an ArcGIS Ideas‌ to have this type of functionality added.

#survey123 portal#datastore‌  https://community.esri.com/groups/survey123?sr=search&searchId=3c890be2-3355-498d-a86c-6621267f62af&...https://community.esri.com/community/gis/managing-data?sr=search&searchId=9ac4264e-2ccb-4df7-a0ac-cb...

--- George T.
0 Kudos
AndiDerhemi1
New Contributor II

Hi George,

Thank you for your suggestion.

Best regards,

Andi

0 Kudos
PaulBrandt
New Contributor III

I don't know Crystal Reports very well, and not being familiar with your requirements these ideas may not be viable, but you might look to see if there is a way to access the REST endpoint of the service that Survey123 is using in Crystal Reports. If that is not an option (I don't think it is based on my 1 minute search on Google), you could look into another middle ware such as FME (by Safe Software www.safe.com) or something like it to read the data from the service, and transform it in near real time or on a schedule to sync it to an external database. Thinking about it further, depending on your requirements, something similar might be possible with a Geoprocessing script/service that would run on a schedule, or ad-hoc before the report is generated.

0 Kudos
SimonJackson
Occasional Contributor III

This video might also help explain a bit more info about the purpose of the ArcGIS Data Store (relational)

https://youtu.be/s1X2l-9LbIM?t=634

BillFox
MVP Frequent Contributor

Simon,

Thank you for the lovely presentation!

-Bill

0 Kudos