How to load XML files to message queue
Moderators: chulett, rschirm, roy
How to load XML files to message queue
Hi All
I have created 10 xml files using an XML output stage. I can save this to my system. But i want put those files into a message queue using a Datastage job.
Can i use MQ connector stage after XML out put stage to collect those XMLs created from XML output stage
My data flow like this
Sequential File....>Copy Stage....>XML output Stage....>MQ connector
Somebody plz help me on this
Thanks
I have created 10 xml files using an XML output stage. I can save this to my system. But i want put those files into a message queue using a Datastage job.
Can i use MQ connector stage after XML out put stage to collect those XMLs created from XML output stage
My data flow like this
Sequential File....>Copy Stage....>XML output Stage....>MQ connector
Somebody plz help me on this
Thanks
Yes, you can use the XML Output stage to feed an MQ Connecter.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Absolutely. You won't be using the "filename" property of the XMLOUtput Stage anymore....simply have an output link with a single large column, like "MyXMLMessage" and put a single '/' in the Description property.
ERnie
ERnie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Play with MQ by itself...be sure you know how to put messages into it....usually as one big column with character data. Test first with a transformer, sendinging something like "hello"....
Then play with XMLOutput...get that working as you need.
Then follow the instructions above for the definition on your output link from xmlOutput.
These can both be very complex stages.....or not...it depends on your situation...but it DEMANDS that you play with each one individually until you fully understand its behavior. Each has its own learning curve. do NOT try to put these together "on the fly" the first time.
Ernie
Then play with XMLOutput...get that working as you need.
Then follow the instructions above for the definition on your output link from xmlOutput.
These can both be very complex stages.....or not...it depends on your situation...but it DEMANDS that you play with each one individually until you fully understand its behavior. Each has its own learning curve. do NOT try to put these together "on the fly" the first time.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Play with MQ by itself...be sure you know how to put messages into it....usually as one big column with character data. Test first with a transformer, sendinging something like "hello"....
Then play with XMLOutput...get that working as you need.
Then follow the instructions above for the definition on your output link from xmlOutput.
These can both be very complex stages.....or not...it depends on your situation...but it DEMANDS that you play with each one individually until you fully understand its behavior. Each has its own learning curve. do NOT try to put these together "on the fly" the first time.
Ernie
Then play with XMLOutput...get that working as you need.
Then follow the instructions above for the definition on your output link from xmlOutput.
These can both be very complex stages.....or not...it depends on your situation...but it DEMANDS that you play with each one individually until you fully understand its behavior. Each has its own learning curve. do NOT try to put these together "on the fly" the first time.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
I was looking at a similar issue just then and looking for help...
I have pre-made XML files on my file system. I want to be able to load the contents of these XML file into messages for the queue (MQ).
Can Sequential File stage just read each file as one record and then use the MQ stage to write those records on to the queue directly?
Is there a need for an XML stage in my case?
Thanks
I have pre-made XML files on my file system. I want to be able to load the contents of these XML file into messages for the queue (MQ).
Can Sequential File stage just read each file as one record and then use the MQ stage to write those records on to the queue directly?
Is there a need for an XML stage in my case?
Thanks
No....and in fact, trying to read xml with Seq Stage will potentially get you in trouble. Look thru the forum and check out my blog below for techniques on reading XML as a source.
Provided that the xml documents aren't "huge" you can just load them directly into MQ without any need for the xml stage. Do some searches on that topic too, because at some points, you may need to increase the buffer size available with an APT variable if you are using EE, and/or consider using Server, which is much more liberal in these cases.
Ernie
Provided that the xml documents aren't "huge" you can just load them directly into MQ without any need for the xml stage. Do some searches on that topic too, because at some points, you may need to increase the buffer size available with an APT variable if you are using EE, and/or consider using Server, which is much more liberal in these cases.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>