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

    Refreshing the views in Embedded teiid

    Sanjeev Kumar Newbie

      Hi

      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

      teiid_rel:MATVIEW_PREFER_MEMEORYtrue
      teiid_rel:MATVIEW_TTL86400000
      teiid_rel:MATVIEW_UPDATABLEtrue
      teiid_rel:MATVIEW_SCOPEvdb

       

      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