Discussion Board for collaboration regarding Qlik GeoAnalytics.
How to add from SDO_Geometry (GIS) data in Oracle?
I investigated following link but shape field can not added to QlikSense.
Connect to Database in GeoAnalytics Plus « bi.idevio.com
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;
SELECT NAME, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS point FROM NEW_TEST;
Oracle - Converting SDO_GEOMETRY to WKT? - Stack Overflow
Firstly, why can not I add data from db with odbc connection? GeoQlik was doing this.
I tried your sql statement and result is negative. Sql script working in db but QlikSense did not fetch data.
sql: SELECT A.ADINUMARASI, MDSYS.SDO_UTIL.TO_WKTGEOMETRY(A.SHAPE) AS polygon FROM SDEDATA.QMAHALLE A
You can fetch the WKT with odbc if you prefer and then do the QGA "Load" from a loaded table instead.
However going directly to the database is probably more effective.
In your case the "Geometry field" is called "polygon" if I read your select statement correctly.
I tried to polygon option in geometry field, but result is negative.
Can you send a screen video about this case?
Sorry for being unclear,your geometry field name is "polygon" not "SHAPE".
Result is negative.
Do you have any Geographic Information System Specialist in your company? I would recommend having a GIS specialist staff.
did you resolve this issue ?
do you have a screenshot of the configuration of the connection with the query to Oracle ?
And what is the disadvantage could have the character limit of Oracle?