|
Home > Archive > BizTalk Server General > February 2005 > Using web service to periodically query the database and retrieve
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 |
Using web service to periodically query the database and retrieve
|
|
|
| Hi,
Being a "newbie" to Biztalk, I'd appreciate your help with this issue!
I would like to use a web service to periodically query the database and
retrieve data that will then be used within the orchestration. In other
words, I would like to use this web service instead of SQL Adapter to
retrieve database information as source message(s) for the orchestration.
Is this possible within BizTalk and if yes, what is the best way to set it up?
Thank you!
| |
| Ian Cross (Cassium) 2005-02-14, 5:50 pm |
| I'm not quite sure what you're trying to do here?
Do you want to periodically poll a database, construct a message per row,
and then submit each message to BizTalk to instantiate an orchestration per
message, or do you already have a running orchestration instance that needs
to periodically check out something in a database?
Please can you clarify the scenario?
Thanks, Ian
"NL" wrote:
> Hi,
>
> Being a "newbie" to Biztalk, I'd appreciate your help with this issue!
>
> I would like to use a web service to periodically query the database and
> retrieve data that will then be used within the orchestration. In other
> words, I would like to use this web service instead of SQL Adapter to
> retrieve database information as source message(s) for the orchestration.
>
> Is this possible within BizTalk and if yes, what is the best way to set it up?
>
> Thank you!
| |
| Matt Milner 2005-02-15, 2:47 am |
| Why not use the SQL adapter to poll the database instead of dealing with a
web service? You can setup a receive location and even setup the polling
interval.
Matt
"NL" <NL@discussions.microsoft.com> wrote in message
news:FBC98151-BCF7-47A2-BDAF-16FE32157AD7@microsoft.com...
> Hi,
>
> Being a "newbie" to Biztalk, I'd appreciate your help with this issue!
>
> I would like to use a web service to periodically query the database and
> retrieve data that will then be used within the orchestration. In other
> words, I would like to use this web service instead of SQL Adapter to
> retrieve database information as source message(s) for the orchestration.
>
> Is this possible within BizTalk and if yes, what is the best way to set it
> up?
>
> Thank you!
| |
| Nabeel Prior 2005-02-15, 2:47 am |
| I agree with Matt. This is the best option in your scenario as there is no
way of polling a web service with the existing BizTalk adapters. You should
also refrain from having an orchestration that loops forever, as it can lead
to some very serious performance degradation as persistence points will keep
increasing unnecessarily.
--
Kind Regards,
Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx
"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:esc5%23rxEFHA.3536@TK2MSFTNGP15.phx.gbl...
> Why not use the SQL adapter to poll the database instead of dealing with a
> web service? You can setup a receive location and even setup the polling
> interval.
>
> Matt
>
>
> "NL" <NL@discussions.microsoft.com> wrote in message
> news:FBC98151-BCF7-47A2-BDAF-16FE32157AD7@microsoft.com...
>
>
|
|
|
|
|