- This topic has 1 reply, 1 voice, and was last updated 9 years, 5 months ago by
.
-
Posts
-
-
I'm getting started with BTS 2006 development. I have some basic understandings and have looked at some of these Microsoft examples (your know, those purchase order related). I want to try something that we actually se today in our applications. The first is a simple .NET web service interface that when called with proper parameters passed in, returns data from SQL Server in XML (Let's call it MyWS.GetFinancialData(int ID)). This is simple enough that BizTalk would be an overkill but I want to implement the same functionality in BTS for learning purpose. What exactly do I need to do, I know I need to create a schema for the output XML. However, my input would be a resultset from a stored procedure call. Do I need to convert the SP resultset into an XML first too so I can create a map and an orchastration? I thought I knew enough to get started but 5 min into my own problem solving, I'm stuck. Please help.
Thanks a lot
Bob
-
This is how I would go about it:
- Expose your Orchestration as a Web Service to take in your request message and return your result set.
- Create you inbound schema
- Probably just want to use the result from your SQL Query as the return
- Use an Orchestration to query SQL using the SQL Adapter
- Accept an input message with your ID
- Map the input message to your SQL Send Message (Query)
- Get the results and return the message
You should be able to find some separate samples that accomplish all of this and you just have to put them all together. The SDK and online resources are good places to start.
Oh, I’d start with getting the SQL part to work first. It will auto generate schema for you.
I’d expect something like this to take someone new to BizTalk probably a week to complete and understand.
Hope this helps.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.