Developing and Deploying Siebel Business Applications > Setting Up the Test Environment > Process of Loading CRM Data in the Test Environment >

Loading the Interface Tables

This task is a step in Process of Loading CRM Data in the Test Environment.

In this topic, you load the interface tables.

To load the interface tables

1. Open Siebel Tools.
2. Determine which columns are required:
   1. In the Object Explorer, click EIM Interface Table.

      If the EIM Interface Table object type is not visible, then display it. For more information, see Setting Up Siebel Tools.

   2. In the EIM Tables list, locate the interface table you must load.

      For the NREC example, locate the EIM_ACCOUNT table.

   3. In the Object Explorer, expand the EIM Interface Table tree, and then click EIM Interface Table Column.
   4. In the Interface Table Columns list, enter a query that locates all records that contain a check mark in the Required property.

      For the EIM_ACCOUNT table, the following interface table columns are required:

      • IF_ROW_BATCH_NUM
      • IF_ROW_STAT
      • PARTY_TYPE_CD
      • PARTY_UID
      • ROW_ID

        For more information, see Siebel Enterprise Integration Manager Administration Guide.

3. Load the interface tables.

   To load legacy data to Siebel interface tables, you use a database software utility that is specific to your database. For example, if you use DB2, then use one of the load utilities available for DB2. For more information, see the documentation for your database software.

   Make sure you load the required columns you identified in Step 2.

   Some columns in the interface tables are part of a user key sequence. The user key sequence is the set of user key columns whose values uniquely identify a row. To prevent importing duplicate rows, as EIM loads each row, it checks whether the interface table already contains the user key sequence for that row.

For information on the following topics, see Siebel Enterprise Integration Manager Administration Guide:

• Specific data and file attachments that EIM can process
• The names of the interface tables
• The target base tables mapped to the interface tables
• Any secondary tables associated with the target tables