Skip to main content

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.

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,011
Posts
121,567
Replies
39,631
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.