New records in Database table to be send to Web Service

[thomas jacob]

I have a requirement to send any new records created in database table in XML message format to be send to a webservice. How should I go about doing this. The WS messaging mode is Document/Literal. Please help me get started.

Thanks

[Ivan Krizsan]

Hi!
First of all, you have to decide on how to detect changes in the database. Either you have some kind of trigger in the database that invokes your program or you periodically checks for the table(s) in question modifications.
Then you need to retrieve data from the database and create XML representation of the data. Depending on what kind of web service you are going to send the data to, there are different alternatives available regarding how to create the XML.
Finally you send the data to the web service, which again is dependent on the kind of web service that is to receive the data.
Best wishes!