Using TIBCO Spotfire

You can work with Spark data in TIBCO Spotfire through an ODBC connection.

The following procedure is written for TIBCO Spotfire Analyst 7.5. The Simba Spark ODBC Driver also supports other Spotfire clients, including those from Spotfire 6.5 and 7.0.

Note:

To connect to your Spark data store using TIBCO Spotfire Business Author, you must install the Simba Spark ODBC Driver and configure a DSN on the machine where Spotfire Business Author is running.

Important:

Make sure that the bitness of the driver that you are using matches the bitness of your operating system. If you are using a 32-bit operating system, then you need to use the 32-bit version of the driver. If you are using a 64-bit operating system, then you need to use the 64-bit version of the driver.

To retrieve data from your Spark data store using Spotfire Analyst:

In TIBCO Spotfire Analyst, select File > Add Data Tables, and then click Add > Database.
In the Open Database dialog box, select ODBC Data Provider and then click Configure.
In the Configure Data Source Connection dialog box, from the System Or User Data Source drop-down list, select your DSN.
If the data store that you are connecting to requires authentication, then type your credentials in the Username and Password fields.
Click OK.
In the Open Database dialog box, click OK.
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.

Optionally, you can edit the SQL statement manually in the SQL Statement pane, or load a statement from a SQL file.

In the Data Source Name field, type a name for the data source in Spotfire, and then click OK.
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.
In the Add Data Tables dialog box, click OK.

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