Database Reference
In-Depth Information
Figure 8-4.
ODBC Data Source Administrator
■
there are two versions of the oDBC Data source administrator Ui: one for 32-bit (
%windir%\SysWOW64\
odbcad32.exe
) and one for 64-bit (
%windir%\System32\odbcad32.exe
). You'll likely want to create both 32-bit and 64-bit
Dsns—just make sure that the same name is used for both versions. at a minimum, you'll need to register a 32-bit Dsn
to use when creating your ssis package in the designer in Chapter 10.
Note
The presence of the Microsoft Hive ODBC driver under the list of available ODBC drivers ensures that it has been
installed successfully.
Testing the Driver
Once the driver is installed successfully, the next step is to ensure that you can make a connection to Hive using the
driver. First, create a System DSN. In ODBC Data Sources Administrator, go to the
System DSN
tab and click on the
Add
button as shown in Figure
8-5
.
