3
Upgrading Metadata from Warehouse Builder 2.x to Oracle9i Warehouse Builder

This chapter provides instructions for upgrading metadata from a previous version of Warehouse Builder to Oracle9i Warehouse Builder.

If you are upgrading from Warehouse Builder 3i, you can upgrade repository objects using the Warehouse Builder Repository Assistant. This option is only valid if you are upgrading from Warehouse Builder 3i to Oracle9i Warehouse Builder. It is not valid for upgrading Warehouse Builder versions 2.x.

The following topics are covered:

• Overview

• Step 1. Preparation: Export Metadata from Your Existing Warehouse Builder Repository

• Step 2. Install Warehouse Builder in a Separate Directory

• Step 3. Run the MDL File Upgrade Utility

• Step 4. Import Metadata into the New Warehouse Builder Repository

For information on migrating the runtime from Warehouse Builder 2.x, see "Install Warehouse Builder Runtime Objects" on .

Overview

To upgrade your metadata from an older version of Warehouse Builder to Oracle9i Warehouse Builder, use the new Metadata Loader File Upgrade utility. This tool enables you to upgrade any MDL file created from Warehouse Builder 2.0.4.78 repository or higher to the latest version of Warehouse Builder.

Before you perform the upgrade, be aware of the following:

• The current version of this utility does not support PeopleSoft modules. These files are skipped during the upgrade and if these entities are referenced within any mappings, Warehouse Builder displays an error message stating that the entity type is not supported for this version.

• Files from SAP sources version 2.1 can be upgraded to Oracle9i Warehouse Builder using the MDL utility.

• SQL*Loader mappings with variables and parameters are converted to group attributes of the Data Generator stage component.

• Control characters in descriptions are replaced with spaces.

• Configuration names in free format in 2.1 (for example, indexes) are changed to conform to the database naming standards.

• All 2.1.1 file and data warehouse objects are upper-cased. All Oracle installed modules remain unchanged, except for installed modules that are upper-cased.

• Index columns must reference an actual entity, otherwise the upgrade generates a list of columns that do not satisfy this requirement. If you do not fix this error before upgrading, the upgraded file will fail on import into Warehouse Builder.

To upgrade your metadata from a previous version of Warehouse Builder, follow the steps listed below.

Step 1. Preparation: Export Metadata from Your Existing Warehouse Builder Repository

To upgrade your current repository, you must export each project to Metadata Loader (MDL) files. Then, install Warehouse Builder, convert the MDL files using the Upgrade Utility, and import the files into Warehouse Builder.

To export existing metadata into an MDL file:

1. Use the Warehouse Builder client to log into the Project you want to export.

2. From the Project menu, choose Export Metadata.

   You can choose how you want to export the files within a project. For example, if you are exporting three source modules and two target modules, you can choose to export them separately or all together.

   The Metadata Loader assigns a path and file name to the exported MDL file. Make a note of the path and filename for each module you export, or you can type a meaningful pathname and filename for the new MDL files and log files. The filename you assign must end with .mdl.

   Note: You must keep your old repository until the entire upgrade process has been performed and tested.

Step 2. Install Warehouse Builder in a Separate Directory

To install a new Warehouse Builder system in parallel to the existing one:

1. Install the new version of the Warehouse Builder software in a separate Oracle Home.

2. Create a new Warehouse Builder repository. (See "Install the Warehouse Builder Repository" on in this manual.)

Step 3. Run the MDL File Upgrade Utility

To perform the MDL File Upgrade, do one of the following:

• Use the MDL File Upgrade Wizard if you exported each project as a single MDL file.

• Use the command line if you exported a project as multiple MDL files.

  Note: The MDL Upgrade Utility Wizard converts your files directly to the current version of Warehouse Builder. If you want to upgrade to an intermediate version, you must use the command line utility.

The Upgrade utility eliminates the need to have your old repository running on the same system as your new Warehouse Builder repository or for older versions of Warehouse Builder to be installed on your system.

Run the MDL File Upgrade Wizard

To access the MDL File Upgrade wizard:

1. Go to the program group for Warehouse Builder and select Oracle9i Warehouse Builder MDL File Upgrade Utility.

   The MDL File Upgrade Wizard Welcome page displays.

2. Click Next.

   The Source page displays.

3. Click Browse to select the MDL file you want to convert to the latest version of Warehouse Builder. The order in which you select these files is important. For example, entities must be upgraded before mappings.

   Note: To upgrade multiple MDL files, Warehouse Builder provides a command line utility. You will receive an error message if you select multiple files for upgrade in this Wizard.

4. Click Next.

The Target page displays.

Click Browse to select the directory where the output files will be stored on your system.

Click Next.

The Target page prompts you for your log file location. You can select the default path or click Browse to choose a new location.

Click Next.

The Summary page displays.

Review the upgrade information including the source and destination of the files you have selected for upgrade.

Click Finish to upgrade the selected files.

The Conversion Progress panel displays the status of the upgrade. At the end of the process, you receive an upgrade successful message.

Warnings and Error Messages

After an upgrade, check the log file for warnings and errors.

• If you receive warnings during the upgrade, the upgrade will complete and log the warnings. If you receive errors, the upgrade will terminate and log the errors.

• If warnings and errors are shown after an upgrade, search for the words Warning and Error in the log file to determine the problem.

• If an unexpected error occurs and the upgrade terminates, the log file displays message details. Check your log file or contact Oracle Support.

Run the MDL File Upgrade Utility Using Command Line

Before using the command line, be aware of the following:

• For an upgrade of multiple MDL files, all files must belong to a single Warehouse Builder Project.

• The order in which you upgrade these files is important. For example, entities must be upgraded before mappings.

Use the following command line to upgrade MDL Files from an older version of the Warehouse Builder Repository:

mdlconvert sourcefile parameterfile

The source file contains the list of sources, targets and log file names. The parameter file contains the different attributes for conversion.

Example of a source file format:

SOURCE
Mdl21Sample1.mdl
Mdl21Sample2.mdl
TARGET
Mdl21Sample1_3i.mdl
Mdl21Sample2_3i.mdl
LOGFILE
Mdl21Sample1.log
Mdl21Sample2.log

Example of a parameter file format:

fieldseparator= ^ or |                (default: ^ )
verbose= true/false 							(default: false)
tempdir = some directory              (default: .\temp)
sourceversion = 2.0.4/2.0.5/2.1/3i    (default: 2.1)
targetversion = 2.0.4/2.0.5/2.1/3i    (default: 3i)

Tips:

When you upgrade from Warehouse Builder 2.1 to the current version of Warehouse Builder:

• All local variables are converted to global variables.

• DDL Maps are not upgraded since they are not supported in Warehouse Builder.

• Granular exported maps have upgrade limitations. For example,

If a mapping is used as a source by Fact 1 and Fact 2, then the order of the upgrade is as follows:

1. Fact 1

2. Fact 2

3. Mapping

The source file format is:

SOURCE
fact1.mdl
fact2.mdl
map.mdl
TARGET
fact1_owb3i.mdl
fact2_owb31.mdl
map_owb3i.mdl
LOG
fact1_owb3i.log
fact2_owb3i.log
map_owb3i.log

Step 4. Import Metadata into the New Warehouse Builder Repository

To import metadata into the new Warehouse Builder repository:

1. From the new Warehouse Builder Client console, select the Administration environment.

2. From the Administration menu, select Metadata Import, and then File.

   Locate the path and file name to the exported data from your former repository.

3. Select Import.

4. Review and commit your data.

5. After testing the new version of Warehouse Builder, remove the old version and its repository.

Upgrading Mappings

The MDL upgrade enables the mappings upgraded from your 2.x repository to generate the exact same code in your current repository.

However, certain operators can lose information on the keys of the objects they reference. If you want to continue working on your mapping design using the upgraded repository, you must first reconcile your mapping operators with their referenced objects. The keys of the referenced objects are then restored to the upgraded mapping operators.

Before you work on your upgraded mapping:

1. Launch Warehouse Builder.

2. Double-click the upgraded mapping name to display the Mapping Editor.

3. Select the upgraded mapping operator and from the Edit menu, select Reconcile Inbound.

   Warehouse Builder displays the Inbound Reconcile dialog.

4. Select Match by Physical Name and click OK.

   The referenced keys are restored in the upgraded mapping operator. You are now ready to continue with your mapping design.