Configuring the driver

Set up the DataStax Hive ODBC driver for access by your BI tool.

Set up the DataStax ODBC driver for access by your BI tool.

Procedure

  1. Click Start Program Files > DataStax Hive ODBC Connector > ODBC Driver Manager.
  2. Click the Drivers tab to verify that the driver is present.


  3. Create either a User or System DSN (data source name) for your BI tool connection.
    1. Click the User DSN or System DSN tab.
    2. Click Add > DataStax Hive ODBC Connector > Finish.
    3. In DataStax Hive ODBC Connector Setup, enter the following:
      Data Source Name The name for your DSN.
      Description Optional.
      Host IP or hostname of your Hive server.
      Port Listening port for the Hive service.
      Database By default, all tables reside within the default database. To check for the appropriate database, use the show databases Hive command.
    4. Click Test.

      The test results are displayed.

      Note: If your DataStax Enterprise cluster is on Amazon EC2, you must open the listing port for the Hive Server. For more information, refer to Installing a DSE cluster on EC2.
  4. To configure the advanced options, see Appendix C in the DataStax Hive ODBC Connector User Guide for Windows:

    Start > Program Files > DataStax Hive ODBC Connector > User's Guide