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.
- 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="<Common Reporting install location>/cognos/bin:$PATH"
export COG_ROOT="<Common Reporting location>/cognos"
export JAVA_HOME="<Common Reporting location>/dataconfig/jdk/jre"
export LD_PRELOAD="/usr/lib/libfreetype.so $LD_PRELOAD"
- Copy the [DB2_installation_directory]/lib32/libdb2.so file to the [insight_installation_directory]/dataconfig/odbc/lib directory.
Note: The [insight/dataconfig/odbc/lib directory is the intended directory
that needs to be created before copying the file.
Results
For current information about installing and configuring the
database server and client, see the product documentation.