Siebel Global Deployment Guide > Deploying with Global Time Zone > Converting Historical Data to UTC >

Running the UTC Conversion Utility

This topic is part of Converting Historical Data to UTC.

Complete the following task to run the UTC conversion utility and convert your date-time data to UTC.

See also About the UTC Conversion Utility and Preparing Your Data for Conversion to UTC.

NOTE:  Running the UTC conversion utility may take a long time, depending on how many records and how many columns are being converted.

For detailed information on launching the Database Configuration Wizard, see the Siebel Installation Guide for the operating system you are using.

NOTE:  You can run the Database Configuration Wizard and UTC conversion utility in GUI mode or console mode. The values you enter into the Database Configuration Wizard are case-sensitive. You may not type spaces in parameter values; use underscores (_) instead. For GUI mode, click Next to go to the next screen. For console mode, substitute appropriate actions.

To run the UTC conversion utility from the Database Configuration Wizard

  1. Launch the Database Configuration Wizard, as described in the Siebel Installation Guide for the operating system you are using.

    The Database Configuration Wizard appears.

  2. Enter required parameters that apply for every Database Configuration Wizard task.
  3. Choose the option Run Database Utilities.
  4. Choose the option Universal Time Code Conversion.

    See Table 9 for a list of dialog boxes, options, and required values.

    The UTC conversion utility updates your existing data. For columns configured for UTC, the UTC conversion utility adjusts the historical date and time values to their UTC equivalent.

    After successfully converting the UTC-enabled date-time fields, the UTC conversion utility sets the value for the Universal Time Coordinated system preference to TRUE.

    The utility checks for errors, and writes any errors to a log file.

  5. Review the log file generated by the UTC conversion process, and resolve errors as necessary. See Reviewing the UTC Conversion Log Files.

    NOTE:  If the UTC conversion fails for any reason, you must review the log files and resolve any errors encountered. Then you need to manually rerun the UTC conversion utility, as described in Manually Launching the UTC Conversion Utility.

Table 9 shows parameters to use with the Database Configuration Wizard and the UTC conversion utility.

Table 9. Parameters for Database Configuration Wizard and UTC Conversion Utility
At this prompt...
Enter or select the following...

Siebel Gateway Name Server Address

Enterprise Server Name

Specify the machine name of the Siebel Gateway Name Server and the name of the Siebel Enterprise Server.

Siebel Server Directory

Specify the Siebel Server installation location: the SIEBSRVR_ROOT directory, for example, D:\sba80\siebsrvr.

Siebel Database Server Directory

Specify the Siebel Database Configuration Utilities installation location: the DBSRVR_ROOT directory, for example, D:\sba80\dbsrvr.

Database Platform

Specify the RDBMS platform you are using.

Siebel Database Operation

Choose Run Database Utilities.

Database Utilities Options

Choose Universal Time Code Conversion.

Base (Primary) Language

Specify the primary language for your deployment.

ODBC Data Source Name

Specify the ODBC data source1
(The data source was created automatically during Siebel Enterprise configuration, using the format EnterpriseName_DSN.)

NOTE:  Do not enter the value Siebel_DSN unless Siebel is the name of the Enterprise.

Database User Name and Password

Enter the database user name and password. (Specify the user name of the Siebel administrator, for example, SADMIN.)

Database Table Owner and Password

Enter the database table owner name and password.

NOTE:  For Microsoft SQL: this is the login for the owner of the database, not necessarily the default owner of the database in DBO.

UTC Repository Name

Enter the name of the Siebel repository for which you are performing UTC conversion.

Security Group ID

Enter the name of the security group ID, such as SSE_ROLE.

Log Output Directory

Enter the name of directory in which log output is to be generated. By default the log output is generated in the utc subdirectory.

Apply Configuration Changes

Specify whether to apply configuration changes when the wizard completes, or if you will apply changes later.

Configuration Parameter Review

Review the parameters you have defined and then click Finish.

1To find the name of the ODBC data source on Windows XP, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC). Click the System DSN tab to find the name of the ODBC data source.

Siebel Global Deployment Guide Copyright © 2007, Oracle. All rights reserved.