|
Home > Archive > BizTalk Server General > June 2006 > How to periodically update data through Biztalk?
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 |
How to periodically update data through Biztalk?
|
|
| inkylou 2006-06-26, 7:17 pm |
| Hi!
I am trying to find a way to use Biztalk to update data
in an Oracle database on a periodic basis.
Is there any way to make my orchestration send a
message every so many minutes, without having a receive
port?
I know I could create a service that would send a request
TO Biztalk periodically, but I'd like to do this all within
BT, if possible.
Thanks in advance!
| |
| McGeeky 2006-06-26, 7:17 pm |
| There are a few options, up to you to choose the most appropriate:
1. Your BizTalk orchestration could use a loop and wait shape
2. A SQL Server job could create a message file that your orchestration is
bound to
3. Use a SQL receive location to kick the orchestration off
4. And then some
Personally I would favour any method other than the orchestration itself to
regulate the periodic updates. Don't get too hung up on pure BizTalk
solutions - the MS technology stack has many complimentary components, so
make good use of them.
Pick a technology that has a very robust scheduler built in - i.e. SQL
Server jobs or a SQL Receive location
--
McGeeky
http://mcgeeky.blogspot.com
"inkylou" <amylouky@gmail.com> wrote in message
news:1151356902.716429.325590@y41g2000cwy.googlegroups.com...
> Hi!
> I am trying to find a way to use Biztalk to update data
> in an Oracle database on a periodic basis.
> Is there any way to make my orchestration send a
> message every so many minutes, without having a receive
> port?
> I know I could create a service that would send a request
> TO Biztalk periodically, but I'd like to do this all within
> BT, if possible.
>
> Thanks in advance!
>
| |
| Greg Forsythe 2006-06-26, 7:17 pm |
| For a Biztalk only solution you could try this adapter:
http://www.gotdotnet.com/Community/...C9-84BF4E783728
Greg
"inkylou" wrote:
> Hi!
> I am trying to find a way to use Biztalk to update data
> in an Oracle database on a periodic basis.
> Is there any way to make my orchestration send a
> message every so many minutes, without having a receive
> port?
> I know I could create a service that would send a request
> TO Biztalk periodically, but I'd like to do this all within
> BT, if possible.
>
> Thanks in advance!
>
>
|
|
|
|
|