idea Add SQL Server as an input to Geoevent in ArcGIS GeoEvent Server Ideas

Add SQL Server as an input to Geoevent

SimonMorgan — Tue, 03 Dec 2013 21:05:54 GMT

Allow for a SQL Server table or view to be an input into GeoEvent Processor.
One use of this would be an app we have on the ipads that only collects tabular data. The app collects lat/long and so if we could generate a point from this that would be great!

Re: Add SQL Server as an input to Geoevent

AdamRepsher — Fri, 09 Jun 2017 13:28:30 GMT

...or for Field Enrichment of each real-time event. Fields that are maintained in a separate non-GIS system that is in your agency or business. CSV files are fine for little lists, but access to pull data from SQL or other DB tables is essential for larger datasets maintained by others.

Re: Add SQL Server as an input to Geoevent

RJSunderman — Fri, 09 Jun 2017 15:57:36 GMT

Unfortunately one of the design objectives for GeoEvent Server is to keep the product database agnostic. The map/feature service REST endpoints are the intended interface between GeoEvent inputs, outputs, and processors (such as Field Enricher) and data in an enterprise geodatabase.

Database administrators have successfully created spatial views and registered these views with ArcGIS Server to create the service endpoint GeoEvent requires in order to access the database records.

Cross Reference: https://community.esri.com/message/392202?sr=search&searchId=eda2663c-5cdb-4e62-9178-7ea09a82a61a&searchIndex=0‌

Re: Add SQL Server as an input to Geoevent

AdamRepsher — Fri, 09 Jun 2017 16:01:11 GMT

Thank you for the information, RJ!

--Adam