MQSeries Interface

Question

MQSeries Interface

ken youngers

SSC-Addicted

Points: 439
More actions
May 6, 2003 at 7:11 am

#58487

Looking for a technique to interface SQL Server with MQSeries. Does anyone have some code they would like to share?
Edited by - ken youngers on 05/12/2003 07:15:31 AM
May 9, 2003 at 8:00 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

zach_john SSCertifiable Points: 5922 More actions · Answer 1

We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect?

To be frank I'm not totally versed in MQSeries but I have experts here that are. Speaking with our MQSeries guys they can dump our queues to a comma-delimited file at any frequency, the rest would be up to a DTS package or BCP routine to load a table. Then a front end app to view or maybe a Crystal report.

Again I'm not sure of your needs.

If interested I have resources here if you're looking to have a front-end app and the data load developed.

John Zacharkan

ken youngers SSC-Addicted Points: 439 More actions · Answer 2

quote:
We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect?
To be frank I'm not totally versed in MQSeries but I have experts here that are. Speaking with our MQSeries guys they can dump our queues to a comma-delimited file at any frequency, the rest would be up to a DTS package or BCP routine to load a table. Then a front end app to view or maybe a Crystal report.
Again I'm not sure of your needs.
If interested I have resources here if you're looking to have a front-end app and the data load developed.
John Zacharkan

ken youngers SSC-Addicted Points: 439 More actions · Answer 3

quote:
We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect?
To be frank I'm not totally versed in MQSeries but I have experts here that are. Speaking with our MQSeries guys they can dump our queues to a comma-delimited file at any frequency, the rest would be up to a DTS package or BCP routine to load a table. Then a front end app to view or maybe a Crystal report.
Again I'm not sure of your needs.
If interested I have resources here if you're looking to have a front-end app and the data load developed.
John Zacharkan

ken youngers SSC-Addicted Points: 439 More actions · Answer 4

What I am looking for is a way to get and put messages to an MQSeries queue from a SQLServer stored procedure, or a way to move rows from a table into messages on a queue.

We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect?

To be frank I'm not totally versed in MQSeries but I have experts here that are. Speaking with our MQSeries guys they can dump our queues to a comma-delimited file at any frequency, the rest would be up to a DTS package or BCP routine to load a table. Then a front end app to view or maybe a Crystal report.

Again I'm not sure of your needs.

If interested I have resources here if you're looking to have a front-end app and the data load developed.

John Zacharkan

[/quote]

zach_john SSCertifiable Points: 5922 More actions · Answer 5

Oh you're going the oppisite way. You need to write a program (C, JMS, VB ). Not complicated, but it takes knowing your environment. Too many options to go through here.

As I mentioned I have consultants here that do that for a living. If you want I can put you in contact with them and you can take it up from there. This isn't something your going to find canned. If you're a good developer you make it resuable code, but not canned. And definitely not free. Besides if you're running MQ Series you should be able to affor a little consulting now and then

quote:
What I am looking for is a way to get and put messages to an MQSeries queue from a SQLServer stored procedure, or a way to move rows from a table into messages on a queue.

John Zacharkan

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 6

Try, did read the complete articles. Cannot find my old example.

http://www3.sympatico.ca/n.rieck/docs/mqseries_client_on_openvms.html

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/30/pid/332/qid/495632

cneuhold Hall of Fame Points: 3375 More actions · Answer 7

if everything else isn't an option for you (writing extended stored procedures), you can reside to use the MQSeries-Client automation interface (MQAX200.DLL) and the MSSQL functions to access automation objects (sp_oacreate, sp_oagetproperty, sp_oasetproperty, sp_oamethod).

For info on programming the interface, check the red book available at ibm for free (pdf). can also send it to you per email.

best regards,

chris.