topic Re: Iseries jdbc in Talend Studio

Iseries jdbc

sirarm9 — Thu, 22 Mar 2018 16:49:11 GMT

Hi,

I've developed a project on Talend 5.3 which import data from Iseries via jdbc.

It's all ok. Now I've imported this project on 6.1 version and I've some issue with the retrieve schema on Db Connection. When I try to retrieve the list of physical files and logical files on Iseries, Talend show me only the TABLE objects.

On 5.3 the same function return all the objects of my iseries library.

Someone has a tip?

Thanks.

Armando

Re: Iseries jdbc

Anonymous — Mon, 26 Mar 2018 04:16:50 GMT

Hello,

Talend Studio requires specific third-party Java libraries or database drivers (.jar files) to be installed to connect to sources and targets.

Those libraries or database drivers, known as external modules, may be required by some of Talend components or by some connection wizards or by both. Due to license restrictions, Talend may not be able to ship some of these external modules within Talend Studio since 6.0.

Have you tried to install required external module for your Studio to functional properly?

Here is online document about:TalendHelpCenter:Installing external modules

Best regards

Sabrina

Re: Iseries jdbc

sirarm9 — Mon, 26 Mar 2018 10:10:43 GMT

Hi,

I've the same module jt400_V5R3, installed both 5.3 and 6.5 (see the screenshot).

The connection to the Db is ok but when retrieve the schema the 6.5 lacks of many objects of my as4000 library.

Thanks.

Regards.

Re: Iseries jdbc

Anonymous — Mon, 26 Mar 2018 10:23:31 GMT

Hello,

Have you tried to install your jt400_V5R3 into V 6.5 studio manually to see if it is OK with you?

Best regards

Sabrina

Re: Iseries jdbc

sirarm9 — Mon, 26 Mar 2018 10:42:47 GMT

Before I must uninstall the external module?

The button remove external jar is disabled.

Re: Iseries jdbc

Anonymous — Tue, 27 Mar 2018 04:58:06 GMT

Hello,

Do you want to uninstall jt400_V6R1 from your studio V 6.5.1 firstly and then install jt400_V5R3 instead? Could you please clarify your job requirement?

Best regards

Sabrina

Re: Iseries jdbc

sirarm9 — Tue, 27 Mar 2018 10:59:49 GMT

I've already installed jt400_V6R1 and jt400_V5R3 and both give me the same result.

To install them I've used the wizard when I configure the connection to as400.

I have to try to install manually? If yes, how?

Re: Iseries jdbc

Anonymous — Thu, 29 Mar 2018 03:35:40 GMT

Hello,

Please refer to this on line document about:TalendHelpCenter:Installing external modules.

Best regards

Sabrina