One Star

how to add db2jcc jar files in talen open studio Data integration

I got the three jar files required to connect to DB2 database.
And i have placed them in the path : C:\TalendDI\.Java\lib

Question:
Is this the correct folder to place the 3 jar files?
How to add these jar files ?
i go to window > Prefefrences> and from there where do i go to add the Jar files as path.?
Would appreciate if yoiu can show a screen shot of adding DB2 as the oracle example doesnt work for me/
3 REPLIES
Six Stars

Re: how to add db2jcc jar files in talen open studio Data integration

I think you can explicitly load your jar files with tlibraryload component in java. You give the the executable jar file in this component in the drop down or by browsing to it. This will load the jar file into that talend job.
One Star

Re: how to add db2jcc jar files in talen open studio Data integration

Completley new to Talend and i only have DB2 database to connect.

where do i access this tLibrary component ?
Six Stars

Re: how to add db2jcc jar files in talen open studio Data integration

Hi,
If you only need to connect to DB2 database, you will find the component 'tDB2Connection' and a whole lot other DB2 components in the palette -> DATABASES-> DB2. For the connection to DB2, talend needs some additional jars to be installed. The jars can be placed <system path to talend>/lib/java/. You can load these explicitly using the component tlibraryload (this is inside the folder Custom Code in the palette).
These are some links which will help you more :
https://help.talend.com/search/all?query=installing+external+modules&content-lang=en
http://www.talendforge.org/forum/viewtopic.php?id=2211