Cache Target | TDV Support | Parallel Cache Target Support | Native Cache Target Support | Notes |
Amazon Redshift | Active | Active | Active | |
Apache Hive 2.x | Active | Active | ||
File | Active | Active | Typically best for demonstrations or caching of a few hundred rows. | |
Google BigQuery | Active | Active | Active | |
Greenplum 4.1 | Active | Active | Active | |
Greenplum 4.3 | Active | Active | Active | |
HSQLDB 2.2.9 | Active | Active | ||
Impala | Active | Active | ||
IBM DB2 LUW v10.5 | Active | Active | Active | Native load with insert and select, and DB2 Load are supported. |
Microsoft SQL Server 2008 | Active | Active | Active | The DBO schema must be selected and introspected as a resource prior to attempting to cache data. |
Microsoft SQL Server 2012 | Active | Active | Active | The DBO schema must be selected and introspected as a resource prior to attempting to cache data. |
Microsoft SQL Server 2014 | Active | Active | Active | The DBO schema must be selected and introspected as a resource prior to attempting to cache data. |
Microsoft SQL Server 2016 | Active | Active | Active | The DBO schema must be selected and introspected as a resource prior to attempting to cache data. |
Microsoft SQL Server 2019 | Active | Active | Active | The DBO schema must be selected and introspected as a resource prior to attempting to cache data. |
MySQL 5.1 | Active | Active | Active | |
MySQL 5.5 | Active | Active | Active | |
Netezza 6.0 | Active | Active | Active | Native load with insert and select is supported. Parallel cache processing is achieved using the native DISTRIBUTE syntax. Procedure caching is supported. |
Netezza 7.0 | Active | Active | Active | Native load with insert and select is supported. Parallel cache processing is achieved using the native DISTRIBUTE syntax. Procedure caching is supported. |
Oracle 11g and 11g R2 | Active | Active | Active | |
Oracle 12c | Active | Active | Active | |
Oracle 19c | Active | Active | Active | |
PostgreSQL 9.1 | Active | Active | Active | Bulk load is supported. Native loading is supported when the source and target are the same database. If not then Parallel loading is used. |
PostgreSQL 9.2.3 | Active | Active | Active | Bulk load is supported. Native loading is supported when the source and target are the same database. If not then Parallel loading is used. |
SAP HANA SPS 09 | Active | Active | ||
Singlestore | Active | Active | Active | |
Snowflake | Active | Active | Active | |
Sybase ASE 12.5 | Active | |||
Sybase ASE 15.5 | Active | |||
Sybase IQ 15.2 | Active | Active | ||
Teradata 13 | Active | Active | Supported, but with limitations. If source and target tables are co-located within the same Teradata instance native loading (using INSERT/SELECT statements) will be used, else bulk loading using Teradata FASTLOAD will be attempted. | |
Teradata 13.10 | Active | Active | Supported, but with limitations. If source and target tables are co-located within the same Teradata instance native loading (using INSERT/SELECT statements) will be used, else bulk loading using Teradata FASTLOAD will be attempted. | |
Teradata 14.10 | Active | Active | Supported, but with limitations. Might require Teradata 15 driver. If source and target tables are co-located within the same Teradata instance native loading (using INSERT/SELECT statements) will be used, else bulk loading using Teradata FASTLOAD will be attempted. | |
Teradata 15 | Active | Active | Choose tables For Caching is not supported. If source and target tables are co-located within the same Teradata instance native loading (using INSERT/SELECT statements) will be used, else bulk loading using Teradata FASTLOAD will be attempted. | |
Teradata 16.20 | Active | Active | Choose tables For Caching is not supported. If source and target tables are co-located within the same Teradata instance native loading (using INSERT/SELECT statements) will be used, else bulk loading using Teradata FASTLOAD will be attempted. | |
ComputeDB | Active | Active | Active | |
Vertica 6.1 | Active | Active | Active | Supports the use of native load and parallel cache load together. Native load with INSERT AND SELECT is supported. |