Datastage Connectivity to JDBC and JMS

Inquisitive · Post by **Inquisitive** » Wed Feb 14, 2007 11:01 pm

Hi

I have basic questions which needs to be answered to make proper Architectural decisions.

I could not get any answers in documentation and I was wondering if any of you can shed some lights on this.

Background:

We have Datastage 7.5 (PX) and RTI installed and they are up and running on Solaris system.

Questions:
We have requirement to read from a source which is basically JDBC. So how can Datastage communicate with JDBC? If we purchase Java Pack would we able to read from JDBC source? Or can we leverage RTI services with external programs for this purpose?
We also have requirements to read through JMS (is it done through Webservices?)

Any information or pointers to get above questions answered would be of great help.

Note: (I am not very familiar with Java and other webservices and terminology. I Basically I am trying to find out How Datastage can Read/Write from/through JDBC and JMS)

chulett · Post by **chulett** » Thu Feb 15, 2007 8:17 am

I believe that the Java PACK is your answer for both here, but would need someone more smarter to confirm or deny.

lstsaur · Post by **lstsaur** » Thu Feb 15, 2007 1:38 pm

Yes, if you have Java PACK installed, you can use JDBC to read your souce DBs and most of JDBC connection work can be done within the Java PACK's Stage.initialize() method.

As you said that you already got RTI working, You definitley can use the JDBC to communinate with RIT components, in your case, you should be able to read your JMS using SOAP over JMS service interface binding.

If you had Hawk 8.0, it will be even more easier to do all the JDBC stuff thru Websphere App. Server directly.

harikhk · Post by **harikhk** » Mon Jun 17, 2013 4:09 pm

hi,

How do we know if Java pack is available with my installation or not
Version is 8.7
I can see in Real Time Stages
Java Client and Java Transformer

ray.wurlod · Post by **ray.wurlod** » Mon Jun 17, 2013 4:44 pm

If you have those stage types you have Java PACK installed.

harikhk · Post by **harikhk** » Mon Jun 17, 2013 5:55 pm

Thanks Ray for the information
Could you please tell me how can I connect to a DB2 hosted on zos system using JDBC
I am not sure if it is possible to do it or not

SURA · Post by **SURA** » Mon Jun 17, 2013 6:05 pm

I am not infront of my system. But i trust you can find the documets like connetivity guide.

Or the below link may help!

http://www.redbooks.ibm.com/abstracts/sg246435.html

harikhk · Post by **harikhk** » Mon Jun 17, 2013 6:12 pm

Thank you so much for the link
I would go through it