In addition to quick measured values that are acquired via other interfaces, the SQL interface serves mainly to acquire additional data about a process, a plant or a product or to output current values, operating statuses or calculated values to a database. The access may occur by request or cyclically, whereby you must always take the response time of the database into consideration.

The corresponding data storage (e.g. ibaPDA-Data-Store-SQL-Server, ibaPDA-Data-Store-SQL-Oracle etc.) is to be used for faster continuous data writing in databases or cloud systems.

SQL interfaces and DB data storage support the same database systems so that you can choose.

Table Differences between SQL interface and DB/cloud data storage

SQL interface

DB/cloud data storage

  • Configuration in the I/O Manager (read/write)

  • Configuration as data storage (write only)

  • Access to any existing custom table/view is possible

  • The user must provide tables, e.g. by SQL statements

  • Fix table structure, specified by the data storage profile

  • Table is automatically generated by ibaPDA.

  • Cyclical/triggered reading with custom SQL queries

  • Cyclical/triggered inserting or updating with custom SQL commands

  • Continuous/triggered writing of signal trends as time series data

  • Reading the signal trends from the database with SQL trend queries in ibaAnalyzer

  • Reading the signal trends from the database with ibaDaVIS