Database connection Parameter

One Star

Database connection Parameter

Hi everybody,
In my Talend java application, I want to define parameters for my database connection so that i can change it if my database parameters will be changed. All parameters need for my connection (host, port, database, username, password) is taken from a global context. So, have you ever do something like that?
Please post your screenshots.
Thanks in advance for your help.
Employee

Re: Database connection Parameter

Hi,
Of course we have do something like that.
You can use context functionnality, and associate it with a tContextLoad component :
1. create a context in your repository with some context variables (then you can specify some environments for your context variables)
2. use context variables with a tContextLoad component in your Job (the variables will be set from a File or Database, ...).
You can find this documentation in our user guide.
You can also visit the Steph's eclipse blog, you have a section dedicated to the tContextLoad using.
Regards,
One Star

Re: Database connection Parameter

Hi, cantoine
Thank you very much, that's what i need.
One Star

Re: Database connection Parameter

Hi, i have a new question:
My table contain all transaction informations, each record have struct like this:
ID super_parent_id parent_id child_id
1 grand_father_1 father_1 son_1
2 grand_father_1 father_1 son_2
3 grand_father_2 father_2 son_3
4 grand_father_2 father_3 son_4
5 grand_father_2 father_3 son_5

I want to convert all data in this table to only one file with this struct
grand_father_1
father_1
son_1
son_2
grand_father_2
father_2
son_3
father_3
son_4
son_5
I solved but I had to export job scripts and write addition java code to do it.
Have you got any solutions for this scenario, not need to write addition java code? Please share your solutions for me.
Thank in advance for your help.