|
Home > Archive > BizTalk Server Orchestration > March 2005 > Orchestration exposed as web service.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Orchestration exposed as web service.
|
|
| Brian C 2005-01-25, 5:50 pm |
| I'm new to this one, so please be patient. I just want to find out the best
way to handle a situation.
1) I have a BTS orchestration that will be a web service
2) When an application calls my web service, it will pass me an OrderId
3) I want to take that OrderID and make a call to a database table and
select many fields based on that OrderId and then create and XML document
that will be sent to a vendor.
I'm not sure how this would be set up in an orchestration. How are the
receive and send ports set up, and how/what do I use in the orchestratiion
to make the database call?
Thanks in advance, Brian
| |
| Joe Gaska 2005-01-26, 5:54 pm |
| Check out the sample from...
C:\Program Files\Microsoft BizTalk Server
2004\SDK\Samples\Orchestrations\ExposeWe
bService
Here is a quick run down.
Create an orchestration and specify the inbound receive port to be SOAP.
You can use the SQL adapter to access the stored procedure which will return
the XML document you can return to you client. ( C:\Program Files\Microsoft
BizTalk Server 2004\SDK\Samples\Adapters\SQLAdapter ) It is pretty straight
foward you can use direct table access or a stored proc.
Use BTSWebSvcWiz.exe which will create the exposed webservice when you point
it at the assembly.
If you follow the above samples you should get through it, let me know if
you have any questions.
Joe
"Brian C" <brian.cesafsky@midwestwireless.com> wrote in message
news:%23TfL7kyAFHA.2428@TK2MSFTNGP14.phx.gbl...
> I'm new to this one, so please be patient. I just want to find out the
best
> way to handle a situation.
>
> 1) I have a BTS orchestration that will be a web service
> 2) When an application calls my web service, it will pass me an OrderId
> 3) I want to take that OrderID and make a call to a database table and
> select many fields based on that OrderId and then create and XML document
> that will be sent to a vendor.
>
> I'm not sure how this would be set up in an orchestration. How are the
> receive and send ports set up, and how/what do I use in the orchestratiion
> to make the database call?
>
> Thanks in advance, Brian
>
>
| |
| Ben Cuttriss 2005-03-10, 2:47 am |
| Brian
Accessing the database is really a matter of preference. I'm not such a
huge fan of the SQL data adapter - if you are .Net minded and like datasets -
there is a discussion entitled: "Consuming Dataset in orchestration" which I
like using to access the db.
What Joe is saying mind is by far and away the easiest and the quickest
route to go - especially for the first time ;)
Good luck
Ben Cuttriss
|
|
|
|
|