Refreshing the views in Embedded teiid

[sanjoo75]

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_MEMEORY	true
teiid_rel:MATVIEW_TTL	86400000
teiid_rel:MATVIEW_UPDATABLE	true
teiid_rel:MATVIEW_SCOPE	vdb

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

[rareddy]

Have you followed steps here External Materialization · Teiid Documentation? However these are for full server version, however there are extensions for this to work in embedded too. Look for MaterializationManager class, and follow and see what is not working for you.