Defining data sources and parameter values - 7.2

Talend Data Quality Portal User and Administrator Guide (deprecated)

EnrichVersion
7.2
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
EnrichPlatform
Talend DQ Portal
task
Data Governance
Data Quality and Preparation

About this task

The prerequisites before being able to use Talend DQ 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 DQ Portal as an administrator.

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

Procedure

  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.

    Example

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

    Example

  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.