Skip to main content Skip to complementary content

Reports

Reports are documents you can generate on analyses from Profiling perspective of Talend Studio. Reports can be generated in different formats in order to be retrieved and viewed at a later date or in order to be shared with the team members. The date and time information in reports and editors is displayed in local time zone of Talend Studio.

Available report formats include Basic, Evolution or User defined:

  • A basic report provides the statistics collected by the analysis listed in a given report.
  • An evolution report provides information showing the evolution through time of the indicators used on the analyses listed in a given report. It allows you to compare current and historical statistics to determine the improvement or degradation of the analyzed data. For an example of an evolution report, see Evolution reports.
  • The user-defined option allows to use personalized reports created with the JasperReport reporting tool. For more information, see Using JRXML templates in Talend Studio.

You can create reports on all analysis types except the correlation analyses including Numerical Correlation Analysis, Time Correlation Analysis and Nominal Correlation Analysis.

Supported databases for the data mart

The supported databases for the data mart might be different than the supported databases for profiling data.

The following table describes the supported databases for the data mart.
Database name Database version
HSQL Not applicable
Microsoft SQL Server
  • Google Cloud SQL for SQL Server
  • Amazon RDS for SQL Server
  • Azure SQL Database
  • 2017
  • 2016
  • 2014
  • 2012
MySQL
Information noteRestriction: MySQL InnoDB cluster is supported as a data mart. NDB cluster is not supported.
  • Google Cloud SQL for MySQL
  • Amazon RDS for Aurora
  • Amazon RDS for MySQL
  • Azure Database for MySQL
  • MySQL 8
  • MySQL 5
  • Oracle with SID
  • Oracle with service name
  • Oracle OCI
  • 18
  • Availability-noteDeprecated
    11, 12
PostgreSQL
  • Google Cloud SQL for PostgreSQL
  • Amazon RDS for PostgreSQL
  • Azure Database for PostgreSQL
  • 12 and later
Snowflake Not applicable

Running reports on Snowflake

The following lists the Snowflake privileges you need to run reports when the data mart is on Snowflake:
GRANT USAGE on WAREHOUSE <WAREHOUSE_NAME> to <ROLE_NAME>

GRANT USAGE on DATABASE <DB_NAME> to <ROLE_NAME>

GRANT USAGE on ALL SCHEMAS IN DATABASE <DB_NAME> to <ROLE_NAME>

GRANT SELECT, INSERT, UPDATE on ALL TABLES in DATABASE <DB_NAME> to <ROLE_NAME>

GRANT SELECT, INSERT, UPDATE on ALL VIEWS in DATABASE <DB_NAME> to <ROLE_NAME>

GRANT USAGE on ALL SEQUENCES in DATABASE <DB_NAME> to <ROLE_NAME>

In this section

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here