Managing resources - 7.0

Talend Data Quality Portal User and Administrator Guide

EnrichVersion
7.0
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
EnrichPlatform
Talend DQ Portal

Before being able to use Talend Data Quality Portal as a monitoring and reporting tool of data quality metrics, you must define your resources, namely: document management engines, data sources and parameters values.

Defining external and internal engines

From Talend Data Quality Portal you can define an internal or an external engine to be used for the management of documents. All engines are listed in the Engine management page in the Portal.

Prerequisite(s): You have accessed Talend Data Quality Portal as an administrator.

To define an internal or an external engine, do the following:

  1. On the toolbar of the administrator page, click and select Engines management from the list.

    A new page opens to list all the engines defined in the portal.

  2. Click the Add icon in the upper left corner to clear the Details page.

  3. Fill in the details of the new engine you want to define.

    The engine details differ whether you're defining an internal or an external engine. For external engines, a URL and a driver name are necessary, while for internal engines you need only to specify the class.

    The tables below give you some examples about external and internal engines:

    External engine name

    Driver

    URL

    BirtEngine

    it.eng.spagobi.engines.

    drivers.birt.BirtReportDriver

    /SpagoBIBirtReportEngine/BirtReportServlet

    JPivotEngine

    it.eng.spagobi.engines.

    drivers.jpivot.JPivotDriver

    /SpagoBIJPivotEngine/JPivotServlet.

    JasperReportEngine

    it.eng.spagobi.engines.drivers.

    jasperreport.JasperReportDriver

    /SpagoBIJasperReportEngine/JasperReportServlet

    QbeEngine

    it.eng.spagobi.engines.

    drivers.qbe.QbeDriver

    /SpagoBIQbeEngine/servlet/AdapterHTTP

    TalendEngine

    it.eng.spagobi.engines.

    drivers.talend.TalendDriver

    /SpagoBITalendEngine/JobRunService

    Internal engine name

    Class

    ChartEngine

    it.eng.spagobi.engines.chart.

    SpagoBIChartInternalEngine

    DashboardInternalEngine

    it.eng.spagobi.engines.dashboard.

    SpagoBIDashboardInternalEngine

    KpiEngine

    it.eng.spagobi.engines.kpi.

    SpagoBIKpiInternalEngine

  4. Click the icon to save the new engine and add it to the engine list.

Defining data sources and parameter values

The prerequisites before being able to use Talend Data Quality Portal as a monitoring and reporting tool of data quality metrics is to define the data sources to be used.

It is also essential to define the parameter values, List of Values and data sets, to be used in order to read data from these sources.

The section below explains how to define a data source. For more information about how to define the parameter values used to read data, see Parameter values.

Prerequisite(s): You have accessed Talend Data Quality Portal as an administrator.

To define the data source that holds the technical data to be used in document templates, do the following:

  1. On the toolbar of the administrator page, click to display a list.

  2. From the list, select Data source to open the corresponding page.

  3. Click the Add icon in the upper right corner to open the Detail Data Source page.

  4. Fill in the details of the connection according to your environment.

    If you define your data source as a JNDI resource, you define it only one time but you can use it with every application that connects to it. If you define your data source as a jdbc resource, you can connect to other data sources on the fly.

    Note

    When you create a MySQL data source with a JDBC connection, you must add &useOldAliasMetadataBehavior=true to the URL. For example: jdbc:mysql://172.168.33.16:3306/talend_dq?characterEncoding=UTF8&useOldAliasMetadataBehavior=true.

  5. Click the icon to test the connection before saving it.

  6. Click the icon to save the data source details.

Creating a data set as an administrator

In Talend Data Quality Portal, you can create different types of data sets such as query data sets, script data sets, file data sets or QBE data sets. Using data sets, you can read data from different data sources and create Cockpit documents.

For further information on how to create Cockpit documents, see How to create a Cockpit document.

Prerequisite(s): You have accessed Talend Data Quality Portal as an administrator.

  1. On the toolbar of the administrator page, click and select Data set to open the corresponding page.

  2. Click the Add icon at the top of the DataSets List.

  3. In the Detail tab, fill in the details of the data set.

  4. In the Type tab, select the type of the data set from the DataSet Type list.

  5. Set the data set properties according to the type of the data set being created.

  6. Click the icon to save the data set.

The data set is saved and appears in the DataSet List.

For more information, download the SpagoBI quick start guide from SpagoBI Documentation at http://forge.objectweb.org/project/showfiles.php?group_id=204 or check http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/.