1 Reply Latest reply: May 3, 2014 11:55 AM by AjaySolleti(Delloitte) RSS

    Siebel OPA Connector - Create IC self reference

    1099274

      We have a requirement to transport a certain Siebel data structure via the Siebel OPA connector to the ODS.

       

      Within the Siebel data, a particular Integration component (i.e. entity in OPA), needs to have a relationship with itself. When exporting this model to OPA, this should create a many-to-many relationship from the entity in question to itself.

       

      The original (test) IC looks as follows:

      - Name: Contact_Account

       

      IC User Props:

      - OPAEntity: contact_account

       

      I then proceeded to create a copy of the IC with the following characteristics:

      - Name: Contact_Account_Copy

      - Parent Integration Component: Contact_Account

       

      Within the copy's IC user props I set up the following:

      - OPAParent: contact_account

      - OPARelationship: self reference

       

      I also incremented the external sequence number and the XML sequence number.

       

      Using the above setup I exported the model to OPA and it seems to give me exactly what I wanted, which is a many-to-many relationship between contact_account and itself.

       

      However, when testing this with Siebel data, things seem to mess up.

       

      I'm not a Siebel expert so I could use some guidance on this.

       

      My main question is: How do I set up the IO to properly deal with a self reference situation?

       

      Thanks in advance for any advice.

       

      Regards,

       

      Evert