Sampling via ODBC can take place on any database for which interfacing via ODBC is available.

In particular, the data are recorded in a single table whose records are managed as a circular array: that is, a finite number of records is maintained. When the number of samples exceeds the specified number of records, the obsolete data is overwritten with the new data, starting with the oldest data.
An "ID" field is automatically created (if not already existing) for managing records as a circular archive.

The ODBC configuration window has a wizard for automatically creating the archive, table, and fields for Microsoft® Access 97 and Microsoft® Access 2000 formats. Alternatively, files can be created manually using the homonymous applications. For different formats, a data archive must be set up manually using the appropriate development application.


For the manual configuration of the data archive, keep in mind that:


    1. You need to prepare a table for storing sampled data.
    2. The format of the fields in the table must be compatible with the format of the sampled item fields. For example, the item item field must be addressed to database fields of type string / text, while the Value field requires fields in a format compatible with the double precision (except for text items: in this case, the Value field you need a  database field in text format!).