Citect SCADA

Customer voice & ideas portal

SQL outside Cicode or mechanism for inserting data into different database with specific period

When we want use 3rd party tool like Grafana , Node Red, Wordpress and many others we need data from different database. Need a mechanism for transferring data from trend files to the database like MSSQL. MongoDB, MariaDB, MySQL but without write many scripts in cicode.

  • Guest
  • Mar 4 2025
  • Unlikely to implement
Idea business value

Clients want new reports with the new technology web service.

Idea priority 5 – Critical to my company
  • Attach files
  • Admin
    Nathan Slider commented
    15 May 03:10pm

    Please use the AVEVA Historian or AVEVA PI product. AVEVA provides purpose built tools for this need based off a True Time Series Historian functionality that provide superior reporting options and accuracy. Plant SCADA to AVEVA Historian and AVEVA PI Connectors are available that provide Store/Forward data protection.

  • Guest commented
    4 Mar 08:47am

    I agree and the customer does not want to pay extra for a historian solution, but wants to be able to write to a database in parallel with storing trend files.