3 Replies Latest reply: Feb 4, 2013 10:49 PM by Bhabani Ranjan RSS

    use case related question

    Vik Kumar
      I have the requirement to read the data from a oracle table and do some transformation on few of the columns and then push them via a webservice to create in the target system.

      As of now i am done with a model in the odi studio and i dragged and dropped the source table to the interface on left side. i know how to apply trnsformations as well.

      the point where i stuck is what to specify in the target data store as i need to call a webservice instead.

      Further, how will i actually pass the desired soap request to the webServiceInvoke component ? I know how to invoke my service from odi by pasting the soap request into the command section of the webserviceComponent directly. but how to build a request
      dynamically from the table rows after applying the required transformation rules?

      Please advise.

      i am using odi 11.1.1.6

      Vik
        • 1. Re: use case related question
          Bhabani Ranjan
          the point where i stuck is what to specify in the target data store as i need to call a webservice instead.

          Further, how will i actually pass the desired soap request to the webServiceInvoke component ? I know how to invoke my service from odi by pasting the soap request into the command section of the webserviceComponent directly. but how to build a request
          Can you be more specific on this ?

          http://dwteam.in/invoke-odi-scenario-using-odiinvokewebservice/
          http://dwteam.in/invoke-odi-scenario-using-web-service/
          • 2. Re: use case related question
            Vik Kumar
            Bhabani

            Based on some suggestions I changed it a bit as follows:

            1. I created a procedure instead with source as following command
            select description descr from cn_rs_rules_all_vl where rule_id in (4201, 300100011001731) order by creation_date desc

            2. and target to invoke a webservice call as follows:
            OdiInvokeWebService "-URL=https://efops-rel7st1-cdrm-external-crm.us.oracle.com/opptyMgmtOpportunities/OpportunityService?WSDL" "-PORT_TYPE=OpportunityService" "-OPERATION=createOpportunity" "-HTTP_USER=Sales_Representative" "-HTTP_PASS=aIyX1kofZWZSvZxcq8xf"
            <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/" xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:not="http://xmlns.oracle.com/apps/crmCommon/notes/noteService" xmlns:not1="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:rev1="http://xmlns.oracle.com/oracle/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:act="http://xmlns.oracle.com/apps/crmCommon/activities/activitiesService/">
            <soapenv:Header/>
            <soapenv:Body>
            <typ:createOpportunity>
            <typ:opportunity>
            <opp:Name>#descr</opp:Name>
            </typ:opportunity>
            </typ:createOpportunity>
            </soapenv:Body>
            </soapenv:Envelope>


            The problem is the target fails to call the webservice using #descr or :descr and works if i pass a hard coded value. I am not sure what is the problem. Please advise
            • 3. Re: use case related question
              Bhabani Ranjan
              please use the alias name in upper case as follows

              1. I created a procedure instead with source as following command
              select description DESCR from cn_rs_rules_all_vl where rule_id in (4201, 300100011001731) order by creation_date desc

              2. and target to invoke a webservice call as follows:
              OdiInvokeWebService "-URL=https://efops-rel7st1-cdrm-external-crm.us.oracle.com/opptyMgmtOpportunities/OpportunityService?WSDL" "-PORT_TYPE=OpportunityService" "-OPERATION=createOpportunity" "-HTTP_USER=Sales_Representative" "-HTTP_PASS=aIyX1kofZWZSvZxcq8xf"
              <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/" xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:not="http://xmlns.oracle.com/apps/crmCommon/notes/noteService" xmlns:not1="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:rev1="http://xmlns.oracle.com/oracle/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:act="http://xmlns.oracle.com/apps/crmCommon/activities/activitiesService/">
              <soapenv:Header/>
              <soapenv:Body>
              <typ:createOpportunity>
              <typ:opportunity>
              <opp:Name>#DESCR</opp:Name>
              </typ:opportunity>
              </typ:createOpportunity>
              </soapenv:Body>
              </soapenv:Envelope>