Buffer Refresh settings

What is Buffer Refresh Settings

This setting represents : How long do you want to query the old data in the buffer instead of getting new data from the source ?

For example

You connect to an Excel file.
The data is first copied in the buffer.
If you don’t set up Buffer Refresh Settings, it will never be updated.
If you set up “Refresh Every 1 Week”, it will not be update for 1 Week.
Then, the next time someone makes a query to this Connection, new data is copied in the Buffer.

Where to set up

Each Connection has its own refresh settings.

You can change the refresh duration by default at the Connection creation (or edition).
Just edit the Connection, and set up “Buffer Refresh Settings” with following options as shown below

Displayed options are

• Disabled: The connection or connections will never refresh its data thus the current buffer will never update respective data of the non relational connection or the multi-data-source the connection is associated with.
• Age of Data : If enabled, this option would make Alpana query the actual source of the non relational connection or multi source connections for the defined time interval.
• Always: This would always force the buffer to be refreshed wether the connection is relationnal or not.