Skip to main content
Solved

Microsoft SQL Server Spatial (JDBC) FME Reader Cannot see Views folder

  • October 23, 2025
  • 1 reply
  • 22 views
fblades
Contributor
Forum|alt.badge.img+1

I am trying to read in non-spatial data from Microsoft SQL Server. I need to read in three Tables and three derived Views. 

I have set up a connection using the Microsoft SQL Server Spatial (JDBC) format, and I have the connection to the main folder in the database working fine. In the Parameters > Constraints, I am only offered the option of ‘Tables’, and this does allow me to read in the three tables in the database perfectly. However I cannot find a way to access the Views which are in a different folder in SQL. 

Is Reader limited to just reading Tables? The FME documentation says “The Microsoft SQL Server Spatial (JDBC) reader and writer modules provide FME with access to spatial and attribute data held in Microsoft SQL Server database tables.” - with ‘tables'; being specifically mentioned, rather than all folders within a database.

Is there another way of reading in Views? Or do I need to go back to the database creator and get him to do something else.

Best answer by s.jager

Don’t use the JDBC connection, just use the regular SQL Server database.

Then it depends on how you connect (Windows Authentication or SQL Authentication), and which rights that user has on the database. 

I frequently use views on SQL Server, with or without geometry, that should normally not be a problem. But I never use the JDBC-connection. So I suspect the database authorizations, because I can’t believe a database connection not being able to see views - that must be authorization.

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.

1 reply

s.jager
Influencer
Forum|alt.badge.img+21
  • s.jagerInfluencer
  • Influencer
  • Best Answer
  • October 23, 2025

Don’t use the JDBC connection, just use the regular SQL Server database.

Then it depends on how you connect (Windows Authentication or SQL Authentication), and which rights that user has on the database. 

I frequently use views on SQL Server, with or without geometry, that should normally not be a problem. But I never use the JDBC-connection. So I suspect the database authorizations, because I can’t believe a database connection not being able to see views - that must be authorization.

Community Stats

32,127
Posts
121,960
Replies
39,777
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.