How to connect Oracle-Postgis from QlikSense GeoAnalytics for Geographic Shape Data (SDO_Geometry etc)

[Anonymous]

Hi,

How to connect Oracle-Postgis from QlikSense GeoAnalytics for Geographic Shape Data (SDO_Geometry etc.)?

I inspected this link. But I could not connect

http://bi.idevio.com/wp-content/qlik/geoanalytics/releases/IdevioGeoAnalyticsConnector-1.7.3/doc/geo...

GeoAnalytics Plus Installation « bi.idevio.com

Connect to Database in GeoAnalytics Plus « bi.idevio.com

Can you have any document or video for oracle connection?

[Patric_Nordstrom]

Hi,
QGA reads WKT, you need to specify a select statement, and retrieve the shape field as WKT.
Something like this: SELECT NAME, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS point FROM NEW_TEST;

Thanks,
Patric