The following list is an overview of tasks required to run SQL Interface or Hybrid Analysis on UNIX:
On the AIX, Solaris, and HP-UX operating systems, SQL Interface always expects to find the file in $HOME/.odbc.ini and will ignore the value of $ODBCINI. If you are using SQL Interface on Linux, or if you are using both Hybrid Analysis and SQL Interface on any UNIX platform, save the file as $HOME/.odbc.ini and set $ODBCINI to $HOME/.odbc.ini.
The installation program installs the SQL Interface files and additional files, such as ODBC drivers, required to run both SQL Interface and Hybrid Analysis.
The installation program installs DataDirect ODBC drivers files to $HYPERION_HOME/ODBC/Merant/4.2.
When the Analytic Server is installed on UNIX, it creates:
After you install Analytic Server, you must run the shell script inst-sql.sh to enable SQL Interface. The script creates a symbolic link between the SQL Interface library file and the Data Direct ODBC drivers file.
After you install Analytic Server and set up the Analytic Server environment variables, but before running SQL Interface, you must link SQL Interface to the ODBC drivers by running the shell script inst-sql.sh. Running inst-sql.sh ensures that server processes can access the software necessary for SQL Interface.
The inst-sql.sh script uses the odbc.ini, odbcinst.ini, and template files in the $HYPERION_HOME/common/ODBC/Merant/4.2/lib directory to create a set of files that points Analytic Services to the correct driver product.
The script performs the following tasks for you:
You must be able to connect to Teradata from the Analytic Server computer before SQL Interface or Hybrid Analysis can work.
Confirm that the following tasks have been performed:
After installing DB2 OLAP Server and running inst-sql.sh (if you are planning to use SQL Interface), you are ready to complete the configuration tasks. These tasks are required for both SQL Interface and Hybrid Analysis.
To run SQL Interface or Hybrid Analysis on UNIX, you must add the $HYPERION_HOME/common/ODBC/Merant/4.2/lib directory to the library path. If the installation of DB2 OLAP Server is an upgrade to a pre-existing installation, you may not have to reset the library path.
Unlike other supported UNIX platforms, on Linux, you must set the ODBCINI environment variable to use SQL Interface.
To use Hybrid Analysis, you must set the ODBCINI environment variable on all supported UNIX platforms.
To complete the ODBC driver setup, you must modify $ODBCINI to include the correct driver and data source names. This is required for both SQL Interface or Hybrid Analysis. See the following examples for the IBM DB2 driver on AIX and for the Data Direct DB2 driver on Solaris.
To set up the .odbc.ini file for Oracle 8 on Solaris, modify $ODBCINI to include the correct driver and data source name. For example:
[ODBC Data Sources]
Oracle8=MERANT 4.20 Oracle 8 Driver
[Oracle8]
Driver=/$HYPERION_HOME/common/ODBC/Merant/4.2/lib/ARor819.so
Description=Oracle8
ServerName=name
Where name is the appropriate Oracle server name.