Setting up a database for an individual report - 7.3

Talend Data Fabric Studio User Guide

Version
7.3
Language
English (United States)
EnrichDitaval
Data Fabric
Product
Talend Data Fabric
Module
Talend Studio
Content
Design and Development

You can store individual reports in databases other than the default report database.

Before you begin

You have selected the Profiling perspective of Talend Studio.

Procedure

  1. In the DQ Repository tree view, expand Reports and double-click the report you want to open.
    If you have already defined a default report datamart or a context connection in the studio Preferences window, the connection settings are pre-filled with the values of the default datamart or context variables.
  2. To set a context datamart connection, click the button in the Contexts view and select the context variables from the Talend Studio Repository.
  3. Set a datamart connection:
    • From the DB Type list, select the database in which you want to store the current report results.
    • Define the connection parameters in the individual connection fields or directly in the Url field. When you modify any parameter in the Url field, it is modified automatically in the individual fields and vice versa.
    • In the DB Name, use the same database name that is defined when installing from which you want to access the report results.
    Database Details
    MySQL In the DB Name field, you can either:
    • Enter a new database name (catalog). A catalog will be created and the required tables to store analyses and reports will be generated.
    • Use the default database name (talend_dq). In this database, you can have access to all analyses and results of generated reports.
    • Enter a database name that exists in the database.

      If there is no data mart structure in this database, it will be created.

      If the data mart structure already exists but in a lower version that the current one, the data mart structure is updated.

      If the data mart structure already exists but in an higher version that the current one, you cannot use this data mart structure.
      Note: MySQL database names with a dot "." are allowed.

      You can connect to an Azure Database for MySQL.

    • When using the IPV6 address format for a local MySQL, configure the database connection using the logical hostname, localhost, and map this in the hosts file to the IPV6 local address, [::1]. Otherwise the startup of the Portal fails.
    Oracle with SID

    Oracle with service name

    Oracle OCI

    • Fill the SID or the Service Name field with the name of an existing database.
    • Fill the Schema field with an Oracle schema to which the specified user in the User field has access, or leave it blank. If you leave this field blank, your reports will be written to the default schema of the defined user.
    PostgreSQL
    • Fill in the connection information to the database.
      Note: Database names with a dot "." or an hyphen "-" are allowed.
    • You can use only the default schemas of PostgreSQL when you create the data mart on it.
    • You can connect to an Azure Database for PostgreSQL or an Azure SQL database. When connecting to an Azure Database for PostgreSQL database, use the username@hostname syntax for the User field and leave the Additional parameters field empty.
    Microsoft SQL Server
    • Fill in the connection information to the database.
      Note: Database names with a dot "." or an hyphen "-" are allowed.

      To enable writing reports to the defined database, make sure that the specified user has enough system privileges.

    • You can use only the default schemas of Microsoft SQL Server when you create the data mart on it.
    • If you want to connect via Windows authentication, leave the User and Password fields empty.

      When creating a connection to a Microsoft SQL Server database to store reports and analysis results, both Microsoft and Open source JTDS drivers are supported.

  4. If you have not selected HSQL from the DB Type list, specify additional connection properties in the Additional parameters field.
    When connecting to a MySQL 8 database, configure the useSSL, requireSSL and serverTimezone property. Enter useSSL=false&requireSSL=false&serverTimezone=UTC for example.
    When connecting to an Azure SQL database, enter ssl=require.
  5. Click Check to see the status of your connection.
    A message prompts you to accept creating the database (catalog) if it does not exist.
    If the version of the database you define in the report editor is older than that of the studio, a message prompts you to upgrade it.
  6. Click OK to close the message.
    A confirmation message is displayed.
  7. Click OK to close the confirmation message.
  8. Click the save icon on the report editor toolbar to save the database settings.
  9. Run the current report.
    The report will be written to the defined database.
    If the connection to the new database connection is not successful, the report will be written to the database defined in the Preferences window.