|
Home > Archive > BizTalk Server Applications Integration > August 2004 > SQL Adapter
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]
|
|
|
| I am new to BizTalk 2004.
I am trying to create what I think should be a simple
orchestration. I want to drop an xml file into a
directory and have the orchestration pickup the file then
directly pass the xml doc to my stored procedure for
inserting into the DB.
I have looked at the SQL Adapter sample in the SDK but I
can't find any supporting documentation to go along with
it.
I have found how to create a schema using the wizard to
specify my stored proc and specify the message variable to
be passed, but in the example they also have a map which
I'm thinking I won't need since I do not need to transform
the XML.
Eventually I will need to do some db lookup and that will
insert the returned values into the XML but for now I'm
trying to take baby steps to learn BizTalk.
My ochestration right now is simple (maybe too simple)
with a logical receive port bound to a physical recieve
port configured to a local directory. The logical receive
port is connected to a recieve object and below that is a
send object which is connected to a logical send port
bound to a physical send port configured withe sql adapter
to connect to my DB. (At least thats what I'm attempting
to do)
Any suggestions of samples for a simpleton ;-) would be
much appreciated.
Thanks
-jeff
..
| |
| Alan Smith 2004-08-24, 6:58 pm |
| Jeff,
There's a link to a document on using the SQL adapter here...
http://blogs.msdn.com/scottwoo/arch...3/11/88387.aspx
Hope this helps...
/Alan
"Jeff" wrote:
> I am new to BizTalk 2004.
>
> I am trying to create what I think should be a simple
> orchestration. I want to drop an xml file into a
> directory and have the orchestration pickup the file then
> directly pass the xml doc to my stored procedure for
> inserting into the DB.
>
> I have looked at the SQL Adapter sample in the SDK but I
> can't find any supporting documentation to go along with
> it.
>
> I have found how to create a schema using the wizard to
> specify my stored proc and specify the message variable to
> be passed, but in the example they also have a map which
> I'm thinking I won't need since I do not need to transform
> the XML.
>
> Eventually I will need to do some db lookup and that will
> insert the returned values into the XML but for now I'm
> trying to take baby steps to learn BizTalk.
>
> My ochestration right now is simple (maybe too simple)
> with a logical receive port bound to a physical recieve
> port configured to a local directory. The logical receive
> port is connected to a recieve object and below that is a
> send object which is connected to a logical send port
> bound to a physical send port configured withe sql adapter
> to connect to my DB. (At least thats what I'm attempting
> to do)
>
> Any suggestions of samples for a simpleton ;-) would be
> much appreciated.
>
> Thanks
>
> -jeff
> ..
>
>
>
| |
| Sergio Otoya 2004-08-25, 5:53 pm |
| Jeff,
There is a stack of samples for the SQL adapter. I have not looked at them
myself but some of the others are quite useful.
You can download the sdk from microsoft.com/biztalk and then once you
install it then go to these examples:
C:\Program Files\Microsoft BizTalk Server
2004\sdk\Samples\Adapters\SQLAdapter
HTH
--
Sergio Otoya
Winapp
"Jeff" <jeffb@limetech.com> wrote in message
news:48a801c48949$03776230$a301280a@phx.gbl...
> I am new to BizTalk 2004.
>
> I am trying to create what I think should be a simple
> orchestration. I want to drop an xml file into a
> directory and have the orchestration pickup the file then
> directly pass the xml doc to my stored procedure for
> inserting into the DB.
>
> I have looked at the SQL Adapter sample in the SDK but I
> can't find any supporting documentation to go along with
> it.
>
> I have found how to create a schema using the wizard to
> specify my stored proc and specify the message variable to
> be passed, but in the example they also have a map which
> I'm thinking I won't need since I do not need to transform
> the XML.
>
> Eventually I will need to do some db lookup and that will
> insert the returned values into the XML but for now I'm
> trying to take baby steps to learn BizTalk.
>
> My ochestration right now is simple (maybe too simple)
> with a logical receive port bound to a physical recieve
> port configured to a local directory. The logical receive
> port is connected to a recieve object and below that is a
> send object which is connected to a logical send port
> bound to a physical send port configured withe sql adapter
> to connect to my DB. (At least thats what I'm attempting
> to do)
>
> Any suggestions of samples for a simpleton ;-) would be
> much appreciated.
>
> Thanks
>
> -jeff
> .
>
>
|
|
|
|
|