The data Buffer

Introduction : What is the Buffer ?

The primary source for data in Alpana is a database (SQL Server, Oracle).

When a Dashboard requires data from a Data Source that is based only on database Connections, the query is composed by Alpana and executed directly on the target database.

*except in multi-source : when the database Connection is used together with another Connection, it also becomes bufferized as multi-source (see next page)

On the other hand, Data that comes from other types of Connections, need to be bufferized : data is first fetched from the source and copied inside a Buffer database internal to Alpana, then Dashboards will query this Buffer.