Add SQL Server as an input to Geoevent

1224
3
12-03-2013 01:05 PM
Status: Open
SimonMorgan
Regular Contributor

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!

3 Comments
AdamRepsher

...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.

RJSunderman

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&se...

AdamRepsher

Thank you for the information, RJ!

--Adam