Post reply

MQSeries Interface

  • 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

  • May 9, 2003 at 12:17 pm

    #456711

    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


    John Zacharkan

  • May 9, 2003 at 12:37 pm

    #456714

    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

  • May 9, 2003 at 12:40 pm

    #456717

    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

  • May 9, 2003 at 12:42 pm

    #456718

    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]

  • May 9, 2003 at 1:33 pm

    #456727

    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


    John Zacharkan

  • May 10, 2003 at 9:29 pm

    #456762

    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

  • May 12, 2003 at 7:20 am

    #456822

    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.

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

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