SQL Interface and Hybrid Analysis on UNIX

The following list is an overview of tasks required to run SQL Interface or Hybrid Analysis on UNIX:

  1. Confirm that you meet system requirements. See Supported ODBC drivers and relational data sources.
  2. Install the Analytic Server.
  3. From the $ARBORPATH directory, run inst-sql.sh to link SQL Interface to the ODBC driver. See Linking SQL Interface to ODBC drivers on UNIX for detailed information and instructions.
  4. If using Hybrid Analysis, set the $ODBCINI environment variable to the path and file name of the ODBC data source configuration file.

    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.

  5. Edit $ARBORPATH/bin/.odbc.ini to include the correct driver and data source names.
  6. If Teradata is the data source, see Setting up Teradata on UNIX for additional steps required before running SQL Interface.

What happens during installation on UNIX

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.

Linking SQL Interface to ODBC drivers on UNIX

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:

Setting up Teradata on UNIX

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:

  1. The Teradata ODBC is installed on the computer where the Analytic Server is running.
  2. The environment variable is updated to point to the Teradata ODBC. See Supported ODBC drivers and relational data sources for information on tested and supported SQL Interface platforms and ODBC drivers.
  3. Set the environment required to run Teradata.

Completing configuration tasks on UNIX

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.

Setting library paths on UNIX

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.

Setting the ODBCINI environment variable on Linux

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.

Editing ODBC configuration files

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.

Editing the ODBC configuration file for Data Direct Oracle drivers 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.