Web Service Invocation from ODI: A million dollar question if you want to integrate using a web service. So let’s try to answer the question in this post. Here are the steps:
1. Create a new package or open an existing package from where the web service call should be done.
2. Drag and Drop OdiInvokeWebService from the Toolbox on the left, into the package.
Web Service Invocation from ODIIn this post, we’ll discuss the steps to invoke a web service from ODI. Here are the steps:
1. Create a new package or open an existing package from where the web service call should be done.
2. Drag and Drop OdiInvokeWebService from the Toolbox on the left, into the package.
3. Provide the below information in the General tab of properties section for the tool:
- WSDL URL
- Port type
- Operation name
- Request File Name (with path)
- Response File Name (with path, if required for the web service).
The request file is the payload file that should be passed to the web service. This file is in XML format and it should be prepared and present in the path before the OdiInvokeWebService tool is invoked. The response file is generated from the web service call in the format specified in properties.
Select the appropriate option for Storage mode for response file, if expected from the web service. NewFile option creates a new file and removes the previous file from the path if there is already a file with the same name. FileAppend appends the response to the existing response file. NoFile does not create a file if a file already exists with the same name.
4. Give the rest of the properties depending on the web service response format:
5. Generate scenario of the package and run the scenario.
6. The Web service invokes and response file, if any, will be present on the server
Related Posts
- ODI Reverse Engineering of an Oracle Table
- PL- SQL Procedure in ODI (Oracle Data Integrator)
- Load Plan Creation and Scheduling in ODI
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
