Skip Headers
Oracle® Warehouse Builder Installation and Administration Guide
11g Release 2 (11.2) for Windows and Linux

Part Number E10579-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

8 Managing Configurations

This section discusses the design issues associated with multiple configuration environments.

This section includes the following topics:

About Configuration Management

When you install Warehouse Builder and create a new repository, you have a default project with a single automatic default configuration, DEFAULT_CONFIGURATION. See Figure 8-1 and note that each new project has an automatic DEFAULT_CONFIGURATION. You can observe this by expanding the Configurations node in Project Navigator. Note also that the active configuration appears on the toolbar as DEFAULT_CONFIGURATION.

This default configuration contains the default physical properties of all the data objects in the project; these properties are necessary for deployment. As a single entity, the DEFAULT_CONFIGURATION enables deployment to the default control center, DEFAULT_CONTROL_CENTER, and default agent, DEFAULT_AGENT, which are necessary to the internal workings of Warehouse Builder.

When you define a new configuration, OWB adds it to the list of configurations. With multiple configurations, you can specify how the same logical object may be defined across various environments: you can define multiple physical properties and deployment details for a single table, view, or other such object. In this manner, configurations enable you to connect design objects to their realizations.

If you link a configuration to a template, the configuration picks up the default values of the configuration properties from this template; enabling you to override the existing set of configuration values with your own values.

Configurations have several roles in the OWB environment:

Figure 8-1 Oracle Warehouse Builder Configuration Management

Description of Figure 8-1 follows
Description of "Figure 8-1 Oracle Warehouse Builder Configuration Management "

Configuration details are grouped by type, such as performance parameters, storage space for tables, and so on. Because each object type can have a number of configuration properties that are not used or have general defaults, OWB uses Configuration Templates to simplify how much the user needs to do.

Configuration Templates may be used to override automatic default values for configuration properties and to flag the properties for either the general set or the advanced set. For example, one may move the less frequently used configuration properties to the advanced set.

Creating Configurations Templates

To create a configuration template:

  1. In the Globals Navigator, select Configuration Templates.

  2. Right-click Configuration Templates, and select New Configuration Template.

    Description of new_config_temp_01.gif follows
    Description of the illustration new_config_temp_01.gif

    The Create Configuration Template wizard opens. Note that on every screen of the wizard, you have the option of clicking Help to get more information.

  3. On the Name and Description screen, enter the Name of the new configuration template, and optionally, its Description.

    Click OK.

    Description of new_config_temp_02.gif follows
    Description of the illustration new_config_temp_02.gif

  4. The new Configuration Template appears in the right pane of the OWB console.

    Note that when you create a new configuration template, its default setting of advanced options is initially set to be identical to previously created configuration templates.

    Description of new_config_temp_03.gif follows
    Description of the illustration new_config_temp_03.gif

Editing Configuration Templates

To edit the configuration values in a template, use the Configuration Template Editor, which allows you to set the configuration properties of objects to Advanced, and to override the existing configuration defaults.

Note that the configuration template editor can show the different templates side by side, to make it easier to compare and edit multiple templates.

To edit a configuration template:

  1. In the Globals Navigator, under Configuration Templates, click the Manage Configuration Template Columns icon.

    Description of edit_config_temp_01.gif follows
    Description of the illustration edit_config_temp_01.gif

  2. In the Select Templates window, select the templates you want to edit.

    Click OK.

    Description of edit_config_temp_02.gif follows
    Description of the illustration edit_config_temp_02.gif

  3. Click the Expand All icon.

    Description of edit_config_temp_03.gif follows
    Description of the illustration edit_config_temp_03.gif

  4. Make changes to the side-by-side templates.

    Description of edit_config_temp_04.gif follows
    Description of the illustration edit_config_temp_04.gif

Activating Configurations

To activate a configuration:

  1. In the Project Navigator, select a project and expand its navigation tree.

  2. Expand the Configurations folder.

  3. Select a configuration.

  4. Right-click the selected configuration; from the menu, select Set As Active Configuration.

    Surrounding text describes set_config_01.gif.

All changes that you make to the configuration parameters of objects are saved in this configuration. If you switch to the previous configuration, these parameters show the settings of that configuration.

The Control Center service and Control Center Agent associated with this configuration are now set; they manage all future deployments or executions.

Configuring Objects

When you choose the Configure option for any object, it shows the set of configuration properties with the default values that are defined in the Configuration Template. You can expand the Property tree to see all properties.

Configuration defines the physical characteristics of data objects. These may include defining a tablespace and setting performance parameters in the configuration of a table.

Note that you may change the configuration of an object at any time before deployment, and that it is possible to define multiple configurations for the same set of objects. This is particularly useful when deploying to multiple environments, such as test and production.

All objects have a parameter deployable, which is selected by default. To prevent an object from being deployed, deselect this parameter.

To configure an object:

  1. In the Project Navigator, select the object to configure.

  2. In the File menu, click Configure.

    Surrounding text describes configuration_01.gif.

    The Configuration editor is displayed.

  3. Select a parameter to display and edit its value in the right-side panel.

    Description of configuration_02.gif follows
    Description of the illustration configuration_02.gif

  4. Click Help for additional information.

As an Amazon Associate I earn from qualifying purchases.