tDqReportRun
Launches the analyses listed in a report and save the results in the data quality
data mart.
You can schedule the Job that uses this component in
Talend Administration Center
and simply launch it to generate the report file without having to deploy the
Studio on the same host server as the job server. Using this component, you can also
generate all types of reports (pdf, XML, or HTML) in folders of your choice and save the
analysis results in the report database.
tDqReportRun launches the profiling
analyses defined in a report created in the Profiling perspective and generates a report file without having to open Talend Studio.
This component executes report as does the Generate report file menu item in the
Profiling
perspective.
For more information about how to generate a report file from report items
in the DQ Repository tree view, see the reports
chapter in the
Talend Studio
User Guide.
tDqReportRun Standard properties
These properties are used to configure tDqReportRun running in the Standard Job framework.
The Standard
tDqReportRun component belongs to the Data Quality family.
This component is available in the Palette of the Studio only if you have subscribed to one of the Talend Platform products.
Basic settings
Schema and Edit |
A schema is a row description, it defines the number of fields to be processed and The schema of this component is read-only. It gives some |
|
Built-in: You create and store |
|
Repository: You have already |
Refresh Dependency |
Click this button to update the jars needed by the report datamart This operation is mandatory when: – you modify the indicators used on the analysis in the analysis – you change the database type of the report datamart in the report For further information about configuring databases to store report |
Browse Reports |
Click this button to open a dialog box where you can select one or All reports created in the |
Report filenames |
This field holds the technical path of the report(s) to be -automatically by selecting the report(s) from the report list -manually, by typing in or pasting the report technical path. You You can set several report pathes separated by commas. |
Output folder |
Set the path to the folder where to store the generated report The path is set by default to the home directory of your studio. |
Advanced settings
Driver JAR |
Jars are listed by default in this table if you generate the Job You can still add Jar files by adding lines to the table. Then on |
tStat |
Select this check box to collect log data at the component |
Global Variables
Global Variables |
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
This is a start component of a Job. It needs an output component Note:
You are recommended to generate a launch-report Job using this |
Scenario: Launching a profiling report from Talend Administration Center Web
application
This scenario applies only to a subscription-based Talend Platform solution or Talend Data Fabric.
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:
-
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. -
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. -
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
-
In the
Profiling
perspective
of your Studio, create an analysis. -
Right-click the analysis and select New
Report to open the report editor and generate a report file
on this analysis. -
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. -
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
-
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. -
Press F6 to execute the Job from the Studio
for testing purposes.If any modifications are done in the analysis after you generate the Job from
the analysis report, you must click the Refresh
Dependency tab in the basic settings of tDqReportRun before you execute the Job. -
Connect to the
Talend Administration Center
Web application. -
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. -
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.
-
-
Click Save to validate the configuration
of this execution task.The new task is displayed in the Job
Conductor page under the corresponding project. - From the task list, select the newly added task.
-
On the toolbar of the Job Conductor page,
click Generate. -
Once the status of this task reads Ready to send on
the task list, select the task again and click Deploy on the toolbar. -
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. The analysis results
are saved in the report database and the report file is saved in the output
folder defined in the tDqReportRun basic
settings.