Using context variables to connect to the report database
You can use context variables in the report editor to define the data mart connection where to store report results.
You can define context parameters and use them to execute data quality reports in different configurations, Prod and Test for example. There might be various testing stages you want to perform and validate before a group of reports is ready to go live on production.
Talend Studio offers you the possibility to create multiple context data sets. You can either create context data sets on a one-shot basis from the Preferences window of Talend Studio, or you can create context data sets from the Contexts node in the Integration perspective and store them in the Talend Studio repository.
You can then select any of these repository context variables from the report editor in the Profiling perspective and use them to store report results.
For further information about contexts and how to centralize them in the Talend Studio repository, see Using contexts and variables.
Exporting the report data mart settings as a context
About this task
- You have defined the settings of the report data mart in the Preferences window as outlined in Setting up a distant database.
- You have selected the Profiling perspective.
To export the settings of the report database as a context and use the context variables in the report editor, do the following:
Procedure
-
Start typing Reporting in the filter field and then select
Reporting from the list.
-
In the DQ Repository tree view, right-click, one, or several
analyses and generate a report.
The report editor opens on the report settings.
In the Database Connection Settings view at the bottom of the editor, the connection settings are already filled in with the context variables defined and exported as a context in the Preferences window.The Context Settings view shows the values of the context connection.The Context view shows the variables you exported and centralized in the Talend Studio repository, under the Contexts node in the DQ Repository tree view. If this view is not open in Talend Studio, use the combination to open it.Information noteRemember: A report created in Talend Studio before you define and export context variables keeps its initial database settings. If you want to use it with a different data mart or context connection, you must open the report and select the context connection manually from the report editor. For further information, see Selecting or updating context variables from the report editor.
Selecting or updating context variables from the report editor
Before you begin
- You have selected the Profiling perspective.
- At least one context connection has been created and saved in the Talend Studio repository.
About this task
-
To select context variables from the Talend Studio repository, even if you have not exported the data mart settings as a context from the Preferences window, click Manage variables.
-
To define context variables from scratch, click the [+] button at the top left corner view.
-
To configure context environments for the report, click Manage environments at the top right corner of the view.
For further information about contexts and their variables, see Using contexts and variables.
To change the context connection for a report from the report editor, do the following:
Procedure
-
Click OK.
The variables of the selected context connections are listed in the Context view and in the Context Settings view.
-
If required, you can modify any context variable by clicking the value you want to
modify in the Context view.
Context values are modified accordingly in the report editor but these updates are not propagated to the context group in the repository. You can run only the current report with the new context values.