TIBCO Spotfire does not support importing map shapes from Oracle's ST_GEOMETRY data type through Information Services.
Article ID: KB0084083
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All versions |
Description
One of Oracle's data types for spatial data, ST_GEOMETRY, is not supported through Spotfire Information Services. Information Services is the component in TIBCO Spotfire Server, TIBCO Spotfire Web Player Server and TIBCO Spotfire installed client, that handles data access using Information Links. To work with map shape data, the shape/polygon information needs to be retrieved as a Well Known Binary (WKB). Trying to get the WKB data through ST_GEOMETRY, which is a sort of WKB, will not work. Trying to extract the data using .GET_WKB() will also not work and result in an error such as the following:
Caused by: com.spotfire.ws.im.IMException: Failed to get data: [tibcosoftwareinc][Oracle JDBC Driver]Value can not be converted to requested type.
Caused by: com.spotfire.ws.im.IMException: Failed to get data: [tibcosoftwareinc][Oracle JDBC Driver]Value can not be converted to requested type.
Issue/Introduction
TIBCO Spotfire does not support importing map shapes from Oracle's ST_GEOMETRY data type through Information Services.
Environment
Spotfire, Oracle
Resolution
To make use of the spatial data from Oracle, you will need to have access to the data saved in the SDO_GEOMETRY data type. Using this data type, you are able to edit the expression used for the column element to add %1.GET_WKB() which should work properly. After successfully importing the data, there are additional steps required to render the shape data on the map charts. These additional steps can be found in the help topics of the TIBCO Spotfire installed client, under Visualizations -> Map Chart -> Configuration of Geographical Data for Map Charts.
Feedback
Yes
No
Powered by
