I have an AF table that should contain 30 days of data pulled from an Oracle database. My idea is to have it refreshed once a day, at midnight (old data will be purged, and new data will be added to the table). So when the user accesses the data in the morning, the table will have already been refreshed.
I thought the option "Import" with a Cache Interval = 24 Hours would solve my problem, but I noticed that the table is populated only once, just after being configured. After I configured the "Import" option, the data remained static, even after new data were added to the external database.
Using a linked table is not an option, because it will bring the entire dataset to the client side (after the cache interval is expired of course), affecting the user experience. I also considered the idea of abandoning AF tables in favour of using RDBMS tags, but it would add more tag management complexity and unnecessary data replication.
Should I create a service to automatically update the AF table? Any ideas?
Your suggestions will be appreciated.