Page 1 of 1
JDBC for the connection between the ETL tool and the iSeries
Posted: Mon Mar 24, 2014 1:42 am
by v_bhaskar
Hi All,
can some one suggest me how i can connect to i series through Datastage 8.5 by using JDBC connections
if it is possiable please help me on this
Posted: Mon Mar 24, 2014 8:30 am
by eostic
Why JDBC? What are you accessing?
Posted: Mon Mar 24, 2014 11:39 pm
by v_bhaskar
hi
client has enabled SSL certificate to use of secure data connectivity on top of us need to connect the JDBC to pull data from iseries table
one question
do we have JDBC connector in Datastage 8.5 version as as for as i googled i got information like its available in Datastage 9.1 version
if we can acheive JDBC functionallity in datastage8.5 please guide me
Posted: Tue Mar 25, 2014 7:41 am
by chulett
Via the
Java Stages as Ernie notes
here in his blog (one example).
Posted: Tue Mar 25, 2014 3:25 pm
by lstsaur
Another way to do it is to set up JDBC on the WebSphere App. Server side. Just go to App. Server Admin Console-->Resources-->JDBC providers. You can even implement advanced function such as JDBC connection pool data source.
Posted: Wed Mar 26, 2014 12:21 am
by v_bhaskar
what i understand from above post is ( we can do setup in server side ) am i right
but i am looking in parallel jobs