I have a database (SQL Server) with a table having lat-long information for sites that keep getting updated daily. I want to create a web application to plot the same on map and add other features to it like buffer creation, shortest distance, heatmap etc.
We have the Standard (editor) license level of ArcGIS Desktop and we have made a geodatabase connection in the same.
How can we proceed to create a web map for the above requirement?
We don't have an ArcGIS Server license.
Is there a way we can publish a service on GeoServer from ArcGIS desktop and then use the same in ArcGIS API for JavaScript considering our data will keep changing on a daily basis?
Best Answer
You can use GeoServer to consume your SQL Server database as a datastore. Then configure GeoServer to provide a WMS &/or WFS, which you can then consume in ArcGIS desktop (or other GIS desktop client, or any web GIS).
For desktop applications there would be no need to any coding.
No, you would make a direct connection to the SQL Server database using the ArcSDE plugin