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)
Datastage Connectivity to JDBC and JMS
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 88
- Joined: Tue Jan 13, 2004 3:07 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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
Or the below link may help!
http://www.redbooks.ibm.com/abstracts/sg246435.html
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.