Custom queries with spatial data

Custom queries with spatial data

book

Article ID: KB0080890

calendar_today

Updated On:

Products Versions
Spotfire Desktop All supported versions

Description

Starting with Spotfire 7.14 we added the ability to read spatial data for map charts from Oracle, MSSQL and PostgreSQL (PostGIS) using existing connectors.  Customers can write custom queries to access their data in Oracle and MSSQL, but configuration issues in PostgreSQL prevent this from being an option.

Issue/Introduction

Ability to write custom queries in some connectors but not others

Environment

Product: TIBCO Spotfire (Desktop client / Analyst) Version: 7.14 and higher OS: All supported Operating Systems

Resolution

Customers will need to write the custom queries directly in PostGIS and access them with the connector, instead of modifying the connector query.