Database Reference
In-Depth Information
NOTE
This file may be locked by the Hive server, in which case you will get an
“access denied” error when you try to save changes to it. If this
happens, stop the Hive server, save your changes to the configuration
file, and restart it.
Installing the Hortonworks ODBC Driver for Hive
Next, you need to install the Hortonworks ODBC driver for Hive, which
you can download from
http://hortonworks.com/products/hdp-windows/
#add_ons
. You need to install the driver on your SSIS computer. You do not
have to install it on the Hadoop machine. After installing the driver, you can
configureitfromtheODBCAdministratortoolincludedaspartofWindows.
NOTE
Hortonworks provides both 32-bit and 64-bit versions of their ODBC
driver. To use this with SSIS, you'll want to install both versions of the
driver. SQL Server Data Tools (SSDT) is a 32-bit application, so it uses
the 32-bit version of the driver when you are designing SSIS packages.
However, when the package is executed, it is run from a 64-bit process.
At that point, it needs the 64-bit version of the driver to be present.
This is also the most common mode for use in production.
The ODBC Administrator tool also comes in 32-bit and 64-bit versions.
If you want to use a data source name (DSN) to connect to Hive, you
can set it up here. However, you will need to set it up twice, once as
32-bit and once as 64-bit, so that it's available to both types of
applications. Using a connection string for connections eliminates the
need for this.
Configuring the Hive ODBC Connection
You can configure your Hive ODBC connection in two ways. One option
is to configure a DSN. This stores the connection parameter information
locally on the computer and results in a simpler connection configuration in
