Configuring Data Source Connections Using Native Gateways

You can connect to both Oracle Database and DB2 using native gateways, OCI and DB2 CLI, respectively.

1. Open the obis.properties file located at:

   BI_DOMAIN/config/fmwconfig/bienv/obis

2. Include the appropriate environment variable settings for the database client of your choice. Ensure that you point to the appropriate libraries, depending on whether you are using a 32-bit or 64-bit database.

   DB2INSTANCE=db2user
   IBM_DB_LIB=/scratch/db2user/sqllib/lib
   IBM_DB_DIR=/scratch/db2user/sqllib
   LD_LIBRARY_PATH=/scratch/db2user/sqllib/lib64:/scratch/db2user/sqllib/lib32
   PATH=$PATH:/scratch/db2user/sqllib/bin:/scratch/db2user/sqllib/adm:/scratch/db2user/sqllib/misc
   DB2_HOME=/scratch/db2user/sqllib
   IBM_DB_INCLUDE=/scratch/db2user/sqllib/include
   DB2LIB=/scratch/db2user/sqllib/lib
   

3. Save and close the file.
4. Restart OBIS1.