tDBConnection - reusing for different database type

Seven Stars

tDBConnection - reusing for different database type

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

Six Stars

Re: tDBConnection - reusing for different database type

Please try  Generic DB . https://help.talend.com/reader/NMGL52mo8bm6HnYHfqoONQ/rIkM9zE5yjMJ4S_3aJdvBA

 

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. 

Seven Stars

Re: tDBConnection - reusing for different database type

Hi,

 

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

 

Thanks.

Seven Stars

Re: tDBConnection - reusing for different database type

Hi,

 

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

So, could you share an example please.

 

Thanks.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog