Jump to content


Photo
- - - - -

Interfaces into and out of Pro IV


4 replies to this topic

#1 BrianE

BrianE

    Newbie

  • Members
  • Pip
  • 2 posts
  • Gender:Male

Posted 01 February 2004 - 07:37 PM

Has anyone tried getting XML messages into and out of Pro IV to MQSeries or similar message engine.

We are looking to get Pro IV to queue XML messages from a Linux server and then to pick up the replies.

Has anyone got any thoughts?

#2 Bob Filipiak

Bob Filipiak

    Expert

  • Members
  • PipPipPipPip
  • 133 posts
  • Gender:Male

Posted 01 February 2004 - 09:10 PM

Brian,

In a previous thread, the subject of XML was discussed. It appears that PRO-IV can export XML but not read it.

That being said, since XML is strictly text (albeit with tags); a creative person could read the source data into PRO-IV as an external text file; and process it accordingly. This amounts to that creative person having to write their own XML parsing 'engine' in PRO-IV.

Have (lots of) fun doing it


Bob Filipiak

#3 Tony Waszkiewicz

Tony Waszkiewicz

    Expert

  • Members
  • PipPipPipPip
  • 174 posts
  • Gender:Male
  • Location:London, United Kingdom

Posted 02 February 2004 - 10:03 AM

Hi Brian,

We wrote a C program to get some "XML like" information from an MQ queue and write the data into an Oracle table and another one to go the opposite way. Next we read the Orale table in PRO-IV. This was pretty easy since the format of the data was always fixed.

It would have been easy to write the data from MQ to a text file and use one of the many freeware or shareware XML parsers to reformat it. We have also done this and it is much easier than developing a parser :lol:

regards

#4 Richard Bassett

Richard Bassett

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 696 posts
  • Location:Rural France

Posted 02 February 2004 - 01:58 PM

If you are using Oracle, "Advanced Queueing" (Oracle/AQ) is available using PL/SQL and there are "gateways" available that allow Oracle/AQ to interoperate with Websphere MQ (aka MQ Series). Thus you can in principle use PL/SQL procedures to read and write to MQ Series. Oracle also now has quite extensive XML capabilities applicable to queueing but I have not used these yet and so do not know to what extent they interoperate with MQ Series. Also don't know if some parts of this idea are dependent on having Oracle "Enterprise Edition" - although I suppose people using MQ Series are perhaps likely to have that anyway (then again, you said Linux so perhaps you're tapping into 'enterprise infrastructure' from 'outside' ?)

The advantage of the above (if viable) is of course that it offloads almost all your problem onto Oracle stuff that "already works", allegedly :lol:

More extremely, if you are prepared to write C code, you could in principle integrate ProIV directly with MQ Series by writing the necessary code using the MQ Series C API and linking it with the ProIV Kernel. This is a very high performance solution but probably you wouldn't want to go that way without prior experience of adding C to the kernel. Obviously Tony W's C approach is a little simpler and quite possibly preferable for that reason.

HTH. richard
Nothing's as simple as you think

#5 Dan Shannon

Dan Shannon

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 374 posts
  • Gender:Male
  • Location:Australia

Posted 03 February 2004 - 08:59 PM

Richard's point about Oracle's XML features already working is a good one - on our platform we've experienced a number of bugs, including one that simply crashed our AQ system whenever the size of the XML was >32K

Having said which, it's still *far* easier to deal with a standard XML parser than building your own.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users