I need some ideas. I want to set my Database IDs and passwords to variables and have the values for the loaded from a file at runtime so that i can move a file from one deployment to another and have it automatically pick up the new values from the file in that location.
The approach i used is:
I tried to write the values to a file as Key;Value
I then set up a job which reads from this file and flows to a contextload component.
My intent is to use this job as a subjob
The problem is:
When i drag this child into a parent as the first item on the list, the database connections i have defined (which have context variables as credentials) fail at compile time as not being defined. If i deactivate that database piece and instead put in a contextdump, indeed the context variables loaded in the child job are created and referenceable. The problem is simply the compile time check fails the job.
How do i best get this to work. I want to avoid defining the context variables in each parent job i make and instead i would just prefer that all credentials in the file get loaded and the jobs i pull in can reference what they need.
sorry hard to understand - what wrong
but it work exactly!
Could You explain (better with screenshots) - what are You do, and where error?
If I understand correctly, you need to provide Database parameters to your job from a file so that it will be easy to change the parameters of the file when deployed in different environment?
If that is your requirement you can check Implicit Context Load under edit project settings of File Menu & select from file and you can give the path of your context file and in your job you need to create the context variable with the names specified in your file and use the same in the component settings and you are good to go..
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema