Oracle^® Business Intelligence Server Administration Guide > Oracle BI 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.

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

When the wizard processes the update, the server 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 data type-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 does not exist in the database

NOTE:  The wizard does not add columns or tables to the repository that exist in the back-end database but not in the repository. Additionally, the Wizard doesn't update column Key assignments. It checks that there is a column in the repository that matches the column in the database, and then, if the values don't match, the wizard updates the type and length of the column in the repository.

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 more information about connection pool settings, refer to Setting Up Connection Pools.

To update objects in the Physical layer

1. From the Tools menu, choose Utilities > Update Physical Layer, and then click Execute.

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

2. In the Update Physical Layer Wizard dialog box, select the databases that you want to update in the left pane, and then click Add.

   The databases move to the right pane.

3. To remove a database from the update list, select it and click Remove.
4. After you select the objects that you want to update in the Physical layer, click Next.
5. In the next window, select the connection pool for each database that you want to update and then click Next.

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

6. Review the information about each update.

   NOTE:  You can sort the rows (toggle between ascending order and descending order) by clicking the Name column heading.

7. If you decide that you do not want the wizard to update a particular object in the Physical layer, click the Back button and remove the object.
8. Click Finish.

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

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