tDBConnection - reusing for different database typ... - Qlik Community

Anonymous · ‎2019-02-26

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 · ‎2019-02-26

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 · ‎2019-03-04

Hi,

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

Thanks.

Anonymous · ‎2019-03-04

Hi,

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

So, could you share an example please.

Thanks.

tDBConnection - reusing for different database type