Integration

Get Involved. Join the Conversation.

Topic

    Tarakant Nayak
    OIC Mapping with DB
    Topic posted April 25, 2018 by Tarakant Nayak, last edited April 26, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Database, Integration, Mapping 
    145 Views, 3 Comments
    Title:
    OIC Mapping with DB
    Summary:
    OIC Mapping with DB
    Content:

    Hello Experts,

     

    I am trying to map the source/target parmeters which are coming from a Stored procedure and one of the out params is custom data object which I am not able to do and I get the error

     

    "Drag and drop from a non-repeating parent is not recommended. Normally you want to map the individual leaf nodes. If you really want to do this, click on the target and use the mapping builder."

     

    My SP is having the following definition

     

    p_person_id  number

    p_doc_type varchars

    p_doc is customdbobject

     

    During the integration mapping with Rest API , I am able to map the request input parameters but for the response parameters I see the above error message during mapping.

    Please let us know how to resolve this issue and map properly  if the out param is custom db object.

     

    Thanks
    Tarakant

    Comment

     

    • Kishore Gollapalli

      Hi,

      The error means you need to map the leaf nodes from source to target as the parent element is non repeating. How is structure of customdbobject rendered in the mapper?Any screenshot?If you can see the child nodes under the root element you can  map them on to the target.

    • Hemanth Lakkaraju

      You cannot map the element to element if it has child elements associated with it unless it is a repeating element. You need to expand the element and map each child element individually.

    • sriSANKARaswaminathan-OIC/ICS

      Mapping 2 non-repeating parent elements does not add any business value and hence you get the warning.

      If the source and target schemas are similar, then when you drop the parent on parent, a confirmation popup will come and the children will be automatically mapped. If not, you need to map the leaf nodes individually.