Create two delimited files corresponding to the two contexts in this scenario,
namely two databases we will access, and name them
test_connection.txt and prod_connection.txt, which contain the database connection details for
testing and actual production purposes respectively. Each file is made of two columns,
containing the parameter names and the corresponding values respectively. Below is an
host;localhost port;3306 database;test username;root password;talend
Select the Contexts view of the Job, and click the
[+] button at the bottom of the view to add seven
rows in the table to define the following parameters:
Note that the host, port, database, username and password parameters correspond to the parameter names in the delimited files and are used to set up the desired database connection, the filename parameter is used to define the delimited file to read at Job execution, the printOperations parameter is used to decide whether to print the context parameters set by the tContextLoad component on the console.
host, String type
port, String type
database, String type
username, String type
password, Password type
filename, File type
printOperations, Boolean type
- Click the Contexts tab and click the [+] button at the upper right corner of the panel to open the [Configure Contexts] dialog box.
- Select the default context, click the Edit button and rename the context to Test.
Click New to add a new context named Production. Then click OK to
close the dialog box.
- Back in the Contexts tab view, define the value of the filename variable under each context by clicking in the respective Value field and browse to the corresponding delimited file.
- Select the Prompt check box next to the Value field of the filename variable for both contexts to show the Prompt fields and enter the prompt message to be displayed at the execution time.
For the printOperations variable, click in the
Value field under the Production context and select false
from the list; click in the Value field under the
Test context and select true from the list. Then select the Prompt check box under both contexts and enter the prompt message to be
displayed at the execution time.