Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Administration Tool Utilities and Expression Builder > Utilities and Wizards >

Update Physical Layer Wizard

---

This wizard allows you to update database objects in the Physical layer of a repository based on their current definitions in the back-end database. The wizard does not add any columns or tables that exist in the back-end database but not in the repository.

NOTE:  This wizard is not available for repositories that are opened in read-only mode, because they are not available for updating.

The connection pool settings for each database need to match the connection pool settings used when the objects were last imported into the Physical layer from the back-end database. For example, for Oracle, the connection pool may be set to native OCI, but an Oracle ODBC source must be used for the update. In this case, you would set the connection pool to the Oracle ODBC setting used for the import. For information about connection pool settings, see Working with Connection Pools.

To update objects in the Physical layer

Start the Update Physical Layer wizard by selecting Tools > Utilities > Update Physical Layer from the Administration Tool toolbar, and then click Execute.

The databases in the Physical layer of the repository are listed in the left pane of the wizard.

Highlight the databases that you want to update in the left pane, and then click Add.

The databases move to the update list in the right pane.

To remove a database from the update list, highlight it and click Remove.

If you have Siebel Analytics applications, you can mark the Siebel tables in the repository for updating by clicking the selection box next to each database to add a check mark.

NOTE:  Select this option only if the option to import Siebel tables was selected when the objects were imported into the Physical layer.

When you are done selecting databases to update, click Next.

The workstation running the Administration Tool connects to each back-end database. The objects in the Physical layer are compared with those in the back-end database. Explanatory text alerts you to differences between objects as defined in the database in the Physical layer and as defined the back-end database, such as datatype-length mismatches and objects that are no longer found in the back-end database. For example, if an object exists in the database in the Physical layer of the repository but not in the back-end database, the following text is displayed:

Object doesn't exist in the database

To see more information about an object, click it.

The information window in the wizard displays additional information about the object, including information about where it is used in the repository.

Select the objects to update in the Physical layer of the repository, and then click Next.

The wizard alerts you if it needs to check any objects out.

The workstation running the Administration Tool connects to each back-end database. The wizard displays information about each update that will be made to objects in the Physical layer.

Review the information about each update.
If you decide that you do not want the wizard to update a particular object in the Physical layer, click the Back button and deselect the object.
Click Finish.

The wizard updates the objects in the Physical layer, and then closes automatically.

On the Administration Tool toolbar, click File > Save to save the updated objects in the Physical layer.

Bookshelf Home | Contents | Index | Search | PDF