Skip to content

TSTool / Datastore Processing

This documentation provides information about datastore processing.


Introduction

TSTool implements "datastores" as data sources that provide time series and other data. A datastores may provide integration with a databases, web services, or other data souces. See the Datastores Overview for an overview. TSTool datastore features include interactive data browsing and commands to automate processing.

Example use cases include:

  • downloading time series and other data from web services
  • running SQL statements on a database and creating and manipulating databases
  • creating SQLite databases to distribute data
  • comparing the contents of datastores
  • creating an HTML data dictionary for a database

Commands

Datastore processing commands are found in the Commands / Datastore Processing menu.

Some commands, such as ReadTableFromDataStore are useful for querying database into tables, which can then be processed using Table Processing commands.

The NewSQLiteDatabase and RunSql commands can be used to publish a database, such as a collection of time series and other data.

TSTool User Interface

Datastore information can be listed using the View / Datastores menu.

Because datastores are used as input, there is no corresponding tab in the Results area.

Examples

See the Examples section of command documentation.