You can work with your data in TIBCO Spotfire through an ODBC connection.
The following procedure is written for TIBCO Spotfire Analyst 7.5. Simba ODBC drivers also support other Spotfire clients, including those from Spotfire 6.5 and 7.0.
To connect to your data store using TIBCO Spotfire Business Author, you must install the appropriate Simba ODBC driver and configure a DSN on the machine where Spotfire Business Author is running.
Make sure that the bitness of the driver that you are using matches the bitness of TIBCO Spotfire Analyst. If you are using the 32-bit version of TIBCO Spotfire Analyst, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of TIBCO Spotfire Analyst, then you need to use the 64-bit version of the driver.
To retrieve data using Spotfire Analyst:
Optionally, you can edit the SQL statement manually in the SQL Statement pane, or load a statement from a SQL file.
Data retrieved from your selected tables, columns, and views displays in the Data panel.