| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| EAI Implementation using MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| ajith54 |
 Posted: Thu Jun 12, 2003 6:39 am Post subject: EAI Implementation using MQ |
 |
|
Newbie
Joined: 06 May 2003
Posts: 4
Location: India
|
Dear Friends,
We would like to build a Framework using MQ for Inter application integration. There are lots of proprietory applications in the organization, which need to be integrated with other systems. Most of the requirements are limited to data - integration. For example, if one record is added in one application, automatically new record details should go in to a Queue and later it will be processed by recieving program.
Which is the best way to implement this solution. Can we use database triggers, when a DML operation is performed, it will call a program to sent a message, or is there any better options. Can we use MQ Integrator???
I know this is a big question, and it has nothing to do with programming, basically we need to create a strategy for Integration . Hoping for a speedy help
Thanks in advance
Regards
Ajith |
|
| Back to top |
|
 |
| zpat |
| Posted: Thu Jun 12, 2003 7:09 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
We linked about seven back-end systems with a "data manager" design using WMQI. A sort of home-grown pub-sub design but not using the actual IBM pub-sub features.
Updates to any system are passed to the broker, which converts them to a common format, validates & cleanses the data, then routes it to the other target systems and transforms the message to the format needed by each system. XML used throughout except when talking to mainframe applications.
In general it is a better design to pass a message to an application adapter that will then update it's own database, than it is to directly update that database from WMQI - that way you abstract the design more. However it is certainly possible to update databases directly and WMQI is a superb way to integrate messages and databases whilst keeping full transactional control (with XA coordination). |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jun 12, 2003 8:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
How you end up implementing this depends a lot on how much you can or are willing to change your applications.
If the answer is "None at all", then you will have to use database triggers that write to queues. What you need to worry about in this case though is maintaining data integrity as you pass information into and through your EAI system. If your applications are updating several tables simultaneously and aren't using a stored procedure or a view to do so, then you have to plan for that as you write your new triggers - since each update would generate it's own trigger. |
|
| Back to top |
|
|
| ajith54 |
| Posted: Fri Jun 13, 2003 7:32 am Post subject: Thank you |
|
|
Newbie
Joined: 06 May 2003
Posts: 4
Location: India
|
Dear Friends,
It is always nice sharing information and being helpfull to others. Thank you very much for all your suggetions. I have just started designing this system, I will keep updating this thread with my new developments. All suggetions are welcomed.
Regards,
Ajith
_________________
K. Ajith Kumar |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
