topic JavaScript API Connect Directly to SQL Database? in ArcGIS JavaScript Maps SDK Questions

JavaScript API Connect Directly to SQL Database?

HenryKo3 — Fri, 05 Aug 2016 08:39:17 GMT

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.

Re: JavaScript API Connect Directly to SQL Database?

Haider_Ali — Fri, 05 Aug 2016 08:49:22 GMT

JavaScript cannot connect directly to database server you need a middle layer (Web Service) between them

Re: JavaScript API Connect Directly to SQL Database?

FC_Basson — Fri, 05 Aug 2016 09:02:20 GMT

You will at least need a server-side page (PHP/ASP) to handle the database connect request. Then you just call the server-side page with an esri.request or AJAX call to retrieve the database query results.

What geometries do you have in the database? You should be able to construct graphic layer geometries from it in some way.

Re: JavaScript API Connect Directly to SQL Database?

RobertScheitlin__GISP — Fri, 05 Aug 2016 12:53:39 GMT

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

Re: JavaScript API Connect Directly to SQL Database?

JeffJacobson — Fri, 05 Aug 2016 16:35:23 GMT

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.

Re: JavaScript API Connect Directly to SQL Database?

HenryKo3 — Wed, 10 Aug 2016 11:02:50 GMT

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.