Setting up the developer system

Linux The developer system is used for creating, running, and viewing reports. To be able to run the extract, transform, and load (ETL) jobs, you must install certain environment variables and libraries.
About this task
On the developer system:
  1. If the database is to be hosted locally, install the server for the database to host the data warehouse.

    For up-to-date information about installing and configuring the database server and client, see the documentation for the database product.

  2. Install the database client for the database hosting the data warehouse.
  3. To be able to run the ETL jobs from the developer system, install the required environment variables and library.
    1. Add the following commands to the profile of your user account, for example, .bashrc
      export PATH="<Insight install location>/cognos/bin:$PATH"
      export COG_ROOT="<Insight install location>/cognos"
      export JAVA_HOME="<Insight install location>/dataconfig/jdk/jre"
      export LD_PRELOAD="/usr/lib/libfreetype.so $LD_PRELOAD" 
    2. Copy the [DB2_installation_directory]/lib32/libdb2.so file to the [rational_insight_installation_directory]/dataconfig/odbc/lib directory.
  4. Enable non-root users to run the ETL jobs.

    If the installation is through the root user account, only the root user has the permissions for running the ETL jobs. To allow other users to run these jobs:

    1. Log in as a non-root user and add the following variables.
      export LD_LIBRARY_PATH=$INSTALL_FOLDER/AppServer/java/jre/bin
      export PATH=$INSTALL_FOLDER/AppServer/java/jre/bin/classic
      export COG_ROOT=$INSTALL_FOLDER/cognos/ 
    2. If the Oracle Server is used for the databases, set the ORACLE_HOME and ORACLE_BASE values.

Feedback