topic Re: tDBConnection - reusing for different database type in Talend Studio

tDBConnection - reusing for different database type

Anonymous — Sat, 16 Nov 2024 06:29:30 GMT

Hi,

I have prepared a job that works perfectly fine for a table in Oracle database.

Now, I wanted to re-use the same job for different database type - Netezza.

The query I can modify using tJava or context variable.

But, how to change the Database type in tDBConnection and tDBInput component as the type appears to be a drop down.

Please suggest if it is possible to re-use the job for different datatype - functionality will be same for both Oracle and Netezza.

Thanks

Anonymous — Tue, 26 Feb 2019 10:24:21 GMT

You can always create a new mapping for Neteeza alone. apart from the Oracle mapping you have.

Since you are changing the source and target type.

Anonymous — Mon, 04 Mar 2019 11:42:10 GMT

Hi,

Could you share an example please - how to use the tDBConnection prepared for Oracle to Netezza connection.

Thanks.

Anonymous — Mon, 04 Mar 2019 11:43:16 GMT

Hi,

I tried generic but only after selecting the Database type the other connection fields appear.

So, could you share an example please.

Thanks.