SQL Database Professional
4.0.81 build 606. June 7, 2019.
"SQL Database Professional" data export module for Advanced OPC Data Logger is used for recording/saving variables the parser receives and extracts from the stream of bytes into SQL-compatible databases, such as SQLBase, Oracle, Microsoft SQLServer, Sybase, DB2, Informix, Interbase, Firebird, MySQL, PostgreSQL.
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.
In this module the user has to create SQL queries himself. If necessary, the user can form a queue of SQL queries that should be executed one after another.
To do it, the user must have certain skills, but it allows him to implement ideas and tasks unavailable in our program before, such as:
- Using stored procedures and other programmable database objects for recording data;
- Using functions and custom data types;
- Recording data into the tables that have links to other tables.
Download demo | Documentation | Buy now!