Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Administration Tool Utilities and Expression Builder > Utilities and Wizards > Update Physical Layer WizardThis 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, see Setting Up Connection Pools. To update objects in the Physical layer
|
Siebel Business Analytics Server Administration Guide |