Siebel Data Warehouse Installation and Administration Guide > The Siebel ePharma 6.3 to 7.5 Analytics Bridge > Installation Process >
Siebel Application 6.3 OLTP Update Patch
After the Siebel ePharma 6.3 to 7.5 Bridge installation and configuration process has been completed, update the 6.3 Siebel Application database (the OLTP database) to enable it to support the Siebel ePharma 6.3 to 7.5 Analytics Bridge process.
This section consists of the following parts:
Files Required by the Analytics Bridge
Table 12 shows the files used by the 7.5 Siebel Data Warehouse to source its data from the 6.3 Siebel ePharma database.
The Siebel ePharma 6.3 to 7.5 Analytics Bridge installation process installs the .ctl, .bat, and .dat files provided in the directory $INSTALL_DIR:\sea750\dwdb\DWREP.
Table 12. Files Used by the Analytics Bridge
File Name
|
Purpose of File
|
Siebel_DW_Rep.rep
|
The Informatica Repository file that contains the objects and code required to populate the 7.5 Siebel Industry Application Data Warehouse with the 6.3 Siebel ePharma data. (This file replaces the preconfigured version 7.5 Siebel Industry Application Data Warehouse Informatica Repository.)
|
Dwpcdb.ctl
|
Contains the database tables and indexes required by the ETL to control the load process, log exception errors and control the incremental images for refreshes. (These tables are created on the OLTP database. In the 7.5 Siebel Application installation, these tables and indexes are automatically created with the rest of the database objects. However, they do not exist in the Siebel ePharma 6.3 transactional database.) This file is used by the utility ddlimp utility shipped on the Siebel Industry Application Data Warehouse 7.5 CD-ROM.
|
Createwpctables.bat
|
This batch file invokes the ddlimp utility, which uses the Dwpcdb.ctl file, plus the ODBC connect string, tablespace name, username and password you provide during the Siebel Data Warehouse installation wizard, to create the database objects in the target database (6.3 Siebel ePharma database). It creates the log file dwpcdb.log, which displays the results of the process.
|
ETLDataSourceNum.dat
|
Contains the data source definition for 6.3 Siebel ePharma database. Data in this file is loaded into S_ETL_DATASRC, a version 7.5 Siebel applications table that is not in version 6.3 Siebel applications.
|
ETLSourceTableData.dat
|
Text file that contains a list of Siebel ePharma 6.3 database tables. These tables are used by the ETL process to source data for the version 7.5 Siebel Data Warehouse. This data is loaded into the S_ETL_SRC_TABLES table, created by the process from the ETLDataSourceNum.bat file.
|
LOVGenUn_6375delta.dat
|
Text file that contains the List of Values (LOV) used by the ETL process, which are not in the 6.3 Siebel ePharma database. This data is loaded into the S_LOV_UNSPEC_DELTA table. The data from this table is used, in addition to the stock 6.3 Siebel Application LOV values, to populate the W_LOV_D table in the 7.5 Siebel Data Warehouse.
|
SysPrefDelta.dat
|
Text file containing one additional entry not in 6.3 S_SYS_PREF: ETL Alignment Version. The values for this are 'Y' or 'N'. This data is loaded into the S_SYS_PREF_DELTA table. From this table, data is loaded into W_PARAM_G table.
|
cpyETLBridgeData.bat
|
A utility batch file that copies these four data files to the informatica directory:
- ETLSourceTableData.dat
- ETLDataSourceNum.dat
- LOVGenUn_6375delta.dat
- SysPrefDelta.dat
|
Setting Up the Update Patch Files
This update patch uses the .bat file and the .ctl file provided to create necessary tables in 6.3 ePharma OLTP database.
To set up the update patch files
- Open a command window.
- Navigate to the directory $INSTALL_DIR:\sea750\dwdb\DWREP.
- Open and edit Createwpctables.bat by right-clicking on the file name and choosing Edit in Explorer.
- Assign the appropriate values to each of the following variables:
Variable
|
Value
|
OLTP_ODBC
|
ODBC Data Source to access Siebel OLTP Database
|
OLTP_OWNER
|
The login NAME (all UPPERCASE) of the Siebel OLTP database table owner
|
OLTP_OWNER_PSWD
|
Password of the Siebel OLTP database table owner
|
SIEBEL_DISK
|
Name of the disk where the Siebel SME database scripts are installed
|
DATA_AREA
|
Database storage area (tablespace) for tables
|
INDX_AREA
|
Database storage area (tablespace) for indexes
|
UNICODEDB
|
/W if Oracle, /Z otherwise
|
UNICODEFLG
|
Y if a Unicode Database, N otherwise
|
Copying the Update Patch Files
In addition, in order for the ETL process to load necessary data warehouse seed data, you must copy the .dat files to the directory on which Informatica Server has been installed.
To copy update patch batch files to the Informatica directory
- Run Createwpctables.bat.
This batch file creates the table and index objects (provided in the .ctl file) in the target OLTP database (Siebel ePharma 6.3). To make sure the tables and indexes were successfully created, view the Dwpcdp.log file.
- After dwpcdb.ctl has run successfully, copy the four .dat files to the directory on which Informatica Server has been installed, typically \Informatica\PowerMart Server\SrcFiles.
- In the command window opened in Step 1, run the batch file cpyETLBridgeData.bat.
- Type in the command and the target directory. For example:
cpyETLBridgeData "d:\Informatica\PowerMart Server\SrcFiles"
NOTE: You can also copy the files manually.
- In Informatica Server Manager, run Load_6375DeltaSeedFromFile.
This loads the seed data from the .dat files copied in Step 2.b to the OLTP database.
