Database extraction is an integral function of ibaAnalyzer and is enabled during the installation of ibaAnalyzer. All data in iba measurement file (*.dat) format originating from ibaPDA, ibaQDR, ibaLogic or third-party applications that use the ibaFiles library can be easily extracted, transformed and loaded.

ibaAnalyzer can open iba measurement files (*.dat), which have a lossless and very efficiently compressed binary format. This makes it easy to handle large volumes of data. All the functions of ibaAnalyzer can be used to transform or generate the required (virtual) signals. Specifying storage profiles for database extraction allows re-sampling or aggregation of measurement data and virtual signals. This means that every data extraction can lead to a significant reduction of disk space by compressing information. ibaAnalyzer supports several databases: Microsoft SQL Server (local or in MS Azure Cloud), Oracle, DB2-UDB, MySQL/Maria-DB, PostgreSQL and SQLite. These databases may be located on the same computer or installed on a separate database server that has a network connection to the ibaAnalyzer computer. If you want to use other databases, please contact iba support.

ibaDaVIS, ibaDatManager, MES (Manufacturing Execution Systems), DWH applications (DataWareHouse) or e.g. other database-based cloud applications can easily integrate the data provided, as data handling can be performed using standard database tools and access methods.

Please note that this would be impossible in most cases with the very large raw datasets.

ibaAnalyzer treats the values extracted into a database as if they were values in DAT files. It is possible to query this data using a query builder or direct SQL commands. Data aggregated on a file basis can be used for long-term analyses (trend queries). In addition, these trend queries provide a navigation view for drill down analyses, which can be based on database values or the linked original files.

Alternatively, iba offers further extensions of ibaAnalyzer for extraction into new iba data files or ASCII files as well as into files of the COMTRADE, TDMS, MatLab or Parquet formats, see Data export and extraction .

Summary of the most important functions:

  • Data extraction from iba DAT files

  • Data transformation or generation of new virtual signals

  • Data loading into databases via ADO.NET interface

  • Data detail analyses from database instead of DAT files

  • Data trend analyses based on aggregated values

  • Data drill down option from trend to detail