Drill ODBC Driver
MapR provides a downloadable Drill ODBC driver that you can use on all platforms to connect BI tools, such as Tableau, to Drill.
Use the version of the driver that correlates with the version of the Drill server installed. Although older versions of the driver may be able to connect to an upgraded version of Drill, the older drivers do not include all the server features available in the newer drivers.
Drill Version | ODBC Version |
1.15.0 | 1.3.22.1055 |
1.14.0 | 1.3.22.1055 |
1.13.0 | 1.3.16.1049 |
1.12.0 | 1.3.15.1048 |
1.11.0 | 1.3.15.1046 |
1.10.0 | 1.3.8.1030 |
Using MapR-SASL for Authentication on Windows
Drill is automatically configured with MapR security when you install Drill 1.11 and later on a MapR 6.x cluster configured with default security. To successfully connect to Drill from a Windows ODBC client, the MapR client must be installed and a MapR user ticket must exist on the Windows client in the %TEMP% directory or in the location specified by the $MAPR_TICKETFILE_LOCATION environment variable.
The ODBC driver locates user tickets for the current Windows user in the default ticket location, %TEMP%, or in the location specified by the environment variable, $MAPR_TICKETFILE_LOCATION. See Tickets and Generating a MapR User Ticket for more information.
You can either copy a user ticket that was generated on the MapR cluster into the default
location (%TEMP%), or you can run the maprlogin
command to generate the
ticket on the Windows client.
mapr-clusters.conf
file to the client machine. Copy the file from
/opt/mapr/conf/mapr-clusters.conf
to
C:/opt/mapr/conf/mapr-clusters.conf
on the client machine. Verify that
the cluster to which the client is connecting is listed as the first entry in the
mapr-clusters.conf
file. Also, if the cluster is secure, verify that
secure=true
for the cluster entry in the file.Example
$ maprlogin password -user mapr
[Password for user 'mapr' at cluster 'Cluster1':]
The MapR credentials for the mapr user in Cluster1 are written to /tmp/maprticket_1000.'C:\Users\TABETH~1\AppData\Local\Temp/maprticket_Tabetha Stephens'
To override this location, set the "MAPR_TICKETFILE_LOCATION" global variable for the Windows user.