Configuring the UNIX Environment for Data Access
For the data access technology to work on UNIX systems, the server software’s startup script must be configured.
Open the Startup Script
- Change to the /bin subdirectory in the server software’s
installation directory. For example, at the UNIX prompt type:
cd /usr/local/serverproduct/bin
where /usr/local/serverproduct/bin is the /bin subdirectory of the directory in which the server software is installed.
- Open statsenv.sh with a text editor.
Specify the DataDirect Script
- Search for the first comment that contains the text:
MERANT_ENVIRONMENT_SCRIPT
- Find the line that defines the location of odbc.sh.
- Edit the line so it contains the correct path to your Connect ODBC client installation, and remove the comment character if it has one. For example, change:
# MERANT_ENVIRONMENT_SCRIPT=/usr/slodbc50/5_01_00/odbc.sh
to:
MERANT_ENVIRONMENT_SCRIPT=/usr/myDataAccess/slodbc50/5_01_00/odbc.sh
Add odbc.ini Environment Variable
- Add the following lines after the lines above to create an environment
variable,
ODBCINI
, that allows IBM® SPSS® Statistics Server to find the odbc.ini file:
ODBCINI=ODBCDIR/odbc.ini
export ODBCINI
where ODBCDIR
is replaced
by the path to your Connect ODBC installation directory.
Add Paths to Database Libraries
- Add lines appropriate for your database, usually the database home directory and, if you are not using the Data Direct Wire Protocol drivers, a path to the database libraries. For example, if you are using Oracle on Linux, add the following lines:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/bigdisk/oracle/product/8.1.6/lib
export LD_LIBRARY_PATH
ORACLE_HOME=/bigdisk/oracle/product/8.1.6
export ORACLE_HOME
where /bigdisk/oracle/product/8.1.6 is
replaced by the path to your Oracle installation directory and LD_LIBRARY_PATH
is
the library path variable for your operating system.
Note that the Data Direct Wire Protocol drivers do not require the installation of database client libraries. However, other Data Direct drivers require these libraries.
Save the Startup Script
- Save statsenv.sh.
Edit odbc.ini
- Edit odbc.ini, the ODBC configuration file, so that ODBC data sources can be accessed from IBM SPSS Statistics Server. See the appendix "The UNIX Environment" in DataDirect's DataDirect Connect ODBC Reference (available if you installed the additional DataDirect documentation when you installed Connect ODBC) and the chapters for specific drivers in odbchelp.pdf in the doc subdirectory of your Connect ODBC installation directory.
The change will take effect the next time you start the server software.