Simba Technologies
Simba Technologies

Simba ODBC Drivers
Quick Start Guide for Windows

Using TIBCO Spotfire

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:

  1. In TIBCO Spotfire Analyst, select File > Add Data Tables, and then click Add > Database.
  2. In the Open Database dialog box, select ODBC Data Provider and then click Configure.
  3. In the Configure Data Source Connection dialog box, from the System Or User Data Source drop-down list, select your DSN.
  4. If your data store requires authentication, then type your credentials in the Username and Password fields.
  5. Click OK.
  6. In the Open Database dialog box, click OK.
  7. In the Specify Tables And Columns dialog box, in the Tables, Views, And Columns pane, select the check boxes beside the items that you want to retrieve.
  8. Optionally, you can edit the SQL statement manually in the SQL Statement pane, or load a statement from a SQL file.

  9. In the Data Source Name field, type a name for the data source in Spotfire, and then click OK.
  10. To preview the data table that is retrieved based on your selected data, in the Add Data Tables dialog box, click Preview. To close the preview, click Close.
  11. In the Add Data Tables dialog box, click OK.

Data retrieved from your selected tables, columns, and views displays in the Data panel.