Preparing the contexts and context variables
-
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
example:12345host;localhostport;3306database;testusername;rootpassword;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:-
host, String type
-
port, String type
-
database, String type
-
username, String type
-
password, Password type
-
filename, File type
-
printOperations, Boolean type
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. -
-
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.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments