You are here

Home

How can users determine if there is an interface mapping to a particular table or column and which interface tables or columns can be used for importing to this base table or base column?

This information pertains to Siebel version 3.x, 4.x, 5.x, 6.x and 7.x.

In order to find this information, please follow the steps outlined below:

1. Launch the Siebel client with /h option and navigate to the view in the Graphical User Interface (GUI) that has the field.

2. Choose Help > About View

3. Note which applet the field belongs to

4. Launch the Siebel Tools client

5. Navigate to the Applet Object in the Object Explorer

6. Find the applet identified in step 2 by querying for it in the "Applets" applet under 'Name' column

7. In the Object Explorer, drill down the Applet object

8. For a List Applet drill down on the List object to reach the List Column Child object. For a Form Applet select the control child branch of the applet. Then go to step 10.

9. In the List Column applet, the Display Name value that matches the field name on the GUI will be seen.

10. Select the value in the "Field" field and copy it to the clipboard

11. Go back to the Applet level. Right click on the applet identified on step 6 and
chooses "Go to Business Component" For version 7: drilldown on the link in the 'Business Component' column

12. The Business Component that contains the applet will be the new location.

13. In the Object Explorer, drill down to the child object "Single Value Field"

14. Find the field that copied to the clipboard in the Single Value Fields Applet

15. Select the value in the "Column" field, which is the physical column name in the database.

16. In the Object Explorer, go back to the Business Component level.

17. *** The Value for the "Table" field" field in the Business Component Applet is the physical table in the database ***

18. In the Objects Explorer, switch to the "Flat" tab For version 7: make sure the objects are displayed in the Object Explorer by selecting them to be displayed first. From the pulldown menu go to View -> Options -> Select the tab 'Object Explorer. Select the needed objects, otherwise you won't be able to search for an object in the 'Flat' tab of the Object Explorer

 

Siebel Version 5.x, 6.x and 7.x:

19. Select Object "Attribute Mapping"

20. In the "Attribute Mappings" Applet, QBE for the records with Name set to the column name in step 15

21. *** "Interface Table Data Column" field holds the name for the IF column that maps to the base column

22. "GParent EIM Interface Table" field holds the name for the IF table that contains the mapped column.

 

Further information on this subject can be found in:

Version 7 Bookshelf: Siebel Tools Reference Volume 1 of 2 > Data Objects Layer > EIM Interface Tables > Attribute Mapping object type.

This information is available in Siebel Tools by querying on the Target Table and Target Column fields in the IF Mgr Column Mapping object using the Flat tab. To determine which interface tables map to the particular table or column, check the GParent Table and Parent Column fields under this tab. If no records are returned with Type="IMPORTS_TO", then a mapping is currently not available to that particular table or column.

Refer to the "Siebel Interface Manager Mappings Screen" section of the Open Interfaces Concepts chapter of the V3 Administration Guide or the "Interface Table Mappings" section of the Enterprise Integration Manager Concepts chapter of the V4 Administration Guide for further details on using this view.