Scenario: Launching a profiling report from Talend Administration Center Web application - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes how you can remotely execute a data quality launch-report Job from a given Talend Administration Center Web application.

To do this, you must first commit all of the required metadata to the remote SVN or Git repository used by the Talend Administration Center Web application.

Prerequisites

Proceed as follows to set up the scenario prerequisites:

  1. Create a data quality project from your Talend Administration Center Web application.

    You will launch the report from this project, dq_proj in this scenario.

    For further information about how to create a project in the Talend Administration Center Web application, see Talend Administration Center User Guide.

    If you have not the required rights to create or manage a project, see the administrator of your Web application.

  2. Establish a connection from your Studio to the remote SVN or Git repository storing the above-mentioned project.

    For further information about how to create the connection of this kind, see Talend Studio User Guide.

  3. Launch your Studio using this new connection and the new project created.

    For further information about how to launch the Studio in this way, see Talend Studio User Guide.

Creating the analysis and generating the report

  1. In the Profiling perspective of your Studio, create an analysis.

  2. Right-click the analysis and select New Report to open the report editor and generate a report file on this analysis.

  3. In the Output_Folder field, set the path to a local directory where to save the report file. Also, in the File Type field, select the format of the report output file.

  4. In the Database Connection Settings tab, set the parameters to the report database where to save the analysis results and click Check to validate your connection.

    If the database structure to which you want to connect does not already exist in the database, it will be created and you will be asked to confirm its creation.

    For further information about how to generate a report file and how to set a report database, see Talend Studio User Guide.

    The required metadata such as the analysis and report parameters and the database connection have been committed to the remote SVN or Git repository used by the Talend Administration Center Web application.

Launching the report remotely

  1. From the Profiling perspective, right-click the ColumnAnalysis_WithThresholds report under the Report node and select Generate Jobs > Launch a report from the contextual menu.

    This generates a launch-report Job and opens it in the Integration perspective.

    The Report filenames field points to the technical path of the report, and the Output Folder field points to the folder where to save the report file.

  2. If needed, press F6 to execute the Job from the Studio for testing purposes.

  3. Connect to the Talend Administration Center Web application.

  4. In the menu tree view of the Web application, expand Conductor and click Job Conductor to display the execution task list.

    The Job Conductor page gathers the script generation, Job deployment and Job execution phases.

  5. From the toolbar on the Job Conductor page, click Add > Normal Task to clear the Execution task configuration panel.

    On this configuration panel, set the parameters required for executing the launch-report Job as the following:

    • In the Label field, type in the task name.

    • In the Project field, select the project in which the launch-report Job was created.

    • In the Branch field, select trunk as the branch of this project.

    • From the Name list, select the launch-report Job to be used.

    • In the Version list, select the Job version you want to launch; and in the Context field, select the context in which to run the Job.

    • From the Execution server list, select the server which you want to use to execute this task you are configuring.

  6. Click Save to validate the configuration of this execution task.

    The new task is displayed in the Job Conductor page under the corresponding project.

  7. From the task list, select the newly added task.

  8. On the toolbar of the Job Conductor page, click Generate.

  9. Once the status of this task reads Ready to send on the task list, select the task again and click Deploy on the toolbar.

  10. Once the status of this task reads Ready to run on the task list, select the task again and click Run on the toolbar.

    When you run the launch-report Job from Talend Administration Center Web Application, the analysis listed in the report is executed and its results are saved in the report database and the report file is saved in the output folder defined in the tDqReportRun basic settings.