Sent date: 05/12/2008
From: Thiago
Message:
Hi Anne,
The usual course of action would be to use the SQL Adapter, unless you have
some specific requirements. The SQL Adapter uses schemas generated by a
wizard (Add Generated Schemas) so you would need to map your XML messages
from their schema to the schema used by the SQL Adapter to insert data into
SQL Server.
There are a few samples and walkthroughs out there on the BizTalk SQL
Adapter, let us know if you need some more help or run into problems.
Regards,
Thiago Almeida
http://connectedthoughts.wordpress.com
"AnneD" wrote:
Show quoted text
> Hi,
>
> I am just starting on my first BizTalk project. I need to route messages that I will receive from several data sources to a SQL DB. All the files received will be in XML and the same format so I can use the same XSD. Can someone please just give me a high level overview of the steps I need to take? Do I need a map? would you recommend SQL Adapter?
>
> Thanks!
>
Sent date: 05/18/2008
From: Thiago
Message:Hi Anne,
It will be easier if you follow some walkthroughs and samples to understand
how the SQL Adapter works. A very simple one that relates to your scenario is
in this document by Scott Woodgate, look at the "Use SQL One-Way Send in
Orchestration Scenario" section:
http://home.comcast.net/~sdwoodgate/SQLAdapterSamples.doc
There are some in the BizTalk SDK (this is an option when you install
BizTalk Server). Here is the link:
http://msdn.microsoft.com/en-us/library/aa559239.aspx
Here is another one that goes through a few scenarios, I guess you would be
interested in the "Insert New Order" section:
http://technet.microsoft.com/en-us/library/ms935658.aspx
Cheers,
Thiago
"Thiago" wrote:
Show quoted text
>
> Hi Anne,
>
> The usual course of action would be to use the SQL Adapter, unless you have
> some specific requirements. The SQL Adapter uses schemas generated by a
> wizard (Add Generated Schemas) so you would need to map your XML messages
> from their schema to the schema used by the SQL Adapter to insert data into
> SQL Server.
> There are a few samples and walkthroughs out there on the BizTalk SQL
> Adapter, let us know if you need some more help or run into problems.
>
> Regards,
> Thiago Almeida
> http://connectedthoughts.wordpress.com
>
> "AnneD" wrote:
>
> > Hi,
> >
> > I am just starting on my first BizTalk project. I need to route messages that I will receive from several data sources to a SQL DB. All the files received will be in XML and the same format so I can use the same XSD. Can someone please just give me a high level overview of the steps I need to take? Do I need a map? would you recommend SQL Adapter?
> >
> > Thanks!
> >
Email TopXML