Solution
DIAdem can load data from the following types of databases:
- ODBC / SQL / ADO databases (Access, SQL-Server, Oracle, ...)
- Citadel databases (Citadel 4 and up, VI Logger database)
- ASAM ODS databases
DIAdem can select database data using the following methods:
- Interactive tree-view dialogs using data stores in the NAVIGATOR panel
- SQL queries using DIAdem's built-in ODBC functions in a VBScript
- SQL queries using ADO object variables in a VBScript
- ODS queries using DIAdem's built-in ODS functions in a VBScript
Recommended combinations of the databases (1-3) and selection methods (a-d):
- a. NAVIGATOR supports only the selection of ENTIRE table columns (no WHERE clause)
b. Simple DIAdem SQL functions, ideal for viewing results in a SUDialog
c. Superior record/recordset control, required for reading BLOB fields - a. Select Trace by Trace. Filter options: time slice, events / constant delta time
- a. NAVIGATOR panel provides full ASAM ODS search and filter options
d. Fully automate data retrieval from an ASAM ODS database
NON-Recommended combinations of the databases (1-3) and selection methods (a-d):
- d. Run an import VBScript based on selection in Data Navigator (read String Columns)
- b. Possible, but not straightforward or especially fast with Citadel 4
c. Possible, but not straightforward or especially fast with Citadel 4
d. Run an import VBScript based on selection in a data store available in the NAVIGATOR panel (read String Traces) - b. Defeats the purpose of having an expensive ASAM ODS server layer
c. Defeats the purpose of having an expensive ASAM ODS server layer