You can connect to Apache Drill through the following interfaces:
*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:
- Step 1: Getting the Drill JDBC Driver
- Step 2: Installing and Starting SQuirreL
- Step 3: Adding the Drill JDBC Driver to SQuirreL
- Step 4: Running a Drill Query from SQuirreL
For information about how to use SQuirreL, refer to the SQuirreL Quick Start guide.