Connector for Apache Spark SQL

On this page, you find information about downloading and installing the drivers you need to be able connect to data sources with the connector for Apache Spark SQL in Spotfire.

Preparations

Before downloading and installing any driver software for use with this connector, read the system requirements for the connector for your version of Spotfire. Make sure that your database version and driver version is supported in your version of Spotfire.

Remember that additional requirements and third party dependencies might apply for using the drivers. Refer to the official documentation from the driver vendor for more information.

Supported data sources

Use the Spotfire Connector for Apache Spark SQL to connect to the following data source types:

Connecting to Apache Spark SQL


To connect to Apache Spark SQL in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Apache Spark SQL, you must install the TIBCO ODBC Driver for Apache Spark on your computer.

The driver is included in the TIBCO Drivers® package, which is freely available to all Spotfire users, whether you are a paying customer or a trial user.

Downloading the TIBCO ODBC Driver for Apache Spark SQL as a TIBCO Cloud™ Spotfire® user

  1. In a web browser, go to https://spotfire-next.cloud.tibco.com/ and sign in with your TIBCO Cloud™ Spotfire® account.

  2. To go to the Spotfire library, select File > View library on the menu bar.

  3. In the Spotfire library, click Downloads in the navigation panel to the left.

  4. Click to download the TIBCO Driver for Apache Spark SQL.

Downloading TIBCO ODBC Driver for Apache Spark SQL as an on-premises customer

  1. Go to the TIBCO Spotfire Server page on TIBCO eDelivery and sign in with your TIBCO account.

  2. Specify your Spotfire version and your operating system.

  3. Confirm that you have read and accept the EULA.

  4. Click Individual file download.

  5. Click TIBCO Drivers Software.

  6. Download the TIBCO Drivers Software files.

Connecting to Amazon EMR Spark SQL

To connect to Amazon EMR Spark SQL in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Amazon EMR Spark SQL, install the TIBCO ODBC Driver for Apache Spark SQL. See the download instructions above.

Connecting to Databricks

To connect to Databricks in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Databricks, you must install the Databricks ODBC driver for Apache Spark on your computer. The driver is available for download from Databricks.

Downloading the Databricks ODBC Driver for Apache Spark

Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.

Connecting to Hortonworks Spark SQL

To connect to Hortonworks Spark SQL in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Hortonworks Spark SQL, install the TIBCO ODBC Driver for Apache Spark SQL. See the download instructions above.

Connecting to IBM BigInsights Spark SQL

To connect to IBM BigInsights Spark SQL in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Cloudera Spark SQL, install the TIBCO ODBC Driver for Apache Spark SQL. See the download instructions above.

Connecting to MapR Spark SQL

To connect to MapR Spark SQL in Spotfire, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to MapR Spark SQL, install the TIBCO ODBC Driver for Apache Spark SQL. See the download instructions above.

Connecting to Microsoft Azure HDInsight Spark SQL

To connect to Microsoft Azure HDInsight Spark SQL, use the Apache Spark SQL connector (Add content > Connect to > Apache Spark SQL).

To connect to Microsoft Azure HDInsight Spark SQL, install the TIBCO ODBC Driver for Apache Spark SQL. See the download instructions above.

 

 

So, I'm all set up... What do I do now?

If you want to learn more about how to use this connector, see the User's Guide for TIBCO Spotfire® Analyst. There you'll find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.