Hi Everyone

I have to read data from a SQL 6.5 server. Since SQL adapter with BizTalk
server 2004 does not work with SQL 6.5 I have written my own component to
access data. But the only way to schedule an orchestration is to use SQL
adapter and the SQL adapter will run as polling service and will get the dat
a
from SQL server and instantiate the orchestration. Is there a way that I can
build orchestration which gets invoked automatically after a certain time.
Please help.

Thanks and Regards
Ashish Shukla

[ Post a follow-up to this message ]

Hello, Ashish,

>I have to read data from a SQL 6.5 server. Since SQL adapter with BizTalk
>server 2004 does not work with SQL 6.5 I have written my own component to
>access data.

I am not exactly sure what kind of component you wrote and what kind of work
 it performs so I might be off.
Please correct me if I am wrong.

>But the only way to schedule an orchestration is to use SQL
>adapter and the SQL adapter will run as polling service and will get the da
ta
>from SQL server and instantiate the orchestration.

I assume that your orchestration starts with a receive shape, marked as "act
ivate". This means that every time a message that
matches the schema expected by your receive shape is picked up by BizTalk, i
t will be fed to a new instance of your orchestration.

It sounds (but again, I am not sure I really understood your issue) that you
 would like to start an orchestration and have it call your
component to retrieve data from SQL 6.5 at specific intervals. You can do th
is. However, this is not a very good design.

A better way to do this would be to package your component that reads from S
QL 6.5 as an adapter. This way, your component
could do all the polling it wants (and you would have control over this in y
our code). When data need to be retrieved, then your
adapter can produce a message and send it to BizTalk. You will then be able 
to take full advantage of BizTalk messaging.
Now you do not have to worry about starting an orchestration to perform poll
ing.

In general, an orchestration should not be attempting to handle some protoco
l. Handling a protocol and getting messages is the
duty of adapters.

Thanks.
-Gilles.

[ Post a follow-up to this message ]

Thanks a lot Gilles. The component that I use takes certain parameters,
like connection string, stored procedure name etc and fethes the data
and returns the resultset. I will try what you have suggested but I
would still prefer if somehow orchestration could be scheduled.

Thanks again
Regards
Ashish Shukla



Gilles [MSFT] wrote:
> Hello, Ashish,
>
> 
>
>
> I am not exactly sure what kind of component you wrote and what kind of wo
rk it performs so I might be off.
> Please correct me if I am wrong.
>
> 
> 
>
> I assume that your orchestration starts with a receive shape, marked as "a
ctivate". This means that every time a message that
> matches the schema expected by your receive shape is picked up by BizTalk,
 it will be fed to a new instance of your orchestration.
>
> It sounds (but again, I am not sure I really understood your issue) that y
ou would like to start an orchestration and have it call your
> component to retrieve data from SQL 6.5 at specific intervals. You can do 
this. However, this is not a very good design.
>
> A better way to do this would be to package your component that reads from
 SQL 6.5 as an adapter. This way, your component
> could do all the polling it wants (and you would have control over this in
 your code). When data need to be retrieved, then your
> adapter can produce a message and send it to BizTalk. You will then be abl
e to take full advantage of BizTalk messaging.
> Now you do not have to worry about starting an orchestration to perform po
lling.
>
> In general, an orchestration should not be attempting to handle some proto
col. Handling a protocol and getting messages is the
> duty of adapters.
>
> Thanks.
> -Gilles.

[ Post a follow-up to this message ]

Several options:

- have an activate receive on the orchestration that is exposed as a
webservice.  Some custom coded windows service could call this webservice
once in a while...
- create an "orchestrationscheduler" adapter that is configurable and sends
messages into the message box at regular times...
- create kind of "schedule" orchestration that loops and has a wait shape in
it...

Best regards,
Christof
--
Christof [Microsoft BizTalk Server MVP]

<user@domain.invalid> wrote in message
news:Or7%23vhNhEHA.3928@TK2MSFTNGP11.phx.gbl...
> Thanks a lot Gilles. The component that I use takes certain parameters,
> like connection string, stored procedure name etc and fethes the data
> and returns the resultset. I will try what you have suggested but I
> would still prefer if somehow orchestration could be scheduled.
>
> Thanks again
> Regards
> Ashish Shukla
>
>
>
> Gilles [MSFT] wrote: 
BizTalk[vbcol=seagreen] 
to[vbcol=seagreen] 
work it performs so I might be off.[vbcol=seagreen] 
data[vbcol=seagreen] 
"activate". This means that every time a message that[vbcol=seagreen] 
BizTalk, it will be fed to a new instance of your orchestration.[vbcol=seagreen] 
you would like to start an orchestration and have it call your[vbcol=seagreen] 
do this. However, this is not a very good design.[vbcol=seagreen] 
from SQL 6.5 as an adapter. This way, your component[vbcol=seagreen] 
in your code). When data need to be retrieved, then your[vbcol=seagreen] 
able to take full advantage of BizTalk messaging.[vbcol=seagreen] 
polling.[vbcol=seagreen] 
protocol. Handling a protocol and getting messages is the[vbcol=seagreen] 
>

[ Post a follow-up to this message ]