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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema