1 Reply Latest reply on Jul 24, 2016 7:23 PM by Ramesh Reddy

    Refreshing the views in Embedded teiid

    Sanjeev Kumar Newbie


      I am very  new to TEIID developement

      I have the requirement to refresh the materialized view everyday at 12 AM.

      I am creating foreign table and materialized view on those table in the vdb.

      Using the following options



      This refreshes the view everyday after strat but have no idea how to first refresh at eod.


      Can anyone please help me to list down the steps to achieve this. Else I need to restart the server at midnight.


      Neither the loadMatView call is working


      and not able to delete the view and insert into the view


      I am using teiid version 8.13.1


      Thanks in advance