Talend community forum / External properties file

alphamanic · 2011-10-11 22:58:53

Tags: [CSV file, delimited file, deployment, development]

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.

walkerca · 2011-10-11 23:07:39

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.

alphamanic · 2011-10-11 23:14:03

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?

alphamanic · 2011-10-11 23:16:56

ahh, just saw the tutorial section on Working with global context variables

http://www.talendforge.org/tutorials/tutorial.php?language=english&idTuto=34

Thanks

walkerca · 2011-10-11 23:18:03

Take a look at this http://bekwam.blogspot.com/2011/10/appl … tudio.html

pcoffre · 2011-10-12 15:43:53

Thanks Carl for adding this interesting post!

Best,
Pcoffre.

Announcement

Unanswered posts

#1 2011-10-11 22:58:53

External properties file

#2 2011-10-11 23:07:39

Re: External properties file

#3 2011-10-11 23:14:03

Re: External properties file

#4 2011-10-11 23:16:56

Re: External properties file

#5 2011-10-11 23:18:03

Re: External properties file

#6 2011-10-12 15:43:53

Re: External properties file

Board footer