I have added MS SQL Spatial writer in FME DESKTOP 2020.1.1.1 and I can view the table attribute other than geometry attribute. Can you please help how to view/access the Geometry field in MS SQL Spatial Writer
Page 1 / 1
hi @naranawinkumar
Can you clarify if you want to extract the geometry or you simply want to expose the geometry column?
If you simply want to expose the geometry column, you can use Microsoft SQL Server Non-Spatial (MSSQL_ADO) reader as explained in Option1.
Option 1: Read the Table with a non-spatial reader and it will get you a column GEOM with geometry values.Option 2: Use GeometryExtractor transformer with MS SQL Spatial Reader