Accessing Data from Apache Drill

You can connect to Apache Drill data sources in Spotfire.

What is required to connect to Apache Drill in Spotfire?

Preparations

Before you start, read the System requirements for Spotfire Connectors to make sure that the Apache Drill 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 Apache Drill 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 Apache Spark or Dremio from scratch, 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 Apache Drill in Spotfire.

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

Connecting to Apache Drill

When you want to connect to an Apache Drill 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 Apache Drill

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.

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

2. In the Files and data flyout, browse the folders in the library, or start typing in the search field to find for your content:

Tip: If you do not know the name of the library item, you can search for 'connector:drill' to find all shared connections and connection data sources in the library that were created with the Apache Drill connector.

3. Click to open the connection or connection data source that you want to add data from, and, if prompted, sign in with your credentials.

4. If you opened a connection data source, use the controls in the Views in Selection dialog to select the data you want to analyze from the data source.

5. 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.

Creating a new connection to Apache Drill

If you want to create a new Spotfire connection to an Apache Drill 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 Apache Drill.

4. In the Apache Drill flyout, click New connection.

5. In the Apache Drill 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.