Support PostgreSQL Inheritance Tables as Source Objects in HVR CDC

Which connector?: Postgres/Aurora Postgres

Additional details:

(TMNA) is currently migrating multiple PostgreSQL CDC workloads from Qlik Replicate to Fivetran HVR.

During migration assessment, we identified several PostgreSQL source tables that are implemented using table inheritance. These tables are currently replicated successfully in Qlik Replicate but cannot be discovered or added in HVR due to the current product limitation:

HVR supports capture from regular tables but does not support capture from inheritance tables.

This limitation is creating a migration blocker for several production and strategic data integration workloads. Multiple inherited child tables are not visible and accessible to the HVR Postgres Source

The source service account can successfully:

Query information_schema.tables
Query information_schema.columns
Access table metadata
Access table data

Migration Impact

This limitation introduces a functional gap between Qlik Replicate and Fivetran HVR.

Qlik Replicate currently supports replication of these inheritance-based structures and allows customers to migrate data from such environments.

During migration from Qlik Replicate to HVR:

Existing replicated tables cannot be onboarded to HVR.
Additional redesign effort is required at the source database level.
Customers may need to create intermediate views or redesign inheritance implementations.
Migration timelines and adoption of HVR are impacted.

Requested Enhancement

Support PostgreSQL inheritance tables as source capture objects by providing one or more of the following capabilities:

Option 1 - Full Native Support

Allow HVR to:

Discover inheritance child tables
Add inheritance child tables to channels
Capture CDC directly from inheritance child tables

Option 2 - Controlled Support

Introduce a PostgreSQL location option such as:

Enable Capture of Inheritance Tables

Discover Inheritance Child Tables

Expected Benefits

Simplifies Qlik Replicate → HVR migrations.
Eliminates migration blockers for PostgreSQL customers using inheritance.
Reduces source database redesign requirements.
Improves feature parity with legacy replication platforms.
Expands HVR adoption for PostgreSQL CDC workloads.

TMNA is migrating multiple Aurora PostgreSQL workloads from Qlik Replicate to Fivetran HVR. Several business-critical EBOM tables are implemented using PostgreSQL inheritance and are currently replicated successfully through Qlik. These tables cannot be discovered or onboarded in HVR, creating a migration gap and requiring source-side redesign.

Support for PostgreSQL inheritance tables would significantly reduce migration effort and enable seamless onboarding of existing PostgreSQL CDC workloads into HVR.

REF:

Table Types

HVR supports capture from regular tables.
HVR does not support capture from inheritance tables.
PostgreSQL as Source - HVR 6 | Fivetran Documentation

IN QLIK but it supports CDC for child tables:

When Support partitioned tables in CDC is enabled in the Advanced tab, the following DDLs are not supported:
- Drop partition
- Detach partition
- Attach partition - with data
When using the Parallel Load feature, table segmentation according to partitions or sub-partitions is not supported.

https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Aurora%20PostgreSQL/aws_limitations_postgresql_source.htm#ar_postgresds_802412600_1652565

Community