JDBC for the connection between the ETL tool and the iSeries

v_bhaskar · Post by **v_bhaskar** » Mon Mar 24, 2014 1:42 am

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

eostic · Post by **eostic** » Mon Mar 24, 2014 8:30 am

Why JDBC? What are you accessing?

v_bhaskar · Post by **v_bhaskar** » Mon Mar 24, 2014 11:39 pm

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

chulett · Post by **chulett** » Tue Mar 25, 2014 7:41 am

Via the Java Stages as Ernie notes here in his blog (one example).

lstsaur · Post by **lstsaur** » Tue Mar 25, 2014 3:25 pm

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.

v_bhaskar · Post by **v_bhaskar** » Wed Mar 26, 2014 12:21 am

what i understand from above post is ( we can do setup in server side ) am i right

but i am looking in parallel jobs