Im working with webservices (ie. wsdl files)
I need to automate the process, where in the Source is Oracle table and end target is wsdl file
I thought of the approach like : Table to XML then use this XML to populate the wsdl file
but the Issue here is if I try to generate the XML from Table it doesnt have SOAP envelope enclosed (tried with OdiSqlUnload)
version : 126.96.36.199
Pls share your ideas how to achieve this
Thanks for the reply.
I have to invoke the wsdl file and was able to pass the records manually and even tried with XML file and succeeded once.
So going further I will have to automate the process as this XML has to be truncate and load type ... another catch is I will have to capture the rejected records as well (for this im gonna load data into temp table which vll reject the duplicate records based on the comp PK)
let me know if more information is required
Reverse engineer the XSD(or XML) with the SOAP envelope and populate the generated schema tables using IKM XML Control Append.Now synchronize the table with the XML file. After the XML is populated with the values it can be used as a source for the OdiInvokeWebservice tool.
The flow control could be used to reject the records using this IKM itself.
Thanks for your reply, I've been trying the same as I mentioned in me first post itself.
But I am stuck with the XML load itself... it has got around 15 to 18 elements/tags and 5 extra elements like LoadDate,Message,Source like that which holds default data (standard)
I followed the link : https://s3.amazonaws.com/Ora/XML_5_db_to_Complex_XML.swf, but still confused as the Interface i failing at those 5 element mappings.
The package ran fine but the XML doesnt hold data, the individual datastores has data when checked under the Models.