topic Database parameters in Talend Studio

Database parameters

ODridi — Thu, 22 Oct 2020 12:52:54 GMT

Hello,

Does any one know how to read database parameters from a file instead of filling in the information directly in the tDbInput component ?

thank you

shalinim1 — Fri, 23 Oct 2020 07:56:23 GMT

Hi @Ons Dridi ,

You can use tContextLoad component to achieve your requirement.

The job should flow as tfileInputDelimited ---> tContextLoad ---> onsubjobok ---> tDBInput…

tfileInput file should contains the database parameters like,

host;localhost

port;3306

database;test

username;root

password;talend

Select the context view of the Job to define the following parameters,

host, String type

port, String type

database, String type

username, String type

password, Password type

Then while describing the parameters of tDBInput component,

use--> context.host, context.port, context.database, context.username,

context.password.

Hope this would help you.

Regards,

Shalini

ODridi — Fri, 23 Oct 2020 08:46:08 GMT

thank you so much @Shalini M , it's very helpful , I tried it and it works !

Anonymous — Fri, 26 Mar 2021 10:09:47 GMT

Hello,

Best regards

Sabrina