AVEVA SQL Direct is a utility designed to connect AVEVA-based industrial applications with relational databases, enabling you to run SQL queries directly from your HMI/SCADA or operations environment. It streamlines data exchange without the need for complex middleware, allowing you to read and write production data, log events, manage recipes and setpoints, and feed reports or dashboards in near real time.
Key capabilities include executing parameterized queries, triggering transactions on schedules or events, and using your existing database security and authentication. Typical use cases include synchronizing production orders and inventory data, archiving process values to a central database, retrieving quality results for operators, and populating KPIs for analytics or reporting. Designed for teams that need a straightforward, reliable bridge between plant-floor systems and SQL databases, AVEVA SQL Direct helps reduce custom coding, simplify maintenance, and accelerate integration efforts.
AVEVA SQL Direct is developed by AVEVA Solutions Ltd. The most popular version of this product among our users is 12.0. The names of program executable files are PDMSServer.exe, TableDesigner.exe.
Comments