Forum Stats

  • 3,854,604 Users
  • 2,264,390 Discussions
  • 7,905,741 Comments

Discussions

Materialized Views in OGG to MSSQL Target

User_5Y70F
User_5Y70F Member Posts: 25 Red Ribbon

Hi Guys,

SOURCE:

Oracle 12c

OGG 12.3

Oracle Linux 7 x64

TARGET:

MSSQL 2014 Std

OGG 12.3

Windows Server 2016

The client is trying to simplify the data set that is replicated to the MSSQL Target. They have created a Materialized View and they wish to ONLY replicate this MV, and NO underlying tables at all. Is it possible to replicate the resultant dataset of an MV on its own, wiht no other tables?

Thanks.

Tagged: