Configure DataDirect Driver Manager on Linux and AIX

Configure DataDirect Driver Manager on Linux and AIX - Aster Client

Teradata Aster® Client Guide

Product

Aster Client

Release Number

7.00

Published

May 2017

Language

English (United States)

Last Update

2018-04-13

dita:mapPath

hki1475000360386.ditamap

dita:ditavalPath

Generic_no_ie_no_tempfilter.ditaval

dita:id

B700-2005

lifecycle

Product Category

Software

Use the following process to configure the DataDirect Driver Manager on Linux and AIX:

Find the DataDirect Driver Manager configuration files under the extracted directory:
```
$ cd stage/clients-odbc-<your_client_os>/DataDirect/setup
```
Copy the odbcinst.ini, odbc.ini, and aster.ini files from the /setup directory to your home directory:
```
$ cp -p * ~
```
Change to your home directory:
```
$ cd
```

Make backups of the files you moved and rename aster.ini to .aster.ini:

$ cp -p aster.ini aster.ini.backup
$ mv aster.ini .aster.ini
$ cp -p odbc.ini odbc.ini.backup
$ cp -p odbcinst.ini odbcinst.ini.backup

Make the following edits to .aster.ini:
1. Set DriverManagerEncoding to UTF-8
2. Set ODBCInstLib to <InstallDir>/DataDirect/lib/libodbcinst.so, replacing <InstallDir> with the folder where the driver is installed.
  For example:
```
[driver] 
DriverManagerEncoding=UTF-8 
ODBCInstLib=<InstallDir>/DataDirect/lib/libodbcinst.so
DriverLocale=en-US
LogLevel=0
ErrorMessagesPath=<InstallDir>/ErrorMessages
```

Modify odbc.ini as follows:

Change the DSN configuration parameters SERVER, UID, PWD, DATABASE and PORT and replace <InstallDir> with the folder where the driver is installed.

[ODBC Data Sources] 
... ...
 asterdsn=AsterDriver 
 [ODBC] 
 ... ... 
 [asterdsn] 
 Driver=<InstallDir>/DataDirect/lib/libAsterDriver.so 
 SERVER=192.206.82.100 
 PORT=2406 
 DATABASE=beehive 
 UID=beehive 
 PWD=beehive

Add this item to the [ODBC] section of odbc.ini:
```
InstallDir=<InstallDir>/DataDirect
```
To support multi-byte characters, add this item to the [ODBC] section of odbc.ini:
```
IANAAppCodePage=106
```

Add the <InstallDir>/DataDirect/lib directory to one of:
- On Linux: LD_LIBRARY_PATH
- On AIX PowerPC: LIBPATH
Export the following values, where <directory_path> is the path to the directory where the files odbc.ini and odbcinst.ini reside:
```
export ODBCHOME=<directory_path>
export ODBCINI=$ODBCHOME/odbc.ini
export ODBCINST=$ODBCHOME/odbcinst.ini
```

Edit the odbcinst.ini file, as shown in this example:

[ODBC Drivers] 
... ...
AsterDriver=Installed 
[ODBC Translators] 
OEM to ANSI=Installed 
[ODBC] 
#This section must contain values for DSN-less connections 
#if no odbc.ini file exists. If an odbc.ini file exists, 
#the values from that [ODBC] section are used. 
[AsterDriver] 
Driver=<InstallDir>/DataDirect/lib/libAsterDriver.so 
IconvEncoding=UCS-4LE