How to import Teradata spatial data via Information Links in TIBCO Spotfire

How to import Teradata spatial data via Information Links in TIBCO Spotfire

General instructions for how to create Information Links for spatial (map chart) data can be found in TIBCO Community article "Using SQL Server spatial data with Spotfire" (https://community.tibco.com/wiki/using-sql-server-spatial-data-spotfire). However, accessing spatial data from Teradata in this way may result in the following error:

Error message: Failed to create DataTable

ImportException at Spotfire.Dxp.Data:
Failed to create DataTable (HRESULT: 80131500)

(...)

InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: [Teradata Database] [TeraJDBC 16.20.00.12] [Error 6834] [SQLState HY000] Method '<ST_GEOMETRY>.STAsBinary( ... )' does not exist. (HRESULT: 80131500)

If you encounter the issue mentioned above ("Method '<ST_GEOMETRY>.STAsBinary( ... )' does not exist"), this may be caused by the JDBC driver transferring binary data differently if it's a BLOB as opposed to a VARBYTE.

To resolve that issue, change the column expression from

%1.ST_AsBinary()

to

cast(%1.ST_AsBinary() as varbyte(1000))

where the varbyte length needs to be large enough to fit the data.

• Using SQL Server spatial data with Spotfire
  • https://community.tibco.com/wiki/using-sql-server-spatial-data-spotfire