Data Storage

Data storage depends on the data table type (Published, Saved and so on), and the connection type (Database, Excel, CSV, and so on). Specifically:

q  Database (relational and tick history) or Message Queue

No physical data storage.

q  Flat Files (Excel, CSV, Text, XML and SVG)

If configured as a saved data table / workbook, no copy of the spreadsheet is made; instead the path to the original file is stored, allowing updates to be accessed.

If the data table / workbook is published, a snapshot of every defined Excel spreadsheet is copied to the server. To update a published spreadsheet, the data table must be again connected to the source spreadsheet and then re-published.