|
Home > Archive > BizTalk Server General > December 2004 > Can I listen a db table with the 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]
| Author |
Can I listen a db table with the SQL Adapter?
|
|
| Aura Lucía Pérez 2004-12-22, 5:52 pm |
| 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
| |
| Matt Milner 2004-12-23, 2:46 am |
| 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
>
>
| |
| Aura Lucía Pérez 2004-12-23, 5:51 pm |
| 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...
>
>
| |
| Matt Milner 2004-12-27, 8:46 pm |
| 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...
>
>
| |
| Aura Lucía Pérez 2004-12-29, 5:52 pm |
| 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]
>
>
|
|
|
|
|