Skip to main content

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

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.Geom_nonSpatialOption 2: Use GeometryExtractor transformer with MS SQL Spatial Reader

Geom_Extractor


Hi @rahulsharma​ 

I need to extract and expose the geometry column.

 

Thanks a bunch!


Reply