Skip to main content
Question

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

  • June 2, 2016
  • 2 replies
  • 28 views
S
Forum|alt.badge.img

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • ebygommInfluencer
  • Influencer
  • June 2, 2016

Has the metadata been created correctly?

S
Forum|alt.badge.img

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

Community Stats

32,182
Posts
122,181
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.