DATA Step, Macro, Functions and more

Integration with Websphere MQ

Reply
N/A
Posts: 0

Integration with Websphere MQ

Hi,
We need some urgent help in configuring Message Queue Polling from the Object Spawner.
We are using the Websphere MQ. Scenario : When a message arrives in a WebSphere MQ Queue a SAS ETL Job needs to be triggered.
This SAS ETL Job will read the message and process it.
Above mentioned scenario is mentioned at "http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/sasqsid.html"
But it is not clear how to do it.
Can any one suggest how to accomplish such a scenario, or give an alternative suggestion.

Thankyou for your earliest attention.

Regards,

Kapil
Super Contributor
Super Contributor
Posts: 3,174

Re: Integration with Websphere MQ

A search of the SAS support website http://support.sas.com/ revealed this technical reference on your topic/question:

Configuring WebSphere MQ to Trigger SAS: An Example
http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/trigger.html


Scott Barry
SBBWorks, Inc.
N/A
Posts: 0

Re: Integration with Websphere MQ

Hi Scott,
I have gone through this link also. I tried out the configuration, but the main issue is how to configure which job to trigger when a message arrives in a queue. I am using Windows OS for SAS server as well as for MQ server.
Using the method given in the link when I send a message to the transmission queue, The trigger manager gives an error that the TMC command is not recognized. I used runmqtmc -m QMSAS -q QSAS to start the trigger monitor (I am using MQ Client that's why i am using runmqtmc and not runmqtrm). The trigger monitor stars without any problem but when i send a message the trigger message is printed on command prompt : "TMC 2QSAS PROCESSOBJECTSAS QMSAS "
TMC is not recognized as an internal or external command, operable program or a batch file.


The issue remains (for any approach) where to configure the name of the job which is to be triggered.

Can you suggest any thing for the same.

Thank You,
Kapil.
N/A
Posts: 0

Re: Integration with Websphere MQ

Hi Scott,
Also i would like to ask does the triggering of SAS ETL Job from MQ work in Enterprise edition of SAS Server only. I am working on Data Integration SAS server (Which is not an Enterprise Edition).

Thank You,
Kapil.
Super User
Posts: 5,256

Re: Integration with Websphere MQ

I don't think that there is any limitation with reading queues with ordinary DI Server license. About your problem, it seems something you might want to open a track to Sas tech support.

Regards,
Linus
Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 209 views
  • 0 likes
  • 3 in conversation