You can connect to Apache Drill through the following interfaces:
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.
Access the latest MapR Drill ODBC drivers at ODBC driver.
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. You can use the Drill JDBC driver provided by MapR, or the embedded JDBC driver included with Drill.
Configure the JDBC driver in the SQuirreL client to connect to Drill from SQuirreL. This section 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.