This is the documentation for Cloudera ODBC Connector for Microstrategy 2.0.
Documentation for other versions is available at Cloudera.com.

Driver Installation and Configuration for Windows

The Windows version of this driver is supported on Microsoft Windows Server 2008 R2 and Windows 7.
  Note: The Cloudera Connector for MicroStrategy currently only supports Kerberos on Linux, not on Windows.
Follow these steps to install and configure the ODBC driver on Windows systems:
  1. Download the driver from the Cloudera downloads site (see Cloudera ODBC Connectors downloads page).
  2. Run the downloaded installer on each applicable system:
    • To install through the installation wizard:

      Run the downloaded .exe file, from the command line or by double-clicking its icon. You will need to accept the license agreement, and accept or modify the installation location. The driver is a 32-bit version that can also run on a 64-bit system.

    • (Optional) To deploy on multiple servers, install silently from the command line:
      Run the install executable as: 
      Install_exe /S [/D="Dir_to_install"]
      For example, to install in the default location: 
      ClouderaHiveODBCSetup_v2_00.exe /S
      Or, to install in a specific directory: 
      ClouderaHiveODBCSetup_v2_00.exe /S /D="C:\Program Files (x86)\Hive ODBC"
      The license is accepted automatically when you install in silent mode.
  3. After the driver is installed, find and run the ODBC Data Source Administrator.
    1. On some systems, the 32-bit version of the ODBC administrator is located at %systemdrive%\Windows\SysWoW64\odbcad32.exe.
    2. If you do not find the administrator utility in its default location, type odbc administrator into the Search box of the Windows Start menu.
    3. In the search results, double-click ODBC Administrator. (Note that on a 64-bit Windows system, you must select the 32-bit binary, not the 64-bit binary.)
  4. In the ODBC Data Source Administrator window, click the System DSN tab, then click Add....
  5. Select the Cloudera ODBC Driver for Apache Hive and click Finish. (This assumes you have first installed the driver per steps 1 and 2 above). The Hive ODBC DSN Configuration dialog box appears.
  6. Fill in the fields with the the details of your data source. The data source could be a Cloudera Impala server or an Apache Hive server.
    • Enter the hostname or IP address and the port number. To connect to Impala, specify the details for any node in the cluster that is running the impalad daemon.
    • For Impala, leave the Type field blank when connecting to an Impala node secured with Kerberos authentication, or enter HS2NoSASL for the Type field if the node is not secured by Kerberos. For Hive, always leave the Type field blank.
    • The default port number is 21050 for an Impala node, or 10000 for an Apache Hive server.
    • When connecting to a cluster that has Kerberos authentication enabled, fill in the Kerberos principal for the HiveServer2 or Impala service, for example: 
      node1/hiveserver2@myRelm.com
    • Click OK .

The installation is now complete.

Uninstalling the Driver

The uninstall script is placed in the installation directory (by default, C:\Program Files (x86)\Hive ODBC). To uninstall the driver, run: 
installation_directory/uninstall.exe
To uninstall silently, add the /S option: 
installation_directory/uninstall.exe /S