topic Re: External properties file in Talend Studio

External properties file

_AnonymousUser — Sat, 16 Nov 2024 12:37:43 GMT

hi,
I have a flat file that needs to be loaded into the database. I can use talend open studio in my dev env where I can specify the location ("hard code"). This location will be different for my production environment. How can I specify the location in the properties file so that when my standlone job executes it looks into the properties file.

Re: External properties file

Anonymous — Tue, 11 Oct 2011 22:07:39 GMT

Define a context variable 'context.PROPSFILE' and set it to your default dev location (say C:\dev).
In the production environment, override the variable by passing in --context_param PROPSFILE=/opt/productionloc to the run script.
Another option is to set up dev, test, and prod contexts and store three different values in the job. Then, select the environment with --context.

Re: External properties file

_AnonymousUser — Tue, 11 Oct 2011 22:14:03 GMT

thanks, but how can I use this context? - for example
I have my CSV file defined via metadata -> file delimited.
When I create a job and create a tfileinputdelimited
under the component basic settings -> filename/stream - i already see this been hard coded to my dev env.
do you an example anywhere i can take a look at?

Re: External properties file

_AnonymousUser — Tue, 11 Oct 2011 22:16:56 GMT

ahh, just saw the tutorial section on Working with global context variables
http://www.talendforge.org/tutorials/tutorial.php?language=english&idTuto=34
Thanks

Re: External properties file

Anonymous — Tue, 11 Oct 2011 22:18:03 GMT

Take a look at this http://bekwam.blogspot.com/2011/10/applying-contexts-to-talend-open-studio.html

Re: External properties file

Anonymous — Wed, 12 Oct 2011 14:43:53 GMT

Thanks Carl for adding this interesting post!
Best,
Pcoffre.