Skip to main content Skip to complementary content
Announcements

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

  1. In the menu bar, select Window > Preferences to display the Preferences window.
  2. Start typing Reporting in the filter field and then select Reporting from the list.
    Overview of the Reporting window.
  3. Click Export as context to open a context creation wizard.
  4. Follow the steps in the wizard to define the context variables and export as a context the data mart connection and the path of the report folder and logo file.
    A by-default name will be given to the context variables if you do not change them in the context creation wizard. The context variables will be centralized under the Contexts node in the DQ Repository tree view.
    For further information about how to centralize contexts in the Talend Studio repository, see Centralizing context variables in the Repository.
    A message appears to show the progress of the operation, and then all connection settings become read-only.
  5. To switch the connection back to its initial state, click Revert Context.
  6. In the DQ Repository tree view, right-click, one, or several analyses and generate a report.
    The report editor opens on the report settings.
    Overview of the Report Settings tab and the Context view.
    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 Window > Show View > Profiling > Context 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.
  7. Save the report and execute it.
    The report results will be written to the context connection defined in the report editor.

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