JavaScript API Connect Directly to SQL Database?

Question

This might sound weird but due to cost and architectural constraints, I need to explore whether it is possible for an ArcGIS API for JavaScript web app to connect directly to a Microsoft SQL database to display (and render) geometries on the web app? In another words, no ArcGIS for Server is involved here - just JavaScript to SQL database. I don't believe this can be achieved.

HenryKo3 · Answer

This approach might work for us. We could retrieve the geometries and attributes and construct graphic layers from them. We have points and polygons to display. I think the polygons could be multi-part polygons.

JeffJacobson · Answer

If your web server is IIS, I would create a REST endpoint using ASP.NET Web API. The SQL query would occur here, on the web server, and return the query result as JSON. Your client-side code (JavaScript) would call this REST endpoint and convert the results into features.

The ArcGIS API for JavaScript is not your only option for creating an interactive map. Leaflet is another alternative you might want to consider. If you go with Leaflet, you'll want your server-side code to return the data from SQL as GeoJSON​.

rscheitlin · Answer

You will want to fully read and understand if you are compliant with esri Terms of Use:

Terms of Use | ArcGIS for Developers