Dear all,

A newbie to BTS, I am having a few issues to get clarified in most
urgency.. Looking forward to some help from all of you at the
earliest. Thanking in advance for all the possible help extended...

We have a scenario for data facilitation between two servers thro BTS
2002. The source is Oracle DB and the destination is some Proprietary
database and there will be a BTS instance at both the servers. Data is
required to be facilitated in both Event based mode as well as Batch
Mode in different scenarios.

Following is assumption I have made. Please correct me if I am wrong.

a> There is no way by which BTS can pick up the records directly from
an Oracle DB.


For the event mode data facilitation, requirement is something like
this. As and when(OR AS closely as possible) data is generated/altered
at the Source, the data needs to reach the Destination.

Solution designed is as follows. (Possibly might be not the best
method.Please do correct me, where appropriate)

A COM+ Component will retrieve the records from Source DB and convert
them to an XML String, pass the document to the BTS Orchestration for
wee bit of processing logic (Thinking of writing to a static message
queue from the Component, which BT Orch can wait on)... Once the data
is processed in the orch, it will be send to the other BTS Server
thro' a BTS messaging port..

At the destination end, the message is received in a channel,
processed by an AIC, which will update the Proprietary DB at
destination, and revert with the status of update for each record send
in the form of an xml message back to the source through a messaging
port.

The source on receiving the xml message through a messaging port will
process the message in an AIC and update the status of the individual
data transfer in the source DB.


Questions :

a) Is this approach good enough?? Do you envisage anything that can
possibly make me backtrack at a later stage?

b) Is there a better method than using a message queue for ensuring
that the message reaches the BT Orch (Other than the hot folder
method). And how exactly is it better?

c) Either specific to my example, or in general, how is it that we can
maintain transactional integrity for transactions across two different
BTS Servers?? Please throw some light on this?

d> How exactly can I initiate the First COM component??? Assume that I
want the process to occur every 5 minutes.... So should I create a
seperate scheduler application to activate the COM Component??? Or is
it that in BTS orch, I can instantiate the COM component at
pre-determined intervals (something like Timer control in VB
equivalent??)


Please revert for any further clarifications.. I am not sure I have
explained the scenario properly.. Please revert in case of ANY doubts
regarding the same..

This turned out to be a slightly lengthy query and I apologise for
that..


Thanks and regards,

Varkey

[ Post a follow-up to this message ]