Creating Properties file using TOS for Data Integration

Question

Is it possible in Talend to store the properties in an external file and later use it in any Job using Talend Open Studio for Data Integration?

Answer 1

Yes, you can easily create external properties files in Talend. In order to do so, first, you need to create a properties file, suppose “demo.properties” and place this file in the c:/etc/classpath path. Next, assign the property you want to specify in this file.

Now go to the repository of Talend Open Studio and right click on Contexts section and select create context group and add the same property as the external file to it.

Create a job which can read and load the properties. Below I have created a simple job to fulfill the requirement:

In the tFileInputDelimited component set the delimiter as “=” for columns and set the schema for the key-value pair such as:

Key → String

Value → String

Now, create another job which will invoke the previous job. In this, invoke the previous job using a tPrejob component and load the contexts into a tContextLoad component. Add a tJava component which will be responsible for writing the context properties. Add the following code in the tJava component:

System.out.println(context.your_property_name);

Finally, execute the 2nd job to get the desired results.