This discussion is archived
3 Replies Latest reply: Feb 4, 2013 8:49 PM by Bhabani Ranjan RSS

use case related question

Vik Kumar Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points