Connector for Apache Drill

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 Drill 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

You can use the Spotfire Connector for Apache Drill to connect to the following data source types:

Driver information

To connect to Apache Drill, you must install the MapR Drill ODBC Driver on your computer.

Downloading the MapR Drill ODBC Driver

  1. The MapR Drill ODBC Driver is available on the the MapR downloads page.

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.

Installing on Linux (Spotfire 12.0 and later)

After you have installed the MapR Drill ODBC driver on a Linux system, for use with an Automation Services or Web Player service, you must change the name of the driver in the file odbcinst.ini. The name must match the name that the driver gets when you install it on a Windows system.

  1. After you have installed the MapR Drill ODBC driver, open and edit the file odbcinst.ini.

    Tip: The file is typically located at /etc/odbcinst.ini.

  2. Locate the section for the MapR Drill ODBC driver, copy it, and create a duplicate of it.

  3. Change the name of the duplicate section.

    Default name

    New name

    [MapR Drill ODBC Driver 64-bit]

    [MapR Drill ODBC Driver]

 

 

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 Guide for Spotfire® Analyst. There you'll find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.