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!

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:

Thanks for the reply. I'm still confused though. The SQL Adapter wizard prompts for a select statement or stored proc to get the data.. all I have is the xml files I receive from the various source apps. Do I need to save these in an orchestration or something before using the adapter so I can query the data? I'm sorry, this is my first BT project and I'm obviously a blank slate, can you please give me a quick, high level walkthrough of the steps I need to take? Thanks so much.

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: