Bookshelf Home | Contents | Index | Search | PDF

Upgrading and Migrating Siebel Janna Applications > Database Upgrade Tools >

Siebel Janna Database Upgrade Overview

---

The Siebel Janna Database Upgrade comprises the three basic steps shown in Figure 1.

Figure 1. Siebel Janna Database Upgrade Overview

The rest of this chapter discusses each of the three steps in greater detail.

Document the differences between the standard Siebel Janna database and the configuration and usage of the client's database.

Use the Siebel Janna Difference Reporting Utility for this procedure to produce a spreadsheet file with the difference information.

Extract attached objects (Binary Large Objects or BLOBs).

The Siebel Janna application and the Siebel application allows users to associate spreadsheets, word processing documents, pictures, and similar data with accounts and contacts. These attached objects are upgraded using Siebel Enterprise Integration Manager (Siebel EIM), but first they must be converted to their native file format and placed in a staging area. The Siebel Janna Object Extraction Utility performs this operation. For further information on Siebel EIM, see Siebel Enterprise Integration Manager Administration Guide.

Map the schema and migrate the data through upgrade interface tables.

This process involves mapping data elements in the Siebel Janna data model to functionally equivalent elements in the Siebel data model. Data elements for each available Siebel Janna product are mapped to available Siebel products. The data is extracted from the Siebel Janna database into Siebel EIM Interface Tables using Informatica's PowerMart utility. Siebel EIM then imports the data to the Siebel database.For further information on Siebel EIM, see Siebel Enterprise Integration Manager Administration Guide.

NOTE:  It is recommended that data cleanup be performed prior to these three steps to make sure the upgrade process avoids any data loss.

Bookshelf Home | Contents | Index | Search | PDF