...
- Pentaho supports the JDBC API and explicitly documents the SQL dialect elements that are supported.
- Third-party tools may work with the thin Kettle JDBC driver but there are no immediate plans to certify third-party tools.
- We already support a broad range of SQL, but we are not SQL-92 compliant. A couple of tests with third-party tools can be found on our Examples page.
- The thin Kettle JDBC driver covers common types of queries that our Pentaho tools and products generate.
- For further details, please see the JDBC and SQL Reference page.