Database Reference
In-Depth Information
SSIS. The other approach is to use a connection string that contains all the
parameters fortheconnection. This option isalittle more complex tosetup,
but it makes your SSIS packages more portable because they don't rely on a
DSN being set up on the local computer, and you don't have to worry about
setting up both 64-bit and 32-bit versions of the DSN.
The process for setting up either is fairly similar:
1. You start by opening up the ODBC Administrator application, using the
32-bit or 64-bit version.
2. Select the DSN type from the tabs across the top of the administrator
interface (see
Figure 8.1
)
.
Figure 8.1
ODBC Administrator interface.
3. Choose the System DSN if you want to store the connection information
on the computer, and choose the File DSN if you want a portable
connection string. The process differs only in that with a File DSN you
have to select a location to store the file. This example will proceed with
a file DSN setup because that is a more common scenario.
4. Add the new connection by using the Add button, and choose the
Hortonworks Hive ODBC driver from the resulting wizard.
5. At the next step, choose a location to store the File DSN. You will be
opening this file in just a moment, so use an easily accessible location,
like the desktop.
