Siebel Global Deployment Guide > Deploying Siebel CRM 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 might take a long time, depending on how many records and how many columns are being converted.
For detailed information about starting the Database Configuration Wizard, see the Siebel Installation Guide for the operating system you are using. NOTE: The values that you enter into the Database Configuration Wizard are case-sensitive. You cannot type spaces in parameter values; use underscores (_) instead. Click Next to go to the next screen.
To run the UTC conversion utility from the Database Configuration Wizard
- Start the Database Configuration Wizard, as described in the Siebel Installation Guide for the operating system you are using.
The Database Configuration Wizard appears.
- Enter required parameters that apply for every Database Configuration Wizard task.
- Choose the option Run Database Utilities.
- Choose the option Universal Time Code Conversion.
See Table 10 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.
- 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, then 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 Starting the UTC Conversion Utility.
Table 10 shows parameters to use with the Database Configuration Wizard and the UTC conversion utility.
Table 10. Parameters for Database Configuration Wizard and UTC Conversion Utility
|
Enter or select the following... |
Siebel Gateway Name Server Address Enterprise Server Name |
Specify the computer 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, for version 16.0, C:\siebel\16.0.0.0.0\ses\siebsrvr on Microsoft Windows or /siebel/16.0.0.0.0/ses/siebsrvr on UNIX or Linux. |
Siebel Database Server Directory |
Specify the Siebel Database Configuration Utilities installation location: the DBSRVR_ROOT directory. For example, for version 16.0, C:\siebel\16.0.0.0.0\ses\dbsrvr on Microsoft Windows or /siebel/16.0.0.0.0/ses/dbsrvr on UNIX or Linux. |
Database Platform |
Specify the RDBMS platform that 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 source. 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.
To find the name of the ODBC data source on Microsoft Windows, go to Start, then Settings, then Control Panel, then Administrative Tools, and then Data Sources (ODBC). Click the System DSN tab to find the name of the ODBC data source. |
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 Server: 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 the 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 that you have defined and then click Finish. |
|