Skip to main content

Why is FME imported data into SQL Server not being found by QGIS?

I've imported some MapInfo format data into SQL Server 2014 using FME.

In SQL Management Studio (SSMS), I can do a query and the spatial results tab shows the various polygons as expected

But if I switch to QGIS and connect to the database, but the data set isn't showing
I have also loaded data using ogr2ogr and those data sets are showing, and can be displayed on a map in both QGIS and SSMS

So why aren't FME loaded data sets showing?

Has the metadata been created correctly?


The solution I found to work was to add an integer IDENTITY column


Reply