HVR 5: How To Capture From an Oracle Materialized View

Edit on GitHub

Matt Taylor Fivetranner

Issue

How do I capture from an Oracle Materialized view?

HVR 5

HVR cannot replicate from a view in Oracle however it can do log-based capture on Oracle Materialized Views from Oracle.

A materialized view is just a table that is periodically updated by Oracle using view definition.

In HVR Table Select/ Table Explore can select materialized views and whenever this materialized view is updated it is replicated as a normal table.

On the target, the contents of the materialized view will be replicated to a regular table.