
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:
- 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.
- Install the database client for the database hosting the
data warehouse.
- To be able to run the ETL jobs from the developer system,
install the required environment variables and library.
- 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"
- Copy the [DB2_installation_directory]/lib32/libdb2.so file
to the [rational_insight_installation_directory]/dataconfig/odbc/lib directory.
- 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:
- 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/
- If the Oracle Server is used for the databases, set
the ORACLE_HOME and ORACLE_BASE values.