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