USER MANUALS

Data Sources That Support Merge Data

The following list show the databases for which Virtual DataPort provides support for the INSERT INTO view ON DUPLICATE KEY UPDATE <SELECT QUERY> command and for preloading the cache of a view using the parameter 'cache_invalidate' = 'matching_pk' (see Incremental Cache Loads Updating the Existing Cached Data for more info):

  • Alibaba ApsaraDB for OceanBase MySQL

  • Alibaba ApsaraDB RDS for MySQL

  • Alibaba ApsaraDB RDS for PostgreSQL

  • Alibaba ApsaraDB RDS for Microsoft SQL Server

  • Alibaba ApsaraDB PolarDB for MySQL

  • Alibaba ApsaraDB PolarDB for PostgreSQL

  • Alibaba ApsaraDB AnalyticDB for MySQL

  • Alibaba ApsaraDB AnalyticDB for PostgreSQL

  • Amazon Aurora PostgreSQL

  • Amazon RDS for Microsoft SQL Server

  • Amazon RDS for MySQL

  • Amazon RDS for Oracle

  • Amazon RDS for PostgreSQL

  • Amazon Redshift

  • Azure SQL

  • Azure Synapse SQL (aka Azure SQL Data Warehouse)

  • Databricks

  • Denodo Lakehouse Accelerator (Java engine)

  • DB2 9, DB2 9 for z/OS, DB2 10, DB2 10 for z/OS, DB2 11 and DB2 11 for z/OS

  • Exasol 7 and higher

  • GCP Cloud SQL for MySQL

  • GCP Cloud SQL for PostgreSQL

  • Google BigQuery

  • Impala 3.x Kudu

  • Huawei GaussDB

  • Microsoft SQL Server 2012 and higher

  • MySQL 5 and higher

  • Netezza 5.0 and higher

  • Oracle 9i and higher

  • PrestoDB 0.297 and higher

  • PostgreSQL 9 and higher

  • SAP HANA 1 and SAP HANA 2

  • Snowflake (bulk data load must be enabled)

  • Teradata 15 and higher

  • Trino

  • Vertica 7 and higher

Remarks

Impala 3.x Kudu requires to use an Impala JDBC driver version 2.6 or newer. Virtual DataPort will display the following error enabling the cache of a view when the data source uses an older version of the Impala JDBC driver:

IllegalArgumentException: table owner must not be null or empty), Query: CREATE TABLE c_v165564992760190038174463474 (field1 INT, rowStatus STRING, expirationDate BIGINT , PRIMARY KEY (field1, rowStatus)) STORED AS KUDU
Add feedback