Database privileges for Talend Data Quality data mart - 8.0

Talend Installation Guide

Version
8.0
Language
English
Operating system
Windows
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

When you use Talend Installer to install Talend Data Quality, you can select a specific database to store analysis results. To enable users to write analysis results to any of the supported databases, you must grant them certain system privileges.

For further information about supported databases, see Compatible databases.

Prerequisites

If you select to use the MySQL, PostgreSQL, or SQL server database to store the analysis results, the database is created automatically by Talend Installer. However, when you select to use the Oracle database you must create the database and the schema before installing Talend Data Quality data mart with Talend Installer.

When defining the database to store analysis results, you must:

  • make sure that users of Talend Data Quality data mart are granted the right privileges on different databases
  • make sure, for the PostgreSQL database, to add the IP of the computer which will install Talend Data Quality data mart on the PostgreSQL server

Privileges for MySQL

The user you define when you configure the report data mart connection must have certain privileges. Use GRANT commands to give at least the following system privileges:
  • Select
  • Insert
  • Update
  • Create
  • Drop
  • Index
  • Alter
  • Create View

Example of SQL statement:

GRANT <privilege> ON`<database_name>`.* TO
                <user_name>@'%'

Privileges for Oracle

The user you define when you configure the report data mart connection must have either the DBA role, or the CONNECT and RESOURCE roles. Use grant commands to give the user system privileges as the following:

The privileges required when creating a data mart within the user's own schema are:

  • create sequence
  • create session
  • create alter session
  • create table
  • create view

Example of SQL statement:

GRANT create session to <user>

The privileges required when creating a data mart within a schema which is not owned by the current user are:

  • alter any table
  • comment any table
  • create any index
  • create any sequence
  • create any table
  • create any view
  • create session
  • insert any table
  • select any sequence
  • select any table
  • update any table

Example of SQL statement:

GRANT alter any table to <user_name>