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!

[ Post a follow-up to this message ]

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!
>

[ Post a follow-up to this message ]

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!
>
>

[ Post a follow-up to this message ]