Integration Platform Technologies: Siebel Enterprise Application Integration > Creating and Maintaining Integration Objects >

Creating an Integration Object with Many-To-Many Relationships


The following is an example of how to create an integration object with two components that have a many-to-many (M:M) relationship. In this example, an integration object uses the Contact business object and the Contact and Opportunity business components.

To create an integration object with a many-to-many business component

  1. In Siebel Tools, create a new project and lock it, or lock an existing project in which you want to create your integration object.
  2. From the File menu, choose New Object to display the New Object Wizards dialog box.
  3. Select the EAI tab, and then double-click the Integration Object icon.
  4. In the Integration Object Builder wizard:
    1. Select the project you locked in Step 1.
    2. Select the EAI Siebel Wizard business service.
  5. Click Next and in the second page of the Integration Object Builder wizard:
    1. Select the source object Contact to be the base for the new Siebel integration object.
    2. Type a unique name in the field for the new Siebel integration object, for example Sample Contact M:M, and then click Next.
    3. Select the source root for the new integration object from the list.
  6. From the list of components, select Contact and Opportunity.

    NOTE:  There is also a component named Contact_Opportunity in the list. This component is an MVGAssociation component, and you pick it only if you need this integration object to set the primary opportunity for contact. For information on multivalue groups, see About Multivalue Groups in the EAI Siebel Adapter Business Service.

  7. Inactivate all integration component fields in the Contact integration component except First Name, Last Name, Login Name, and Comment. (In this example, these are the only fields you need for Contact.)
  8. Inactivate all integration component fields in the Opportunity integration component except Account, Account Location, Budget Amt, Name, and Description. (In this example, these are the only fields you need for Opportunity.)
  9. Compile the locked project.
Integration Platform Technologies: Siebel Enterprise Application Integration Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices.