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.
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.
Could you share an example please - how to use the tDBConnection prepared for Oracle to Netezza connection.
I tried generic but only after selecting the Database type the other connection fields appear.
So, could you share an example please.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables