SQL dialect-specific

Pentaho software generates dialect-specific SQL when communicating with these data sources. Certified indicates the SQL dialect has been tested for compatibility with Pentaho.

Pentaho Software	Data Source
Pentaho Analyzer	Certified Amazon Redshift Azure SQL Impala MySQL Microsoft SQL Server Oracle PostgreSQL Snowflake Supported Access Firebird Greenplum Hsqldb IBM DB2 IBM MQ 9.2 Informix Ingres Interbase Neoview SqlStream Sybase Vectorwise Vertica Other SQL-89 compliant*
Pentaho Metadata	Certified Azure SQL Hive 2 Impala MySQL PostgreSQL Supported Amazon Redshift ASSQL Firebird H2 Hypersonic IBM DB2 IBM MQ 9.2 Ingres Interbase MS Access MS SQL Server (JTDS Driver) MS SQL Server (Microsoft Driver) Snowflake Sybase Vertica Other SQL-92 compliant*
Pentaho Data Integration	Certified Amazon Redshift Azure SQL Hive Hive 2 Impala MS SQL Server (JTDS Driver) MS SQL Server (Microsoft Driver) MySQL Oracle PostgreSQL Snowflake Vertica Supported AS/400 InfiniDB Exasol 4 Firebird SQL Greenplum H2 Hypersonic IBM DB2 IBM MQ 9.2 Informix Ingres Ingres VectorWise MaxDB (SAP DB) Neoview Oracle RDB SQLite UniVerse database Other SQL-92 compliant*
* If your data source is not in this list and is compatible with SQL-92, Pentaho software uses a generic SQL dialect.