This discussion is archived
1 Reply Latest reply: Aug 7, 2012 9:09 AM by David Allan RSS

Deployment to file

KurtGeens Newbie
Currently Being Moderated
Is it possible to deploy a warehouse builder project to a script or file, and use this file to remotely deploy the project on a client database?

We have a centralised design repository, which is used to build a standardised data warehouse for several customers. The same project is deployed to various sites using the location management of OWB, which works brilliantly for the given situation. However, a new customer now has very rigid security policies, one of them being that they don't allow remote VPN access to their database servers. Therefore it's not possible to deploy from our central design repository to their target database.

It would be convenient if it was possible to deploy to a file of some sort, which could be ran as a script at the customer site against the runtime control center user. However, such a possibility does not seem to be included in the OWB client... Does anyone have an idea how to achieve deployment in such a set up, that does not include duplicating our design repository at the customer site?
  • 1. Re: Deployment to file
    David Allan Guru
    Currently Being Moderated
    If it is pure mappings and PLSQL the following is an approach that is possible;
    https://blogs.oracle.com/warehousebuilder/entry/headless_operation_owb_code_generation_going_it_alone

    Otherwise a repository is needed and could be scripted using OMB - which is a route that others take.

    Cheers
    David

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points