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.
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,
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.