|
| I am designing a distributed systems and need some advice. I will keep the
details brief but need clarification on "best practices" for what I am
attempting to do.
1. I have a SQL Server 2000 database where I need to attach a DTS which
given some condition, should execute a query (or stored proc - doesn't
matter) and send an XML message to a publishing queue. I know in DTS you can
add send/receive queues but not sure how to integrate with BT 2004.
2. A listener/subscriber on the queue needs to take the XML message and get
it into a BizTalk orhestration. I am a newbie to BT but feel I have an ok
grasp of the architecture.
3. Going the other direction, a BT orchestration needs to send a message to
a queue for a remote (3rd party) application to pick up via another SQL
Server 2000 DTS (DTS receive queue?).
My thoughts and question:
1. I'm hoping I can use the MSMQT adapter in BT 2004 that will allow the
remote DTS to send directly to a MSMQT receiver or do I need another server
running MSMQ ( a true MQ system) to act as the messaging agent/broker?
2. Can I accomplish both sending and receiving, from and to, BT2004 and SQL
Server 2000 DTS using only MSMQT adapter? Should I use a PRIVATE queue using
the DIRECT format since both machines will be behind a firewall and on the
same subnet?
Also note I am stuck with DTS at least on the sending from BT 2004 side. The
inbound into BT 2004 there could be some flexibility such as using a trigger
on a table to send an XML message to a queue using t-sql and OpenXML.
Any insight is very much appreciate as I am under the gun on a project.
Thanks,
bbuck
|
|