Common Setup Steps

Please complete these steps, which are common to both types of configuration. Refer to Appendix B for full list of variables specified below:

  1. In the BIApplication.properties file ensure the environment.owbconfig.remotedatamanagerdir variable is set correctly.

    If the Data Manager folder is on the local machine then leave it blank or it will cause an error.

    If the staging, central and datamart schema's are being created on a remote server then the Data Manager folder and contents will need to be copied to this server after the build staticdata command has been run, refer to Section 'Create OWB Repository and target schema's', Step 14. You then need to set the environment.owbconfig.remotedatamanagerdir variable to the path of the Data Manager folder on the remote server, using the java convention for path separators (\\),e.g. Reporting\\bin\\data_manager\\. Please ensure that the trailing \\ is added or it will cause an error.

  2. In the BIApplication.properties file ensure the environment.owb.oracleinstalled variable is correctly set. E.g. environment.owb.oracleinstalled=true. Only set this to false if there is no Oracle database on the server where OWB has been installed. Otherwise set this to true.
  3. If setting up a Development Environment, please ensure that the 2 BIApplication.properties autogrant variables are set to true. Please see Appendix G for more information, and also for information on setting up the privileges on non-development environments.
  4. If setting up a Development Environment, please ensure that the variable environment.databases.curam.updatenulls.autorun is set to true. Please see Appendix H for further information on last-written columns and setting up privileges on non-development environments.
  5. In Windows, the environment variables are set in the Advanced System Properties. In UNIX, the environment variables are set in the .profile file (Please see Appendix R for sample .profile file). Ensure the following environment variables exist, are correctly set and it is very important that they are spelled correctly:

    REPORTING_DIR - should be set to the location of the Reporting directory, e.g. Windows: C:\IBM\Curam\development\Reporting, UNIX: /home/username/Curam/Development/Reporting

    ANT_HOME - e.g. Windows: C:\apache-ant-1.8.2 or C:\ant182, UNIX: /opt/JavaTools/apache-ant-1.8.2

    OWB_HOME - e.g. Windows: C:\oracle\product\11.2.0\db_1\owb for Oracle 11gR2. Ensure that when this environment variable is set that the path %OWB_HOME%\bin\win32 is correct. (OWB_HOME dependencies: OMBPLUS, loadjava.bat & jdk). UNIX: /oracle/database/oracle112/owb

    JAVA_HOME - ensure this is set to the jdk of the java location. e.g. Windows: C:\jdk1.6.0. UNIX: /ibm/was/AppServer/java. This MUST be java 1.6 or higher.

    JAVA_HOME_RDBMS - should be set to %ORACLE_HOME%\jdk.

    CURAMSDEJ - e.g. Windows: C:\IBM\Curam\development\CuramSDEJ, UNIX: /home/username/Curam/Development/CuramSDEJ

Parent topic: BIApplication.properties, BIBootstrap.properties and Environment Variable Setup