|
Home > Archive > BizTalk Server General > 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
| |
| Mike V 2004-08-24, 6:59 pm |
| Have you defined a schema for the inbound spec?
What errors are you seeing as a result of your defined example?
Mike Vallier
Microsoft BizTalk Support Professional
- A good backup is the key to success; you never know when you might need
one -
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
Microsoft Corporation Copyright 2004
All Rights Reserved
--------------------
Content-Class: urn:content-classes:message
From: "Jeff" <anonymous@discussions.microsoft.com>
Sender: "Jeff" <anonymous@discussions.microsoft.com>
Subject: SQL Adapter
Date: Fri, 20 Aug 2004 14:18:49 -0700
Lines: 37
Message-ID: <a55501c486fb$491a7340$a601280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcSG+0kaA1ETUC4nQ3GJG9tWEc9mYA==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.biztalk.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18855
NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
X-Tomcat-NG: microsoft.public.biztalk.general
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
| |
| Dan Sketcher 2004-08-27, 6:07 pm |
| Jeff, you will need to map from your inbound XML to the SP schema, as
the SQL adapter expects the input in its format, not yours. So, after
your receive shape, make a transform and just do a 1:1 mapping (or
whatever) to the SQL Request schema. That should then be sent to the
SP.
If you set the SQL port up as a request-respose, it will respond with
_its_ Response schema as the return.
If you have dramas sending the SP's schema to the port, remeber that
the Message that you send should be an instance of the type
'procedureRequest' which is under 'Multi-part Message Types' rather
than the one under 'Schemas'
Dan
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
|
|
|
|
|