myMSTR.com

ODBC

Open Data Base Connectivity, a standard database access method
developed by the SQL Access group. The goal of ODBC is to make it possible to
access any data from any application, regardless of which database management system (DBMS) is
handling the data.

Why we use ODBC

The Open Database Connectivity (ODBC) standard is a
common application programming interface for accessing data files. In other
words, ODBC allows you to move data back and forth easily between ODBC
compliant applications. So, for example, you can easily extract data from a
Microsoft Excel spreadsheet or Paradox database without having to go through
any tedious translation procedure. With ODBC, all you have to do is specify the
type of file you are accessing and the data you want, and the ODBC driver will
do the rest of the work.

Types

There are two types:

    32-bit

    64-bit

NOTE:
MicroStrategy allows only 32-bit drivers. By default
Microstrategy has some drivers inbuilt. In some cases we do not find all the drivers.
So we should install.

Problem

When we have a 64-bit version of the Microsoft Windows operating system.
We should install 64-bit drivers only but Microstrategy supports 32-bit drivers
only. So when we install 64-bit drivers odbc does not invoke the drivers.

Solution

To overcome this problem 64-bit ODBC Administrator
tool can be invoked from c:/windows/system32/odbca32 to manage user DSNs and
system DSNs that are used by 64-bit processes. On a 64-bit operating system,
the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64)
processes.

INSTALLATION
STEPS TO CONFIGURE A 32-BIT ODBC DRIVER ON A 64-BIT WINDOWS 2008 R2 SERVER FOR
TERADATA.

1. Download the ODBC driver for the version of Teradata that is
installed. The following site should have the appropriate driver: http://www.teradata.com/DownloadCenter/Forum90-1.aspx

NOTE: the TTU 12.0 Windows-i-386 tdodbc.12.00.00.07 driver
returns an error with the terasso library when the driver is selected in the
ODBC Data Source Administrator. This driver is not supported on Windows Server
2008 R2.

Download the TTU 13.0 Windows-i386 tdodbc.13.10.00.01 driver
from the web site above. Teradata 13 ODBC driver is backward compatible with
Teradata 12. The remaining instructions are for installing the Teradata 13 ODBC
driver and are working on a Teradata 12 installation.

NOTE: the following steps must be performed by a user with
administrative rights to the computer on which the install is being performed.

2. The download file is a zipped file and should be saved on the
hard drive of the machine on which it is to be installed. The zipped file
contains three components that must be installed in the following order:
Teradata GSS Client, ICU Library and ODBC driver.

3. Extract all from tdodbc__WINDOWS_i386.13.00.00.00. Select the directory in
which the zipped file is located from the Browse window. For ease of locating
the files for the components, create a subdirectory for each of two components
(GSS, ICU)

4. Extract all from TeraGSS__windows_i386.13.00.00.00 into the GSS subdirectory
by selecting it in the Browse window during the install. Right click the
setup.exe icon and choose “Run as Administrator” to install.

5. Extract all from tdicu__windows_i386.13.00.00.00 into the ICU subdirectory
by selecting it in the Browse window during the install. Open the DISK1
directory. Right click the setup.exe icon and choose “Run as Administrator” to
install.

6. Navigate to the directory in which the original zipped file was stored.
Right click on tdodbc__windows_i386.13.00.00.00 and choose “Run as
Administrator” to install the ODBC driver.

7. Navigate to the c:\Windows\SysWOW64 directory. Click on the odbcad32
application. This will open the ODBC Data Source Administrator for 32-bit
drivers on the 64-bit server. NOTE: The ODBC Data Source Administrator that is
located by clicking Start and Administrative Tools will only create 64-bit ODBC
connections.

8. Click on the System DSN tab

9. Click on Add to create a new Data Source

10. Select Teradata then click Finish

11. Enter the Data Source name, Description and the Name or IP address of the
Teradata Server to which the connection is to be made. Click OK

12. Your 32-bit ODBC data source is now ready for use