# Connect with Tibco Spotfire

Tibco Spotfire is a complete analytics solution. You can use Tibco Spotfire to combine your SingleStore data in a single analysis and get a holistic view of the same with an interactive visualization. Spotfire software makes businesses smart, delivers AI-driven analytics, and makes it easier to plot interactive data on maps. It speeds up data analysis across an organization for faster, confident, and accurate decision-making.

The following certification matrix shows the recommended Spotfire version and the SingleStore driver:

| Spotfire Analytics 12.0.11 LTS and later | SingleStoreODBC Driver |
| ---------------------------------------- | ---------------------- |

## Prerequisites

* Download and install [Tibco Spotfire](https://www.spotfire.com/downloads) (for Windows). Create an account and register with a username and password.
* Download and install the latest version of [The SingleStore ODBC Driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md).

## Connect Tibco Spotfire to SingleStore

1. Open the Tibco Spotfire desktop application. A sign in screen is displayed. Select **Tibco Login**.

2. On the web authentication page, log in with the credentials used while registering to download Tibco Spotfire.

3. After logging in, you are redirected to the desktop application and the homepage of Tibco Spotfire is displayed.

4. In Spotfire Analyst, open the **Files and data** flyout, and select **Connect to**. Select **SingleStore**, and then select **New Connection**.

5. In the connection dialog, enter the following:

   * Server IP address / name
   * Database System ( select **SingleStore**)
   * Authentication Method as Database Authentication
   * Username to access the database
   * Password to access the database

6. Select **Connect**. After a successful connection, the **Database** drop down is populated with all the existing databases. Select a database, and select **OK**.

7. In the connection view window, select the tables you want to import.

8. The **Add data to analysis** popup is displayed. Select **Add as new data table > Import > OK**. 

You are now ready to explore your SingleStore data using Tibco Spotfire.

## Troubleshooting

* **Issue**: Corrupted non-english characters in data loaded through Data Connection.


  **Resolution**: Use the Unicode version of the SingleStore ODBC driver for proper handling of non-english characters in the data.
* **Issue**: Fetch performance issue or "Connection reset by peer" error with multiple concurrent connections.


  **Resolution**: Use the latest version of the SingleStore ODBC driver instead of MySQL ODBC drivers.
* **Issue**: Data inconsistency due to Prefetch limit of 100000 and Auto-Paging behavior.


  **Resolution**: The default Prefetch limit was removed in Spotfire version 12.0.11 LTS, which is the minimum recommended version to use with SingleStore.

***

Modified at: December 18, 2025

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-tibco-spotfire/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-tibco-spotfire/)

(An index of the documentation is available at /llms.txt)