Upgrading and Migrating Siebel Janna Applications > Database Upgrade Tools > Database Upgrade Tools >

Step 1: Siebel Janna Difference Reporting Utility

Each upgrade project requires customized Informatica mappings based on extension tables and certain lists of values (LOVs). To discover the necessary configurations that must be made to these mappings, run the Siebel Janna Difference Reporting Utility. This utility compares the base Siebel Janna tables out-of-the-box against the customized installation deployed at each specific client. It also captures a compilation of the changes to the types of Categories, Custom Fields, Phone Numbers, and Addresses.

While the Siebel Janna Difference Reporting Utility is running, it analyzes the Siebel Janna schema and, at its conclusion, produces a Microsoft Excel spreadsheet file with the difference information. The Excel spreadsheet is used to create further Informatica mappings for custom client tables and special usage of Siebel Janna fields, such as Contact.BaseDataString1. Non-system and non-core or module tables are listed as custom.

NOTE:  Make sure that a Siebel Janna ODBC connection is available on the computer that the program is run on, and make sure that Microsoft Excel 97 or later is on this machine.

Installing the Siebel Janna Difference Reporting Utility

• Install the Siebel Janna Difference Reporting Utility on the workstation with the Siebel Janna ODBC connection by running the setup.exe program.

Running the Siebel Janna Difference Reporting Utility

To run the Siebel Janna Difference Reporting Utility

1. After a successful installation, run the DRT.exe file.

   The Siebel Janna Difference Reporting Utility window appears.

2. Enter the appropriate information in the two text fields.

   The Siebel Janna ODBC Connection text box is, by default, filled with the UserDSN value from the registry.

   The Difference report filename text box is used for the name and directory structure of the Excel spreadsheet file. Selecting the ellipsis button to the right of the field opens the Microsoft Save As dialog box where you can select or enter this information.
3. Select the Create Difference Report button to create the Excel spreadsheet report.

   While the report is prepared, the user sees a progress bar.