Data Sources

Each WebPivotTable should connect to a data source.

Memory Mode

In memory mode, data is loaded into the browser's memory and all computations are performed in browser. WebPivotTable can parse data from a variety of sources and run completely on its own without back-end support.

Data can come from a data file or a data file link (Csv or Excel format), a google spread sheet or a web service which can be connected to any back end data sources, like SQL or NoSQL databases.

OLAP Mode

OLAP (online analytical processing) infrastructures enable users to analyze multidimensional data interactively. In OLAP mode, WebPivotTable can connect to an OLAP server that handles data and computation. WebPivotTable then acts as an interface for pivotting and displaying the data.

There are a lot of OLAP server implementations. Microsoft SSAS is a widely used commercial solution while open source solutions such as Mondrian, icCube and OLAPY are also supported by WebPivotTable.

Server Mode

Want to utilize the memory size and performance of a server to do your computations but not have to setup an expensive OLAP server? Server mode is the third mode offered by WebPivotTable which loads data and calculations from a dedicated server into the WebPivotTable client. Server mode acts exactly like memory mode but hands off computational tasks to a server setup to work with the WebPivotTable as a client.