SQL dialect-specific

Try Pentaho Data Integration and Analytics

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
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.