Skip to main content Skip to complementary content

Preparing the contexts and context variables


  1. 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:
  2. Select the Context 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.
  3. Click the Context view and click the [+] button at the upper right corner of the panel to open the Configure Contexts dialog box.
  4. Select the default context, click the Edit button and rename the context to Test.
  5. Click New to add a new context named Production. Then click OK to close the dialog box.
  6. Back in the Context 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.
  7. 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.
  8. 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!