I am new to using web services, so bear with me.
I have a vb.net application with a SQL Server database. I need this to update data on a Mainframe with Adabase. Updates will be triggered on each update to the SQL Server.
My question is this: (In this example, I am using an Inventory Management Application with tablles "tblInventory" and "tblTransaction")
I perform an operation in the application which:
1. Adds a new record to tblInventory
2. Updates an existing record in tblInventory
3. Adds a new record to tblTransactions
These are all recorded in the SQL Server now I need to pass them to the mainframe.
How many web services should I use to accomplish updating the mainframe (Adabase)?
Another way of putting it is "Would I just pass all of the data at once to 1 web service and let the mainframe decipher how to handle it?" or "Would I call 3 different but transaction specific web services?"
It seems like the latter would require less data being passed and less processing overhead on the mainframe, but what is the desired way? Or I am way off base and there is a completely different way I haven't though of?