I have a web mapping service created on ESRI infrastructure (ArcGIS Server (WFS and WMS) with editable data from SQL Server Spatial. I am trying to switch from ArcGIS to Geoserver. I have published the layers from QGIS using GeoServer Explorer Plugin. But all the SQL Server Spatial tables are getting converted to shapefiles. The plugin allows to connect to PostGIS as in the linked page, but currently all my data is on SQL Server db and heavily related to quite a many attribute tables. Also since the web application has the editing workflow, so publishing static shapefile won't work for me. Is the way to publish views from SQL Server spatial to GeoServer is to publish views from PostGRE linked to SQL server? Are there any fallback for the approach - performance etc.? I am open to experiment with any other open source product if there is any setback for this approach.
1 Answer
First you need to install the SQL Server Plugin and then you follow the normal procedure for displaying database views in GeoServer.
I'm not sure if adding the plugin will enable sharing from QGIS or not, if you have Boundless support I'm sure they can tell you, otherwise feel free to experiment and report back here.
answered Mar 10, 2016 at 17:37
-
I installed the plugin and published the map service - I have not got warning (unlike last time getting converted to shapefile). It published successfully. But my attribute change in SQL Server did not reflect on map service - (checked for caching etc.). I can see the change in QGIS project.– DeepCommented Mar 10, 2016 at 21:25
-
I have posted another question related to geoserver (gis.stackexchange.com/questions/184543/…).– DeepCommented Mar 11, 2016 at 16:10