Deploying the Meta Data

The source code is deployed from OWB to the Database using the build commands below.

  1. Open a command prompt and navigate to...\Reporting\components. Run "build owb.deploy.all". It may take up to an hour for these commands to complete.

    Please note that this command in turn runs each of these commands:

    • "build owb.deploy.runtimesetup"
    • "build owb.deploy.staging"
    • "build owb.deploy.central"
    • "build owb.deploy.datamarts"
  2. It is necessary to verify via the control center that these commands ran successfully.
  3. Open the OWB Design Center, go to the tools menu and click Control Center manager. Note it is necessary to expand the Reporting project otherwise this option will be grayed out. The right-hand pane displays the deployment details with the deployment status. Ensure that the green tick is present for all the ETL's that have been deployed.

    Please ignore the Drop Errors - these occur because OWB tries to drop the ETL's before deploying them and they do not exist on the database yet.

  4. In order to check that the deploy commands have executed successfully carry out the following for each schema.
  5. Expand the mapping sections for the Staging schema; right click on the S_ETLCONTROL_ETL and start. If this executes successfully the S_ETLCONTROL table will be populated.

    Please see the Troubleshooting Section for issues on the deploy command.