<< Click to Display Table of Contents >> Navigation:  Program use > Configuration > SQL data > Introduction

The SQL data interface allows to poll a database table in SQL-compatible databases (such as SQLBase, Oracle, Microsoft SQLServer, Sybase, DB2, Informix, Interbase, Firebird, MySQL, PostgreSQL) for new data and send the new data to other targets using data export plugins. For example, you can build SQL-to-DDE or SQL-to-OPC bridges, export SQL data to a text file and upload it to a server.

 

To access databases, the direct driver access methods provided by the developer of the corresponding database are used. It makes it possible to reduce system requirements, lower the traffic between database clients and servers, and, what is more important, use features unique for every database (for example, stored procedures in Microsoft SQLServer or Oracle).

 

If our module does not support direct access to some database, it is possible to work through the ODBC driver that is also supported by our module. Unlike our other module for ODBC Databases, this module provides broader opportunities for controlling the database connection and the process of executing databases operations and implements quite a new approach to data publishing.

 

The user can to create SQL queries himself.