Accessing Data from Dremio

You can connect to Dremio data sources in Spotfire.

What is required to connect to Dremio in Spotfire?

Preparations

Before you start, read the System requirements for Spotfire Connectors to make sure that the Dremio data source that you want to connect to is compatible with your version of Spotfire. The system requirements page also specifies which ODBC drivers, and versions of the drivers, that you can use with the connector.

Installing the driver

To be able to connect to Dremio data sources in Spotfire, you must install the corresponding ODBC driver on your computer.

For instructions on how to download and install the required ODBC drivers, see Drivers and data sources in TIBCO Spotfire.

Setting up a DSN for your data source

If you are going manage and create connections to Dremio, you must have a DSN for the data source you want to connect to on your computer.

For information and help, see How to use a DSN for connecting to Dremio in Spotfire.

For best practices, requirements, and limitations, see Best Practices when Connecting to Dremio.

Connecting to Dremio

When you want to connect to a Dremio data source in Spotfire, you can either open and reuse a connection that is shared in your Spotfire library, or you can create a new connection based on a DSN, to add data to your analysis.

Adding data from an existing connection to Dremio

If you want to add data from an existing connection or connection data source that is shared in your Spotfire library, you can use the search function in the Files and data flyout to quickly find the data you are looking for.
Use the search phrase 'connector:dremio' to find all shared connections that were created with the Dremio connector. For more detailed instructions, see How to work with Data Connections and their Data Sources in the Library.

Creating a new connection to Dremio

If you want to create a new Spotfire connection to a Dremio data source, you must have a DSN for that data source on your computer. Then you can configure your connection so that you can add data to your analysis, and share the connection in the library, for easy access to the selected data for other users on your team.

1. On the Authoring bar, click Files and data .

2. In the Files and data flyout, click Connect to.

3. In the list of connectors, select Dremio.

4. In the Dremio flyout, click New connection.

5. In the Dremio Connection dialog, select the DSN in the list that you want to create a Spotfire connection from, enter the Username and Password for the data source, and then click Connect.  

6. In the Views in Connection dialog, select the data that you want to include in the connection, then click OK.

7. The final step is a summary view of the data that you are about to add to your analysis, and how the data will be added. Make any changes that you want, and then click OK to confirm and add the data to the analysis.

Note: Once you have created the connection in Spotfire, the DSN that you used to create the connection is no longer required for using the connection. All the required connection information, except for username and password, is stored in the Spotfire connection.