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
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
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)

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s