Hi,
Can the SQL Adapter be used to listen to a database table and fire a BizTalk
orquestration when a new record is inserted into the table?

Thanks a lot,

Aura

[ Post a follow-up to this message ]

Yes, in a sense.  You can create a SQL receive location and set the SQL
statement to be used to return rows of data.  You'd need some way to know
that new data was inserted, like a flag.  Essentially, if you can write a
query that returns only the rows you want, you should be able to get that
into BizTalk.

use the Add Generated items menu item on your biztalk project to get
started.

matt


"Aura Lucía Pérez" <aperez@ibc-solutions.co m> wrote in message
news:%23kiaRJD6EHA.3124@TK2MSFTNGP11.phx.gbl...
> Hi,
> Can the SQL Adapter be used to listen to a database table and fire a
> BizTalk
> orquestration when a new record is inserted into the table?
>
> Thanks a lot,
>
> Aura
>
>

[ Post a follow-up to this message ]

Hi Matt,
thanks for your help. But right now I'm a bit confused. Do I have to place
the SQL receive location with its SQL statement at the beginning of the
orchestration, or how do I make sure it's going to start my orchestration
once it founds new data on the table?

thanks,
Aura

"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:eIucPtK6EHA.2192@TK2MSFTNGP14.phx.gbl...
> Yes, in a sense.  You can create a SQL receive location and set the SQL
> statement to be used to return rows of data.  You'd need some way to know
> that new data was inserted, like a flag.  Essentially, if you can write a
> query that returns only the rows you want, you should be able to get that
> into BizTalk.
>
> use the Add Generated items menu item on your biztalk project to get
> started.
>
> matt
>
>
> "Aura Lucía Pérez" <aperez@ibc-solutions.co m> wrote in message
> news:%23kiaRJD6EHA.3124@TK2MSFTNGP11.phx.gbl... 
>
>

[ Post a follow-up to this message ]

when you create your orchestration and put a receive port in it, you'll be
able to bind that receive port to the physical receive port you create in
the BizTalk explorer (after you deploy your orchestration, find it in the
biztalk explorer and choose to "bind").  That sets up a subscription that
will ensure that your orchestration gets invoked whenever a message is
received from that receive port that has the right type for your receive
shape in the orchestration.

Matt

"Aura Lucía Pérez" <aperez@ibc-solutions.com> wrote in message
news:%23VV2r4P6EHA.3828@TK2MSFTNGP09.phx.gbl...
> Hi Matt,
> thanks for your help. But right now I'm a bit confused. Do I have to place
> the SQL receive location with its SQL statement at the beginning of the
> orchestration, or how do I make sure it's going to start my orchestration
> once it founds new data on the table?
>
> thanks,
> Aura
>
> "Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
> news:eIucPtK6EHA.2192@TK2MSFTNGP14.phx.gbl... 
>
>

[ Post a follow-up to this message ]

Matt,
Thanks for your help!!!

Aura

"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:ulXWRXH7EHA.936@TK2MSFTNGP12.phx.gbl...
> when you create your orchestration and put a receive port in it, you'll be
> able to bind that receive port to the physical receive port you create in
> the BizTalk explorer (after you deploy your orchestration, find it in the
> biztalk explorer and choose to "bind").  That sets up a subscription that
> will ensure that your orchestration gets invoked whenever a message is
> received from that receive port that has the right type for your receive
> shape in the orchestration.
>
> Matt
>
> "Aura Lucía Pérez" <aperez@ibc-solutions.com> wrote in message
> news:%23VV2r4P6EHA.3828@TK2MSFTNGP09.phx.gbl... 
place[vbcol=seagreen] 
orchestration[vbcol=seagreen] 
message[vbcol=seagreen] 
know[vbcol=seagreen] 
a[vbcol=seagreen] 
that[vbcol=seagreen] 
>
>

[ Post a follow-up to this message ]