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:

• Database (relational and tick history), Message Queue or CEP Connections

This has no physical data storage. 

• Flat Files

• • Excel

  • CSV

  • Text

  • XML

  • 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.