Question

How to use the sqlexecutor to obtain the GEOM column from an MSSQL 2012 Database?

  • 9 April 2018
  • 1 reply
  • 2 views

Badge

The GEOM column in not read by the FME MSSQL Reader, and therefore it has been recommended to use the SQLExecutor to obtain the geometry. The transformer executes the SQL Statement for every row in the table, meaning that in my case with 1400 rows, the result is 1400*1400 in size.

What is the easyest way to just get the GEOM column from an mssql databse?


1 reply

Userlevel 4

You can probably replace the SQLExecutor with a SQLCreator, that way you only end up with 1400 rows.

Reply