Supported databases for the data mart - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
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 Studio
Content
Design and Development
Last publication date
2023-09-21
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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 -
Microsoft SQL Server

2012

2014
2016
2017
Azure SQL Database
Amazon RDS for SQL Server
Google Cloud SQL for SQL Server
MySQL* MySQL 5
MySQL 8
Azure Database for MySQL
Amazon RDS for MySQL
Amazon RDS for Aurora
Google Cloud SQL for MySQL
Oracle with SID

8, 9, 10 (removed from 8.0.1 R2023-01 onwards)

11, 12 (deprecated from 8.0.1 R2023-01 onwards)

18

Oracle with service name
Oracle OCI
PostgreSQL 9 and later
Azure Database for PostgreSQL
Amazon RDS for PostgreSQL
Google Cloud SQL for PostgreSQL
Snowflake -
* From Talend Studio 8.0 R2023-07, MySQL InnoDB cluster is supported as a data mart. NDB cluster is not supported.

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> WITH GRANT OPTION

GRANT USAGE on DATABASE <DB_NAME> to <ROLE_NAME> WITH GRANT OPTION

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

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

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

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