Can DataStage write to JMS Queue

mkiru23 · Post by **mkiru23** » Fri Sep 04, 2009 1:05 pm

Please let me know if we can write to JMS queue, I have no knowledge of queue services.
The requirement is to read 4M rows from Oracle table and write to JMS Queue.

I did searched in this forum, I didn't find direct answer.

Thanks
Kumar

eostic · Post by **eostic** » Fri Sep 04, 2009 1:10 pm

Look again... you should find a variety of entries on using JavaPack to do this. Look also at my blog below...I illustrate a few ways to use JavaPack, and others have entered great info into this forum on JavaPack also.

There are lots of considerations, but the first is "how to use a java class inside of DS"...... these resources should get you started on the right track.

Ernie

mkiru23 · Post by **mkiru23** » Wed Sep 09, 2009 11:23 am

eostic wrote:Look again... you should find a variety of entries on using JavaPack to do this. Look also at my blog below...I illustrate a few ways to use JavaPack, and others have entered great info into this forum on JavaPack also.

There are lots of considerations, but the first is "how to use a java class inside of DS"...... these resources should get you started on the right track.

Ernie

Can we connect using any stage instead of Java Package. I don't see Java Package in my Enterprise 8.1 edition does we need to buy this or is there any work around.

Thanks
Kumar

eostic · Post by **eostic** » Wed Sep 09, 2009 12:21 pm

JavaPack is the general term for the JavaTransformer and JavaClient Stages. This "is" the way to connect to JMS. Look in the real-time category of stages. They are installed automatically in 8.1. Then spend some time with http://dsrealtime.wordpress.com/2008/03 ... tage-jobs/ . You will also need to have available yourself or on your team someone with java and java/JMS skills.

Ernie

mkiru23 · Post by **mkiru23** » Wed Sep 16, 2009 8:45 am

eostic wrote:JavaPack is the general term for the JavaTransformer and JavaClient Stages. This "is" the way to connect to JMS. Look in the real-time category of stages. They are installed automatically in 8.1. Then spend some time with http://dsrealtime.wordpress.com/2008/03 ... tage-jobs/ . You will also need to have available yourself or on your team someone with java and java/JMS skills.

Ernie

Thanks Ernie, Mgr is evaluating between JMS Queue and IBM MQ, I think IBM MQ is more easy and flexible to read/write.

Regards
Kumar

Sreenivasulu · Post by **Sreenivasulu** » Wed Sep 16, 2009 11:55 am

Writing to JMS queue has its own advantages. Since its code based
you have lot of flexibility unlike websphere mq which is tool based.
You can build your own JMS Queue wherea the websphere mq software needs to licensed (since now datastage is part of ibm you may get it cheap)

Regards
Sreeni