Page History

...

The Interpoint for Siebel extension of Precise for SQL Server and Precise for Oracle can only receive notifications of user events if specific objects are included in the Siebel Repository File (SRF). Before you can use Interpoint for Siebel, you need to modify the SRF file. This document describes how to add the required objects to the file.

Anchor
SettingupSiebelbatchprocesssampling SettingupSiebelbatchprocesssampling

Setting up Siebel batch process sampling

...

1. In Siebel Tools, from the File menu, select New Object. The New Object Wizard opens.
2. On the General tab, select BusComp.
3. Click OK.
4. In the New Business Component dialog box, do the following:
   1. In the Enter a name for the new Business Component text box, type VTS_SPID.
   2. From the Select the Project this Business Component will be part of list, select Precise Interpoint.
   3. From the Select the Table this Business Component will operate on list, select CX_VTSSPID.
5. Click Next.
6. In the Single Value Fields dialog box, from the Select a column in the Base table list, select ROW_ID. A default Field name automatically appears in the Enter a name for the Field text box.
7. Click Add to move the selected row to the table; then click Finish to create the business component.

...

1. In Siebel Tools, in the Objects Explorer, on the Types tab, select Business Object.
2. In the Business Objects panel, from the Edit menu, select New Record. A new record is added to the table in the Business Objects panel.
3. In the Name column, type: VTS_SPID.
4. In the Project column, assign the new record to the VERITAS Interpoint project.
5. On the Types tab in the Object Explorer, select Business Object > Business Object Component.
6. From the Edit menu, select New Record. A new record is added to the table in the Business Object Components panel.
7. In the BusComp column, type: VTS_SPID.
8. From the Tools menu, select Compile Project.

...

Anchor
CreatingtheCXPSSSBLtableOracle CreatingtheCXPSSSBLtableOracle

Creating the CX_PSS_SBL table (Oracle)

1. From the File menu, choose New Object. The New Object Wizard opens.
2. On the General tab, select Table.
3. Click OK. The General dialog box opens.
   Figure 1 General Dialog Box
   
4. In the Enter a name for the new Table field, type CX_PSS_SBL.
5. From the Choose a Project in which you wish to create the Table drop-down list, select Precise Interpoint.
6. Under Select the type of the Table, select A stand-alone Table.
7. Click Next.
8. Click Finish to close the dialog box.
9. For versions prior to version 8.0, in the Tables workspace, click Apply. For version 8.0 and higher, in the Tables workspace, click Apply/DDL. In the displayed dialog box, click Apply.
10. The Apply Schema dialog box is displayed.
    Figure 2 Apply Schema dialog box
    
11. If needed, type a valid privileged user ID and privileged user password into the relevant text boxes.
12. Click Apply. The dialog box closes and the table is created.
13. In the Tables panel, click Activate to activate the new table.
14. In Siebel Tools, on the Types tab in the Object Explorer, select Table. The Tables panel opens.
15. Select table CX_PSS_SBL.
16. On the Types tab in the Object Explorer, Expand Tables and select Column. The Columns panel opens.
17. From the Edit menu, choose New Record. A new record is added to the table in the Columns panel.

18. Add two new columns to the table as follows:
    Table 3 Table with new columns

    Name	User Name	Physical Type	Length
    CLIENT_INFO	Client Info	Varchar	64
    ACTION	Action	Varchar	32

19. For versions prior to version 8.0, in the Tables workspace, click Apply. For version 8.0 and higher, in the Tables workspace, click Apply/DDL. In the displayed dialog box, click Apply. The Apply Schema dialog box is displayed (see Figure 1- 2).
20. If needed, type a valid privileged user ID and privileged user password into the relevant text boxes.
21. Click Apply. The dialog box closes and the records are created.
22. In the Tables panel, click Activate to activate the table with the new columns.
    Figure 3 Siebel Repository - Column List Dialog Box
    

...

1. In Siebel Tools, on the Types tab in the Object Explorer, select Business Object. The Business Objects panel opens.
2. From the Edit menu, choose New Record. A new record is added to the table in the Business Objects panel.
3. In the Name column, type PRECISE_SBL.
4. In the Project column, assign the new record to the Precise Interpoint project.
5. On the Types tab in the Object Explorer, select Business Object > Business Object Component.
   Figure 6 Siebel Repository - Business Object Component List Dialog Box
   
6. From the Edit menu, choose New Record. A new record is added to the table in the Business Object Components Panel.
7. In the Bus Comp column, type PRECISE_SBL.
8. From the Tools menu, choose Compile Project.

...