|
Home > Archive > BizTalk Server Applications Integration > May 2006 > Can Sql Adapter push changes on trigger execution
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 Sql Adapter push changes on trigger execution
|
|
|
|
Hi,
I have Biztalk 2004 and i am using Sql adapter. Is it possible to sense any
triggrer that get executed on table update and it will return the xml back to
biztalk for further processing.
I do not want to poll table constantly. In order to Poll I will have to look
for a datetime column for any changes that happend between sysdate - 5
seconds. There are chances I may miss some records or end up with overlaps
I tried to create a trigger using xp_cmdshell that can write changes to text
file. I was not able to generate xml file as i could not escape chars <, >,
If i use xp_cmd shell to generate change files is it stable? Is there any
thing i should be aware off.
If any one could help me on this will be really appreciated. It will help me
a lot before I choose any approach
Thanks a lot
MS
| |
| Adrian Hamza [MSFT] 2006-05-09, 1:13 am |
| You can have a trigger that copies your rows into a secondary table. Your
SQL adapter would poll the secondary table.
This posting is provided "AS IS" with no warranties, and confers no rights.
Adrian Hamza [MSFT]
http://blogs.msdn.com/ahamza/
My blog on BizTalk 2006
Windows SharePoint Services adapter
--------------------[vbcol=seagreen]
any[vbcol=seagreen]
back to[vbcol=seagreen]
look[vbcol=seagreen]
text[vbcol=seagreen]
>,
me[vbcol=seagreen]
| |
| Paul Somers 2006-05-10, 7:17 am |
| Hi,
I would recommend not to poll your key table, as this can be written to or
updated, causing various locking issues.
It is better to copy the data you want pulled into BizTalk, into a staging
table, BizTalk then polls this table and either deletes the records or flags
them as complete.
You could of course use the trigger to achieve this.
Regards,
Paul Somers
"MS" <MS@discussions.microsoft.com> wrote in message
news:500BF4DD-645D-4AA1-B779-F588AA3C44A4@microsoft.com...
>
> Hi,
>
> I have Biztalk 2004 and i am using Sql adapter. Is it possible to sense
> any
> triggrer that get executed on table update and it will return the xml back
> to
> biztalk for further processing.
>
> I do not want to poll table constantly. In order to Poll I will have to
> look
> for a datetime column for any changes that happend between sysdate - 5
> seconds. There are chances I may miss some records or end up with overlaps
>
> I tried to create a trigger using xp_cmdshell that can write changes to
> text
> file. I was not able to generate xml file as i could not escape chars <,
>
> If i use xp_cmd shell to generate change files is it stable? Is there any
> thing i should be aware off.
>
> If any one could help me on this will be really appreciated. It will help
> me
> a lot before I choose any approach
>
> Thanks a lot
> MS
>
| |
|
| Hi,
Thank you for the response. I will try to implement what you guys suggested.
Thanks
Ms
"Paul Somers" wrote:
> Hi,
>
> I would recommend not to poll your key table, as this can be written to or
> updated, causing various locking issues.
>
> It is better to copy the data you want pulled into BizTalk, into a staging
> table, BizTalk then polls this table and either deletes the records or flags
> them as complete.
>
> You could of course use the trigger to achieve this.
>
> Regards,
>
> Paul Somers
>
> "MS" <MS@discussions.microsoft.com> wrote in message
> news:500BF4DD-645D-4AA1-B779-F588AA3C44A4@microsoft.com...
>
>
>
|
|
|
|
|