General instructions for how to create Information Links for spatial (map chart) data can be found in Community article "Using SQL Server spatial data with Spotfire" (https://community.spotfire.com/articles/spotfire/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.spotfire.com/articles/spotfire/using-sql-server-spatial-data-spotfire