Interfaces Introduction

May 9, 2017

You can connect to Apache Drill through the following interfaces:

  • Drill shell
  • Drill Web Console
  • ODBC*
  • JDBC
  • C++ API

*Apache Drill does not have an open source ODBC driver. However, MapR provides an ODBC driver developed specifically for connecting Apache Drill to BI tools.

Using ODBC to Access Apache Drill from BI Tools

MapR provides an ODBC driver that connects Windows, Mac OS X, and Linux to Apache Drill and BI tools. Install the latest version of Apache Drill with the latest version of the MapR Drill ODBC driver. An ODBC driver that you installed with an older version of Drill may not work with an upgraded version of Drill.

Access the latest MapR Drill ODBC drivers at http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/.

Using JDBC to Access Apache Drill from SQuirrel

You can connect to Drill through a JDBC client tool, such as SQuirreL, on Windows, Linux, and Mac OS X systems, to access all of your data sources registered with Drill. An embedded JDBC driver is included with Drill. Configure the JDBC driver in the SQuirreL client to connect to Drill from SQuirreL. This document provides instruction for connecting to Drill from SQuirreL on Windows.

To use the Drill JDBC driver with SQuirreL on Windows, complete the following steps:

For information about how to use SQuirreL, refer to the SQuirreL Quick Start guide.