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 Non-certified Access Apache Derby** Firebird Greenplum Hsqldb IBM DB2 IBM MQ 9.2 Infobright Informix Ingres Interbase MonetDB Neoview Netezza SqlStream Sybase Teradata Vectorwise Vertica Other SQL-89 compliant*
Pentaho Metadata	Certified Azure SQL Hive 2 Impala MySQL PostgreSQL Non-certified 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) Netezza Oracle PostgreSQL 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 Non-certified Apache Derby** AS/400 InfiniDB Exasol 4 Firebird SQL Greenplum H2 Hypersonic IBM DB2 IBM MQ 9.2 Infobright Informix Ingres Ingres VectorWise MaxDB (SAP DB) MonetDB Neoview Netezza Oracle RDB SAP HANA SQLite Teradata 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.
** Apache Derby support is deprecated in future releases. For details, contact Support. See Apache Derby.