MQ connector stage clarification

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

MQ connector stage clarification

Post by vamsi.4a6 »

MQ connector stage is used to read messages or write messages from Queue.Could anybody please clarify below doubts for MQ connector stage

1)Is there any advantage of reading or writing messages to queue instead of reading or writing from files,tables,xml because so far i worked with these three(files,tables,xml) source systems

2)can any one tell me small pratical Job exampe where queue is necessary which can not implemented by files,tables,xml to understand the importance of queue?
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

99.99 % of the time, it's because an existing MQ environment contains source data that is critical to your application.....DataStage isn't dictating the need for MQ vs flat files --- the need for real time and the use of MQ at the site is what is dictating it. Same for targets.......we write to MQ because there is a real-time application "somewhere else" that needs it, not because it is better, or worse, than any alternative. It simply "is".....

That being said, if MQ is already at the account and pertinent for the application, you wouldn't want to have that application write to a file and then read that with DataStage if you can avoid it....far better for DataStage to be listening on the queue to receive a message the instant it arrives.

If the question is "why MQ", I will leave that to many other forums on the web that go into details on not only MQ but messaging in general.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
prasson_ibm
Premium Member
Premium Member
Posts: 536
Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore

Post by prasson_ibm »

Hi,
We are also using MQ in our project beause it is already used by middleware technologies and we had to plugin DS accoding to customer rqeuirment.
We are recieveing XML events in MQ,which decides which job need to be triggered in datastage. We parse this xml and trigger our job.later we send notification using MQ for status of job run.(Failed or success)
clmhwybe
Premium Member
Premium Member
Posts: 8
Joined: Mon Jun 18, 2012 1:43 pm

Post by clmhwybe »

depends on requirement if for real time and your middle ware layer supports messaging best thing is MQ.
Post Reply