https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514440#M14127 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/256279">@rheytens</a>&nbsp;,</P> <P>Yes the regular view can be used as <STRONG>Full Load ONLY task</STRONG>. please follow below steps:</P> <P>1. Create a task with Oracle source Endpoint</P> <P>2. <STRONG>Turn off the Apply Changes and Store Changes</STRONG>, keep Full Load enabled</P> <P>3. In the table selection window, choose the <STRONG>VIEW</STRONG>, as below sample:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="john_wang_0-1744724075627.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179647i28DA6C22529CAC6D/image-size/medium?v=v2&amp;px=400" role="button" title="john_wang_0-1744724075627.png" alt="john_wang_0-1744724075627.png" /></span></P> <P>Hope this helps.</P> <P>John.</P> Tue, 15 Apr 2025 13:35:09 GMT john_wang 2025-04-15T13:35:09Z https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514438#M14126 <P>I have a Source endpoint that is an ORACLE database from which I am able to read ORACLE table data.&nbsp; Is there a way to read data from an ORACLE non-materialized view?</P> Tue, 15 Apr 2025 13:27:46 GMT https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514438#M14126 rheytens 2025-04-15T13:27:46Z https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514440#M14127 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/256279">@rheytens</a>&nbsp;,</P> <P>Yes the regular view can be used as <STRONG>Full Load ONLY task</STRONG>. please follow below steps:</P> <P>1. Create a task with Oracle source Endpoint</P> <P>2. <STRONG>Turn off the Apply Changes and Store Changes</STRONG>, keep Full Load enabled</P> <P>3. In the table selection window, choose the <STRONG>VIEW</STRONG>, as below sample:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="john_wang_0-1744724075627.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179647i28DA6C22529CAC6D/image-size/medium?v=v2&amp;px=400" role="button" title="john_wang_0-1744724075627.png" alt="john_wang_0-1744724075627.png" /></span></P> <P>Hope this helps.</P> <P>John.</P> Tue, 15 Apr 2025 13:35:09 GMT https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514440#M14127 john_wang 2025-04-15T13:35:09Z https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514442#M14128 <P>That works!&nbsp; Thank you John.</P> Tue, 15 Apr 2025 13:42:43 GMT https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514442#M14128 rheytens 2025-04-15T13:42:43Z https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514443#M14129 <P>Perfect! thank you for your support&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/256279">@rheytens</a>&nbsp;!</P> Tue, 15 Apr 2025 13:43:50 GMT https://community.qlik.com/t5/Qlik-Replicate/Non-Materialized-View/m-p/2514443#M14129 john_wang 2025-04-15T13:43:50Z