SQL dialect-specific

Try Pentaho Data Integration and Analytics

Version
9.4.x
Audience
anonymous
Part Number
MK-95PDIA000-12
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
  • Netezza
  • SqlStream
  • Sybase
  • Teradata
  • 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)
  • Netezza
  • 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
  • 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.