drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [1/2] drill git commit: Updated docs from Catherine Skrbina for latest ODBC driver
Date Tue, 30 May 2017 23:14:52 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages e8bbb9d6d -> ee71b646e


http://git-wip-us.apache.org/repos/asf/drill/blob/ee71b646/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
index d55a49c..710c7dd 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
@@ -1,8 +1,112 @@
 ---
 title: "Testing the ODBC Connection"
-date: 2017-01-24 22:24:25 UTC
+date: 2017-05-30 23:11:53 UTC
 parent: "Configuring ODBC"
 ---
+You can use DSN connection strings and DSN-less connection strings for your connections.
+
+* [Example Connection String with DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-string-with-DSN)
+* [Example Connection Strings without DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-strings-without-DSN)
+
+## Example Connection String with DSN 
+The following is an example of a connection string for a connection that uses a DSN:
+
+    DSN=[DataSourceName]	
+
+[*DataSourceName*] is the DSN that you are using for the connection.
+
+You can set additional configuration options by appending key-value pairs to the connection
string. Configuration options that are passed in using a connection string take precedence
over configuration options that are set in the DSN.
+
+
+## Example Connection Strings without DSN 
+
+Some applications provide support for connecting to a data source using a driver without
a DSN. To connect to a data source without using a DSN, use a connection string instead.
+The placeholders in the examples are defined as follows, in alphabetical order:
+
+* [*ClusterName*] is the name of the ZooKeeper cluster to which you are connecting.
+* [*DomainName*] is the fully qualified domain name of the Drill server host.
+* [*PortNumber*] is the number of the TCP port that the Drill server uses to listen for client
connections.
+* [*Server*] is the IP address or host name of the Drill server to which you are connecting.
+* [*ServiceName*] is the Kerberos service principal name of the Drill server.
+* [*YourPassword*] is the password corresponding to your user name.
+* [*YourUserName*] is the user name that you use to access the Drill server.
+
+
+###Drillbit Connections
+The following is the format of a DSN-less connection string for a Drillbit that does not
require authentication:
+
+Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=[*Server*];Port=[*PortNumbe*r]
+
+For example:
+
+    Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=192.168.222.160;Port=31010
+
+###ZooKeeper Connections
+The following is the format of a DSN-less connection string for a ZooKeeper cluster that
does not require authentication:
+
+Driver=MapR Drill ODBC Driver;
+ConnectionType=ZooKeeper; 
+ZKQuorum=[*Server1*]:[*PortNumber*1], [*Server2*]:[*PortNumber2*], [*Server3*]:[*PortNumber3*];
+ZKClusterID=[*ClusterName*]
+
+For example:
+
+    Driver=MapR Drill ODBC Driver;
+	ConnectionType=ZooKeeper; 
+	ZKQuorum=192.168.222.160:31010, 192.168.222.165:31010, 192.168.222.231:31010;
+	ZKClusterID=drill;
+
+
+###Kerberos Authentication Connections
+The following is the format of a DSN-less connection string for a Drillbit that requires
Kerberos authentication:
+
+Driver=MapR Drill ODBC Driver;
+ConnectionType=Direct; 
+Host=[*Server*];Port=[*PortNumber*];
+AuthenticationType=Kerberos; 
+KrbServiceHost=[*DomainName*];KrbServiceName=[*ServiceName*]
+
+For example:
+
+    Driver=MapR Drill ODBC Driver;
+	ConnectionType=Direct; 
+	Host=192.168.222.160;Port=31010;
+	AuthenticationType=Kerberos; 
+	KrbServiceHost=maprdriverdemo.example.com;	KrbServiceName=drill
+
+###MapR-SASL Authentication Connections
+
+The following is the format of a DSN-less connection string for a Drillbit that requires
MapR-SASL authentication:
+
+Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=[*Server*];Port=[*PortNumber*];AuthenticationType=MapRSASL
+
+For example:
+
+    Driver=MapR Drill ODBC Driver;
+	ConnectionType=Direct; 
+	Host=192.168.227.169;
+	Port=31010;
+	AuthenticationType=MapRSASL
+
+###Plain Authentication Connections
+
+The following is the format of a DSN-less connection string for a Drillbit that requires
Plain authentication:
+
+Driver=MapR Drill ODBC Driver;ConnectionType=Direct; 
+Host=[*Server*];Port=[*PortNumber*];	
+AuthenticationType=Plain;
+UID=[*YourUserName*];PWD=[*YourPassword*]
+
+For example:
+
+    Driver=MapR Drill ODBC Driver;ConnectionType=Direct; 
+	Host=192.168.227.169;Port=31010;
+    AuthenticationType=Plain;
+	UID=username;PWD=mapr999
+
+
+##Testing the ODBC Connection
+
 The procedure for testing the ODBC connection differs depending on your platform, as described
in the following sections:
 
 * [Testing the ODBC Connection on Linux]({{site.baseurl}}/docs/testing-the-odbc-connection/#testing-the-odbc-connection-on-linux)
@@ -11,23 +115,20 @@ The procedure for testing the ODBC connection differs depending on your
platform
 
 ## Testing the ODBC Connection on Linux
 
-To test the ODBC connection on Linux use the test utilities in the `samples` directory of
the driver manager installation: `iodbctest` and `iodbctestw`. Use `iodbctest` to
-test how your driver works with an ANSI application. Use `iodbctestw` to test
-how your driver works with a Unicode application.
+To test the ODBC connection on Linux use the test utilities in the `samples` directory of
the driver manager installation: `iodbctest` and `iodbctestw`. Use `iodbctest` to test how
your driver works with an ANSI application. Use `iodbctestw` to test how your driver works
with a Unicode application.
 
 There are 32-bit and 64-bit installations of the iODBC driver manager available. If you have
only one or the other installed, then the appropriate version of iodbctest (or iodbctestw)
is available. However, if you have both 32- and 64-bit versions installed, then you need to
be careful that you are running the version from the correct installation directory.
 
-Visit [http://www.iodbc.org](http://www.iodbc.org/) for further details on
-using the iODBC driver manager.
+See [http://www.iodbc.org](http://www.iodbc.org/) for further details on using the iODBC
driver manager.
 
 ### Example of a Test on Linux
 
 To test the ODBC connection on a Linux cluster, follow these steps:
 
-1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/). For example,
to start Drill in local mode on a linux cluster:  
+1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/). For example,
to start Drill in local mode on a Linux cluster:  
 
-        [root@centos23 drill-1.2.0]# bin/drill-localhost
-        apache drill 1.2.0 
+        [root@centos23 drill-1.10.0]# bin/drill-localhost
+        apache drill 1.10.0 
         "the only truly happy people are children, the creative minority and drill users"
 
 2. In the `samples` directory of the driver manager installation, run `iodbctest` or `iodbctestw`.
 
@@ -36,66 +137,84 @@ To test the ODBC connection on a Linux cluster, follow these steps:
           iODBC Demonstration program
         This program shows an interactive SQL processor
         Driver Manager: 03.52.0709.0909
+   
    The prompt for an ODBC connection string appears.  
 
         Enter ODBC connect string (? shows list): ?
 
-3. Type ? to see the DSN name.  
-   Output is:
+3. Type `?` to see the DSN name.  The output is:
 
-        DSN                              | Driver                                  
+        DSN                                          | Driver                           
      
         ------------------------------------------------------------------------------
-        Sample MapR Drill DSN 64         | MapR Drill ODBC Driver 64-bit           
+        Sample MapR Drill (64-bit)                   | MapR Drill ODBC Driver 64-bit    
      
         Enter ODBC connect string (? shows list):
 
-4. If you are connecting directly to a Drillbit, type an ODBC connection string using the
following format:
+4. To test the connection if the DSN was previously configured in the `.odbc.ini`, type the
following connection string:  
+ 
+        DSN=<DSN name>
 
-        DSN=<DSN name>;ConnectionType=Direct;Host=<Host Name>;Port=<Port Number>
+      However, if you are connecting directly to a Drillbit and the DSN was not previously
configured in the .odbc.ini, type an ODBC connection string using the following format:
+
+        DSN=<DSN name>;
+		ConnectionType=Direct;
+		Host=<Host Name>;Port=<Port Number>
      
      OR
      
      If you are connecting to a ZooKeeper cluster, type an ODBC connection string using the
following format:
 
-        DSN=<DSN Name>;ConnectionType=ZooKeeper;ZKQuorum=<Server1:Port1>,<Server2:Port2>;ZKClusterID=<Cluster
Name>`
+        DSN=<DSN Name>;
+		ConnectionType=ZooKeeper;
+		ZKQuorum=<Server1:Port1>,<Server2:Port2>;
+		ZKClusterID=<Cluster Name>
 
      The output of a successful test is:  
-     `Driver: 1.2.0.1001 (MapR Drill ODBC Driver)  
-     SQL> `  
-     After the `SQL>` prompt appears, type `quit;`, and go to the Drill shell to run commands.
Do not attempt to run SQL commands from this prompt.
 
-### Example Connection Strings
+     `Driver: 1.3.8.<version> (MapR Drill ODBC Driver)  
+     SQL> `  
+     
+     After the `SQL>` prompt appears, type `quit;`.
+     Go to the Drill shell to run commands. Do not attempt to run SQL commands from this
prompt.
 
-The following example shows a connection string for a direct connection:
+This example shows a connection string for a direct connection:
 
-        DSN=Sample MapR Drill DSN 64;ConnectionType=Direct;Host=localhost;Port=31010
+        DSN=Sample MapR Drill 64-bit;
+		ConnectionType=Direct;
+		Host=localhost;Port=31010
 
-The following example shows a connection string for a ZooKeeper cluster connection:
+This example shows a connection string for a ZooKeeper cluster connection:
 
-        DSN=Sample MapR Drill DSN 64;ConnectionType=ZooKeeper;ZKQuorum=centos23.lab:5181;ZKClusterID=docs41cluster-drillbits
+        DSN=Sample MapR Drill 64-bit 64;
+		ConnectionType=ZooKeeper;
+		ZKQuorum=centos23.lab:5181;
+		ZKClusterID=docs60cluster-drillbits
 
 ## Testing the ODBC Connection on Mac OS X
 
 To test the ODBC connection on Mac OS X, follow these steps.
 
-1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/).  
+1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/). 
+ 
 2. Start the iODBC Administrator.app in `/Applications`.  
    The iODBC Data Source Administrator dialog appears. 
-3. On the User DSN tab, select the MapR Drill.  
-   ![]({{ site.baseurl }}/docs/img/odbc_data_source_names.png)  
+
+3. On the User DSN tab, select **MapR Drill**.  
+   ![]({{ site.baseurl }}/docs/img/odbc_data_source_names.png) 
+
 4. Click **Test**.  
-   The Login for Sample MapR Drill dialog appears.  
+   The Login for the MapR Drill dialog appears.  
    ![]({{ site.baseurl }}/docs/img/odbc_login.png)  
-5. If you configured Basic Authentication in the `.odbc.ini`, enter the user name and password
you also configured; otherwise, click **OK**.  
-   The success message appears.  
-   ![]({{ site.baseurl }}/docs/img/success.png)  
+
+5. If you configured Plain (or Basic) authentication in the `.odbc.ini`, enter the user name
and password you also configured; otherwise, click **OK**.  The success message displays.
 
+   ![]({{ site.baseurl }}/docs/img/success.png)
    
 ## Testing the ODBC Connection on Windows
 
 To test the ODBC connection on Windows, follow these steps:
 
-1. Follow instructions to configure the ODBC connection on Windows.  
+1. Follow instructions to configure the ODBC connection on Windows. 
    The MapR Drill ODBC Driver DSN Setup dialog is displayed.
    ![]({{ site.baseurl }}/docs/img/odbc-configure2.png)
 
-2. Click the Test Button.
-   ![]({{ site.baseurl }}/docs/img/odbc-test.png)
+2. Click **Test**. A Test Results popup will display that states you have successfully connected
to the data source. 
+

http://git-wip-us.apache.org/repos/asf/drill/blob/ee71b646/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
index 8839d59..0771466 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
@@ -1,6 +1,6 @@
 ---
 title: "Installing the Driver on Linux"
-date: 2016-12-24 00:01:40 UTC
+date: 2017-05-30 23:11:54 UTC
 parent: "Installing the ODBC Driver"
 ---
 Install the MapR Drill ODBC Driver on the machine from which you connect to
@@ -20,13 +20,13 @@ Verify that your system meets the system requirements before you start.
 ## System Requirements
 
   * One of the following distributions (32- and 64-bit editions are supported):
-    * Red Hat® Enterprise Linux® (RHEL) 5.0/6.0
-    * CentOS 5.0/6.0
-    * SUSE Linux Enterprise Server (SLES) 11
+    * Red Hat® Enterprise Linux® (RHEL) 5, 6, or 7
+    * CentOS 5, 6, or 7
+    * SUSE Linux Enterprise Server (SLES) 11 or 12
   * 90 MB of available disk space.
   * An installed ODBC driver manager:
     * iODBC 3.52.7 or above  
-      OR 
+      or 
     * unixODBC 2.2.14 or above  
     On Linux, 3.52.7 is available as a tarball. After unpacking the tarball, see the README
for instructions about building the driver manager.
   * The client must be able to resolve the actual host name of the Drill node or nodes from
the IP address. Verify that a DNS entry was created on the client machine for the Drill node
or nodes.   
@@ -35,31 +35,23 @@ If not, create an entry in `/etc/hosts` for each node in the following
format:
     `<drill-machine-IP> <drill-machine-hostname>`  
     Example: `127.0.0.1 localhost`
 
-To install the driver, you need Administrator privileges on the computer.
+To install the driver, you need Administrator privileges on the computer. 
 
 ## Step 1: Download the MapR Drill ODBC Driver
-Download either the 32 or 64-bit driver:
-
-  * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/maprdrill-1.3.0.1009-1.i686.rpm)
-  * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/maprdrill-1.3.0.1009-1.x86_64.rpm)
+Download the driver from the [download site](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/).
The current version is 1.3.8.
 
 ## Step 2: Install the MapR Drill ODBC Driver
 
 To install the driver, complete the following steps:
 
   1. Login as the root user.
-  2. Navigate to the folder that contains the driver RPM packages to install.
+  2. Navigate to the directory that contains the driver RPM packages to install.
   3. Enter the following command where _RPMFileName_ is the file name of the RPM package
containing the version of the driver that you want to install:  
      * RedHat/CentOS  
      `yum localinstall --nogpgcheck <RPMFileName>`
      * SUSE  
      `zypper install RPMFileName`
 
-The MapR Drill ODBC Driver depends on the following resources:
-
-  * `cyrus-sasl-2.1.22-7` or above
-  * `cyrus-sasl-gssapi-2.1.22-7` or above
-  * `cyrus-sasl-plain-2.1.22-7` or above
 
 The MapR Drill ODBC Driver typically resolves dependencies automatically. If not, error messages
during the installation indicate that the package manager in your Linux distribution cannot
resolve the
 dependencies automatically. In this case, manually install the packages.
@@ -69,23 +61,22 @@ locations and descriptions:
 
 File| Description  
 ---|---  
-`/opt/mapr/drillodbc/ErrorMessages `| Error messages files directory.  
-`/opt/mapr/drillodbc/Setup`| Sample configuration files directory.  
-`/opt/mapr/drillodbc/lib/32 `| 32-bit shared libraries directory.  
-`/opt/mapr/drillodbc/lib/64`| 64-bit shared libraries directory.  
+`/opt/mapr/drill/ErrorMessages `| Error messages files directory.  
+`/opt/mapr/drill/Setup`| Sample configuration files directory.  
+`/opt/mapr/drill/lib/32 `| 32-bit shared libraries directory (will be created if you install
the 32-bit driver).  
+`/opt/mapr/drill/lib/64`| 64-bit shared libraries directory (will be created if you install
the 64-bit driver)..  
   
 ## Step 3: Check the MapR Drill ODBC Driver version
 
 To check the version of the driver you installed, use the following case-sensitive command
on the terminal command line:
 
-`yum list | grep MapRDrillODBC`
+`yum list | grep MapRDrill`
 
 or
 
-`rpm -qa | grep MapRDrillodbc`
+`rpm -qa | grep MapRDrill`
 
 
 ### Next Step
 
-[Configuring ODBC on Linux]({{ site.baseurl }}/docs/configuring-odbc-on-linux/).
-
+[Configuring ODBC on Linux]({{ site.baseurl }}/docs/configuring-odbc-on-linux/).
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ee71b646/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
index 74a0eac..a1af4cd 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
@@ -1,6 +1,6 @@
 ---
 title: "Installing the Driver on Mac OS X"
-date: 2017-05-23 23:46:31 UTC
+date: 2017-05-30 23:11:54 UTC
 parent: "Installing the ODBC Driver"
 ---
 Install the MapR Drill ODBC Driver on the machine from which you connect to
@@ -15,7 +15,7 @@ Install the MapR Drill ODBC Driver on a system that meets the [system requiremen
 ## System Requirements  
 To install the driver, you need Administrator privileges on the computer.
 
-  * Mac OS X version 10.8.0 or later  
+  * Mac OS X version 10.9, 10.10, or 10.11  
   * 100 MB of available disk space  
   * iODBC 3.52.7 or later  
     The iodbc-config file in the `/usr/local/iODBC/bin` includes the version of the driver.
 
@@ -25,15 +25,19 @@ If not, create an entry in `/etc/hosts` for each node in the following
format:
     `<drill-machine-IP> <drill-machine-hostname>`  
     Example: `127.0.0.1 localhost`
 
+----------
+
+## Step 1: Download the MapR Drill ODBC Driver
 
 
 ----------
+Note: The most current (version 1.3.8)  MapR Drill ODBC driver for Mac might not be available
yet. 
+----------
 
-## Step 1: Download the MapR Drill ODBC Driver
 
-Click the following link to download the driver:  
+Click the following link to download the latest version (1.3.8) of the driver, which supports
both 32- and 64-bit client applications:  
 
-[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3.dmg)
+[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
 
 ----------
 
@@ -41,7 +45,7 @@ Click the following link to download the driver:
 
 To install the driver, complete the following steps:
 
-  1. Double-click `MapR_Drill_1.3.dmg` to mount the disk image.
+  1. Double-click `MapR Drill 1.3.dmg` to mount the disk image.
   2. Double-click `MapRDrillODBC.pkg` to run the Installer.
   3. Follow the instructions in the Installer to complete the installation process.
   4. When the installation completes, click **Close.**
@@ -59,7 +63,7 @@ To check the version of the driver you installed, use the following command
on t
     $ pkgutil --pkg-info mapr.drillodbc  
 
     package-id: mapr.drillodbc
-    version: 1.3.0 (You may see 3.52.12.)
+    version: 1.3.8 (You may see 3.52.12.)
     volume: /
     location: 
     install-time: 1433465518  
@@ -67,6 +71,8 @@ To display information about the iODBC driver manager installed on the machine,
 
     /usr/local/iODBC/bin/iodbc-config
 
+
 ### Next Step
 
 [Configuring ODBC on Mac OS X]({{ site.baseurl }}/docs/configuring-odbc-on-mac-os-x/).
+

http://git-wip-us.apache.org/repos/asf/drill/blob/ee71b646/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
index 26c000e..dfeeb65 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md
@@ -1,11 +1,14 @@
 ---
 title: "Installing the Driver on Windows"
-date: 2017-02-24 20:28:56 UTC
+date: 2017-05-30 23:11:55 UTC
 parent: "Installing the ODBC Driver"
 ---
 The MapR Drill ODBC Driver installer is available for 32- and 64-bit
-applications on Windows. Both versions of the driver can be installed on a 64-bit
-machine. 
+applications on Windows®. On 64-bit Windows operating systems, you can execute both 32-
and 64-bit applications. However, 64-bit applications must use 64-bit drivers, and 32-bit
applications must use 32-bit drivers. Make sure that you use the driver version that matches
the bitness of the client application machine. 
+					
+  * MapR Drill 1.3 32-bit.msi for 32-bit applications
+  * MapR Drill 1.3 64-bit.msi for 64-bit applications
+
 
 Install the MapR Drill ODBC Driver on a system that meets the system requirements. 
 
@@ -14,12 +17,13 @@ Install the MapR Drill ODBC Driver on a system that meets the system requirement
 Each computer where you install the driver must meet the following system
 requirements:
 
-  * The 64-bit editions of the following operating systems are supported:
-    * Windows® 8 and 8.1
-    * Windows® 7 Professional
-    * Windows® Server 2008, 2013 R2
+  * One of the following operating systems are supported:
+    * Windows Vista, 7, 8, or 10
+    * Windows Server 2008 or later
+  * 75 MB of available disk space
   * .NET Framework 4.5, installed and enabled by default on Windows 8 and later
-  * 60 MB of available disk space
+  * Visual C++ Redistributable for Visual Studio 2013 installed (with the same bitness as
the driver that you are installing)
+ 
   * The client must be able to resolve the actual host name of the Drill node or nodes from
the IP address. Verify that a DNS entry was created on the client machine for the Drill node
or nodes.   
 If not, create an entry in `\Windows\system32\drivers\etc\hosts` for each node in the following
format:  
 
@@ -34,10 +38,10 @@ To install the driver, you need Administrator privileges on the computer.
 
 ## Step 1: Download the MapR Drill ODBC Driver
 
-Download the installer that corresponds to the bitness of the client application from which
you want to create an ODBC connection:
+Download the installer that corresponds to the bitness of the client application from which
you want to create an ODBC connection. Version 1.3.8 is the current version.
 
-* [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3_32-bit.msi)
 
-* [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3_64-bit.msi)
+* [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
 
+* [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
 
 ----------
 
@@ -54,20 +58,18 @@ Download the installer that corresponds to the bitness of the client application
 
 ## Step 3: Verify the installation
 
-To verify the installation, perform the following steps:
+To verify the installation on Windows 10, perform the following steps:
 
-1. Click **Start**, and locate the ODBC Administrator app that you just installed.  
-   Installing the ODBC Administrator installs Drill Explorer and the Tableau TDC file. For
example, on Windows 8.1 in Apps, several apps appear under MaprDrill ODBC Driver 1.0:
-   ![]({{ site.baseurl }}/docs/img/odbc-mapr-drill-apps.png)
+1. Go to **Settings** and enter **odbc**. Select ***Setup ODBC data sources <version>***.
 
-2. Click the ODBC Administrator app icon.
-   The ODBC Data Source Administrator dialog appears.
+2. The ODBC Data Source Administrator <version> dialog appears. Click the **System
DSN** to view 
+   the MapR Drill data source. 
    ![]({{ site.baseurl }}/docs/img/odbc-user-dsn.png)
+
 3. Click the **Drivers** tab and verify that the MapR Drill ODBC Driver appears in the list
of drivers that are installed on the computer.
    ![]({{ site.baseurl }}/docs/img/odbc-drivers.png)
 
 You need to configure and start Drill before [testing]({{site.baseurl}}/docs/testing-the-odbc-connection/)
the ODBC Data Source Administrator.
 
-
 ### Next Step 
 [Configuring ODBC on Windows]({{ site.baseurl }}/docs/configuring-odbc-on-windows).

http://git-wip-us.apache.org/repos/asf/drill/blob/ee71b646/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
index 2461a87..93a35c6 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
@@ -1,6 +1,6 @@
 ---
 title: "Connecting Drill Explorer to Data"
-date:  
+date: 2017-05-30 23:11:55 UTC
 parent: "Using Drill Explorer"
 ---
 The way you start Drill Explorer differs depending on your platform, but regardless of the
platform, Drill must be running. 
@@ -12,43 +12,47 @@ You need an X-11 XDisplay to use Drill Explorer on Linux. Run the DrillExplorer
 ## Connecting Drill Explorer to Data on Mac OS X
 
 1. On a node that is running Drill, run Drill Explorer.  The Drill Explorer app is located
in the `/Applications` directory.  
-   The Drill Explorer console appears.  
+   The Drill Explorer console appears. 
+ 
 2. Click **Connect** on the console.  
    The Drill Explorer dialog appears.  
    ![sample mapr drill dsn]({{ site.baseurl }}/docs/img/explorer-connect.png)
+
 3. If you connect through a DSN, on the ODBC DSN tab, select the name of the DSN you configured.
For example, select Sample MapR Drill DSN.  
    Alternatively, if you use a DSN-less connection, on the Advanced tab, type a connection
string in the text box. For example, type the following connection string:  
          DRIVER=MapR Drill ODBC Driver;AdvancedProperties={HandshakeTimeout=0;QueryTimeout=0;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,
INFORMATION_SCHEMA;};Catalog=DRILL;Schema=;ConnectionType=ZooKeeper;ZKQuorum=192.168.39.43:5181;ZKClusterID=drillbits1
-5. If you set the [AuthenticationType property]({{ site.baseurl }}/docs/odbc-configuration-reference/#configuration-options)
to Basic Authentication, which enables impersonation, respond to the prompt for a user name
and password.
+5. If you set the [AuthenticationType property]({{ site.baseurl }}/docs/odbc-configuration-reference/#configuration-options)
to Plain or Basic Authentication, which enables impersonation, respond to the prompt for a
user name and password.
 4. Click **Connect** in the dialog.  
    In the Schemas panel, the [schema]({{ site.baseurl }}/docs/odbc-configuration-reference/#schema)
for the connected data source appear. For example, the default schema is `dfs`, which points
to the local file system on your machine.  
    ![explorer schemas]({{ site.baseurl }}/docs/img/explorer-schemas.png) 
 
 ## Starting Drill Explorer on Windows
 
-You can start Drill Explorer from Apps or from the ODBC Administrator.
+In Windows 10, you can start Drill Explorer from the Start menu or from the ODBC Data Source
Administrator.
 
-To start Drill Explorer from Apps:
+To start Drill Explorer from the Start menu:
 
-1. Click **Start**, and locate the MaprR Drill ODBC Driver 1.0 app group in Apps.
-   The MapR Drill ODBC Driver 1.0 group includes Drill Explorer.
-   ![]({{ site.baseurl }}/docs/img/odbc-user-dsn.png)
+1. Click **Start**, and locate MaprR Drill ODBC Driver <*version*>. 
+   
+   ![]({{ site.baseurl }}/docs/img/winstart.png)
 
 2. Click **Drill Explorer**.
-   The ODBC Connection dialog appears.
-3. Select the DSN that you want to explore. For example, select the sample MapR ODBC Driver
for Drill DSN.
-   ![]({{ site.baseurl }}/docs/img/odbc-explorer-connect.png)
-   Drill Explorer appears.
+   
    ![]({{ site.baseurl }}/docs/img/odbc-explorer-win.png)
 
-To start Drill Explorer from the ODBC Administrator:
+3. Select the DSN that you want to explore. For example, select MapR Drill and click Connect.
+   
+To start Drill Explorer from the ODBC Administrator in Windows 10:
 
-1. In ODBC Administrator, on the **System DSN** tab in System Data Sources, a DSN. For example,
select the sample MapR ODBC Driver for Drill DSN.  
+1. In the Settings field, enter **odbc**. Select a version and the ODBC Data Source Administrator
<version> appears. 
+   
    ![]({{ site.baseurl }}/docs/img/odbc-configure1.png)
-   Alternatively, if you set up a user DSN, select **User DSN**, and select a DSN.
-3. Click **Configure**.  
-   The DSN Setup dialog appears showing the configured properties.  
+   
+3. Click **System DSN**. Select MapR Drill and click Connect. 
+   The DSN Setup dialog appears showing the properties.  
+   
    ![]({{ site.baseurl }}/docs/img/odbc-configure2.png)
+
 4. Click **Drill Explorer** at the bottom of the dialog.
    Drill Explorer appears.
 


Mime
View raw message