Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >

Generating EIM Table Mapping Reports


Previous versions of the Siebel Interface Tables Reference included a listing of the EIM tables in the repository. You can produce your own report that contains every EIM table in your repository, or query to select EIM tables, including EIM tables you have added.

CAUTION:  In the following procedure, unless you query for specific EIM tables, the default action is to print every EIM table in the repository. Because outputting a report for every EIM table takes a significant amount of time to prepare and print, it is recommended that you perform a query prior to submitting your report request.

To print an EIM table mapping report

  1. Start Siebel Tools.
  2. In the Object Explorer, click the Types tab.
  3. Click EIM Interface Table.

    TIP:   If the EIM Interface Table object is not visible in the Object Explorer, you must select it in the Development Tools Options dialog box. To verify your view settings and make this change, see Verifying Your Object Explorer View Settings.

  4. (Optional) To print select EIM tables, create and run a query.
  5. From the Reports menu, select EIM Interface Tables.

    The Siebel Report Viewer window opens with the Printer icon unavailable (gray). When the report is complete, the Printer icon becomes available.

    NOTE:  The lower-left corner of the Siebel Report Viewer window indicates the status, which is either "Generating report ..." or "Report complete - xxxx page(s)".

  6. Click the Printer icon.

    The following information appears in your EIM table report:

    • Destination Table. The base table.
    • Destination Column. The column name.
    • UK. The user key sequence, if any.
    • FK Table. The name of the table referenced by this column, if it is a foreign-key column.
    • Source Column. The name of the interface column that maps to the destination table.
    • Comments. This section provides a short description of the EIM table. It also includes information on any special restrictions and usages, such as in cases where the destination table has no user keys, and the special behavior of EIM for those tables.
Siebel Enterprise Integration Manager Administration Guide Copyright © 2006, Oracle. All rights reserved.