Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Database Server for Microsoft SQL Server > Configuring the Database Server on MS SQL Server >

Importing the Siebel Repository on MS SQL Server

---

When you import the Siebel Repository, you populate all the repository tables in the Siebel Database Server with the new Siebel 7 application objects.

Regardless of how many Siebel eBusiness Applications you are using (for example, Siebel Sales, Siebel Service, and Siebel Marketing), you will load the repository tables only once.

To import the Siebel Repository

Launch the Database Server Configuration Wizard using any method described in Preparing for the Installation.

The Gateway Server Address screen appears.

Type the values you recorded in your copy of Deployment Planning Worksheets for the following parameters, and then click Next:

Gateway Server Address. The alias of the host on which you installed the Siebel Gateway.

Enterprise Server Name. The name you gave to your Siebel Enterprise Server, for example, siebel.

The Siebel Server Directory screen appears.

On the Siebel Server Directory screen, perform either of the following tasks, and then click Next:
Accept the default value displayed in the Siebel Server Directory field. (This is the SIEBSRVR_ROOT directory, for example, D:\siebsrvr.)
Use the browse button to select an alternate directory path.

The Siebel Database Server Directory screen appears.

On the Siebel Database Server Directory screen, perform either of the following tasks, and then click Next:
Accept the default path displayed in the Siebel Database Server Directory field. (This is the DBSRVR_ROOT directory, for example, D:\dbsrvr.)
Use the Browse button to select an alternate directory.

The RDBMS Platform screen appears.

Select Microsoft SQL Server and click Next.
On the Siebel Database Operation screen, select Import/Export Repository, and then click Next.

The Select Repository Operation screen appears.

On the Select Repository Operation screen, choose one of the following options, as appropriate:
Import Repository. To import the Siebel Repository for the first time with a primary (base) language, select this option. Click Next and proceed to Step 8.

The Import Selection screen appears.

Export Repository. Exports the Siebel Repository into a platform-independent file that can be sent to Siebel Technical Support for analysis if needed. Click Next and proceed to Step 13.

For instructions on importing a new language to the Siebel Repository, see Importing a New Language to Your Repository on MS SQL Server.

The Import Selection screen appears.

On the Import Selection screen, indicate the following:
If you want to import a standard Siebel 7 repository, click the uppermost radio button.
If you want to import a Siebel 7 repository that you have customized to a new environment, click the bottom radio button.

To continue, click Next and proceed to Step 9.

The ODBC Data Source Name screen appears.

Indicate the name for the ODBC data source and then click Next.

NOTE:  The data source is created automatically by the Siebel Server installation, using the format SiebSrvr_enterprise_server_name.

The Database User Name screen appears.

On the Database User Name screen, indicate the following about your database, and then click Next:

Database User Name. User name of the Siebel administrator, for example, SADMIN.

Database Password. Password for the Siebel administrator, for example, MSSQL.

Database Password (confirm). Retype the password to confirm it.

The Database Table Owner screen appears.

On the Database Table Owner screen, indicate the following about your database, and then click Next:

Database Tableowner. Type the DBO login ID for the Siebel Database.

Database Password. Type the password for this account, for example, MSSQL.

Database Password (confirm). Retype the password to confirm it.

When importing your repository for the first time, or when importing a secondary language repository on top of your base-language repository, the Import Repository Name screen appears. Proceed to Step 12.
If you are exporting your repository, the Export Repository Name screen appears. Proceed to Step 13.
On the Import Repository Name screen, type the following values, and click Next:

Import Repository Name. Accept the default name (Siebel Repository) or type another valid name.

Repository File Name. If you are importing your repository for the first time, this is the second field appearing on the screen. Accept the default installation path and file name for this repository or type another valid installation path.

Proceed to Step 14.

On the Export Repository Name screen, type the following values, and click Next:

Export Repository Name. Accept the default name (Siebel Repository) or type another valid name.

Repository File Name. Accept the default installation path and file name for this repository or type another valid installation path.

The Configuration Parameter Review screen appears, showing the values you typed on the previous screens.

Review the configuration values you entered on the previous Configuration Wizard screens:
If you need to change any values, use the Previous and Next buttons to access the screens on which to change entries, then to return to this screen.
When you are satisfied, click Finish.

A message box appears with the prompt:

To apply the configuration now, press "OK".

To apply the configuration later, press "Cancel".

The command line to apply the configuration later is

C:\SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_imprep.ucf

NOTE:  If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed, by navigating to SIEBEL_ROOT\siebsrvr\bin and entering
siebupg.exe /m master_imprep.ucf.

The Siebel Upgrade Wizard screen appears, displaying the items to be executed or imported.

To begin, click OK.

A window appears, displaying information about Siebel Upgrade Wizard repository import activities.

The Siebel Upgrade Wizard displays a message when installation is complete.

To verify that the import was successful, review the log files. See Reviewing the Log Files for Importing Repository on MS SQL Server.

If you need to change the values you previously entered, relaunch the Configuration Wizard by double-clicking the Configure DB Server icon within
Start >Programs >Siebel Enterprise Servers 7.x.x. This relaunch will allow you to reconfigure with different values.

Bookshelf Home | Contents | Index | Search | PDF