Convert and read geometry data in SQL server using Geoanalytics (not plus)

[bing_jville]

Hi

1) I have geometry data (column "shape") in SQL server database. And I converted it into WKT using STAsText().

SELECT RegionID
, shape
,shape.STAsText() as wkt
FROM dbo.Regions

2) Then I loaded this table as a table into Qlik Sense.

3) Can I use GeoAnalytic Connector (not plus) to load the WKT field from the previously loaded table, then visualize on map?

Thanks

[Patric_Nordstrom]

Sure, use "Load", "Loaded table" and Geometry type "WKT". You will also need to specify the CRS (EPSG code).

Thanks,

Patric

[bing_jville]

Thanks Patric. I tried a few more times this morning, still can't read  the WKT.

The WKT shows ok in my SQL server management studio. But I can't see the data value once I loaded the table into Qlik.

And QGA can't find the value either. I've tried your method of using "replace" to convert the data. But Qlik can't read the value. And I've noticed my WKT is different with yours. I have a space between POLYGON and ((

e.g. POLYGON ((1888813.9814 5796074.3189, ...

1. My SQL geometry data is correct - SQL management studio can display the map

2. I tried STAsText(), ToString(), AsTextZM() - same error, QGA can't read 

[Patric_Nordstrom]

Ok, I would check so that wkt strings are not truncated, some dbs do that.
WKT from SQL Server are readable by QGA (https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/MS-SQL-Server-and-Qlik-GeoAnalytics-QGA/ta...)

Can you post 2-3 lines of the wkt strings? What projection does the data have, EPSG code?