How to Install and Configure the Hortonworks ODBC driver

The Hortonworks ODBC driver enables you to access data in the Hortonworks Data Platform from Business Intelligence (BI) applications such as Microsoft Excel, Tableau, Click View, Micro Strategy, Cognos, and Business Objects.

System Requirements:
Red Hat® Enterprise Linux® (RHEL) 5.0, CentOS 5.0 or SUSE Linux Enterprise Server (SLES) 11.
Both 32 and 64 bit editions are supported.
45 MB of available disk space.
An installed ODBC Driver Manager, for example:
o iODBC 3.52.7 or above
o unixODBC 2.3.0 or above
 
Installation:
There are two versions of the driver for Linux :
hive-odbc-native-32bit-<version>-<release>.i686.rpm for 32-bit
hive-odbc-native-<version>-<release>.x86_64.rpm for 64-bit
 
Configuration:
ODBC driver managers use configuration files to define and configure ODBC data
sources and drivers.
By default, the configuration files reside in the user’s home directory. The configuration files are:
.odbc.ini –The file used to define ODBC data sources (required)
.odbcinst.ini –The file used to define ODBC drivers (optional)
.hortonworks.hiveodbc.ini–The file used to configure the Hortonworks Hive ODBCDriver (required)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s