Skip to main content Skip to complementary content

Creating one or multiple contexts for the same analysis

You can create one or several contexts for a database analysis and select specific context values with which to execute the analysis. Defining context variables in analysis will enable you to run the analysis on different data using the same connection.

Defining contexts in analyses

Before you begin

You have created a database analysis in the Profiling perspective.

Procedure

  1. Double-click the database analysis to open the analysis editor.
  2. Select Window > Show View > Profiling > Context to open the context view.
  3. Click Manage environments.
  4. In the Manage context environments window, select the context and click Rename.
  5. Rename it to Prod and click OK.
    Overview of the Rename context environment window.

Defining variables in analyses

Before you begin

You have created a database analysis in the Profiling perspective.

Procedure

  1. Click the [+] button to add lines in the table.
    Suppose that you want to profile a postal_code column and you want to analyze the postal codes that start with 15 in the development environment and with 75 in the production environment. You also want to allow different concurrent connections per analysis in the two environments.
  2. Click in the Name field and enter the name of the variable you are creating.
    In this example, the first variable is where_clause.
  3. Repeat the above steps to define all the variables for the different contexts.
    In this example, set the value of the where_clause variable in the Test context to postal_code like '15%', and for the Prod context to postal_code like '75%'. Set the value for the concurrent connections per analysis in the development and production environments to three and five respectively.
    Configuration in the Context view following the procedure.
  4. Click Manage variables at the bottom of the view to import any of the contexts created and centralized in the Talend Studio repository and use it with the current analysis.

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!

Leave your feedback here