Integration

Get Involved. Join the Conversation.

Topic

    Jihane
    Best Approach To Implement OTM Outbound Integration Using...
    Topic posted June 6, 2019 by JihaneBronze Medal: 1,250+ Points, tagged Adapters, Cloud, ERP Cloud, Integration, PaaS, REST, SOAP, Web Services, xml 
    71 Views, 3 Comments
    Title:
    Best Approach To Implement OTM Outbound Integration Using OIC-Logistics Adapter
    Content:

    We are implementing outbound integration from OTM.  OIC is the integration tool. OTM payload is complex and OIC mapper is primitive and doesn't support complex mapping/filtering/massage for the data. For that we are exporting the .iar and writing external XSLT and importing the iar again.

    is there other approach/way to handle that since with XSLT approach, the development is kind of blindness for OIC user. 

    Version:
    19.1.5.0.0

    Comment

     

    • Moon Ray Lo

      I think I can share my thoughts on Oracle HCM as well, with regards to integrating complex HCM data, given that OIC has limitations on the XSLT/Mapper side.

       

      Go first with knowing how the source data is retrieved. In HCM, we have options like Extract, BI Report & WebServices (SOAP/REST). For Extract & BI Reports - we can actually let both of them do the data filter, business logic/rule & data format handling (as much as possible), so that OIC can act as passthrough only or minimal transformation (this is also efficient on OIC maintenance as well, less complexity). If you'll consume Oracle Product's WebServices (SOAP/REST, which I'd assume OTM has) - this is a challenging part, as you also need to understand on functional side to understand data structure. You may want to explore on Orchestration level for data filtering & handling - like a combination of AssignActivty and While/For-Loops in filtering data for xpath expressions/functions as well and then do the rest of transformation (hopefully minimal transformation) in XSLT/Mapper side.

       

      If you're only locked with Logistics-Adapter-based data retrieval, then I have to agree that there might be requirements that would require complex transformation and there's no other way but to export/import integrations and modify transformation file externally, then reimport.

    • Jorge Herreria

      Complex variables declarations (allow user define variables based on complex elements) and it's editor (Stitch) are in the enhancements pipe-line. Complex Variables will be available in the Maps and Stitch... I don't know the LA/GA dates... I would love to see the complex mappings that you have to do, for checking if Stitch/Map will cover them or request an enhancement... I know this does not addresses your immediate need; however will help in the future.

      If you cannot share the whole orchestration if you do not want you, just the XSLT file and the WSDLs that it references. I guess I can derive from there the mapping meaning.

      About creating an enhancement request, I encourage you to enter one, because direct customers enhancements have more weight vs if I enter it on your behalf.

      For now, importing the XSLTs is the simplest way I know :-(