Allows the user to build simple or complex applications for data mining and processing. OpcDbGateway represents a utility product that can be categorized as a supervisory system. The basic feature is the data acquisition from external devices (sensors, actuator, programmable machines...), data processing, data storage in process databases and files, delivery of processed data to other applications. The system by its structure, based on paralel event data processing, periodical or single-shot launching of external programs and scripts at specified time, allows the user to build simple or complex applications for data mining and processing, logging, alarms, generating printed reports, control and monitoring of processes and communication infrastructure in a user-friendly and easy way.

OpcDbGateway program package consists of:
1. configurator with user interface for creation, debugging and eventually monitoring of software configuration
2. runtime without user interface (implemented as NT service or as out of process server - exe that ensures the execution of all tasks defined in the application's configuration (project)

OpcDbGateway Features:
1. Monitoring, management, control, processing data archives
2. Processing and alarm management
3. Generating reports
4. Starting external programs
5. Data provider between more OPC servers
6. Interface between external OPC servers and a database system
7. Executing of SQL commands for data manipulation in process databases
8. Multiple database connections to process databases at the same time
9. Sending of status information about monitored processes via e-mail
10. Configuration can be loaded or saved for later use
11. Using standard OPC and ODBC interfaces, but concept is open for latest technologies as XML, Web Services, OPC UA
12. The data from OPC sources can be archivated into various databases
13. Reports can be generated in several formats including XML, TXT, CSV, HTML
14. Server can communicate with multiple OPC servers at the same time. It can read from one server and write to another. Its easy to create a bridge between two or more OPC servers.
15. Provides a set of functions for statistic calculation and data extrapolation
16. Can start executable programs and scripts
17. Can execute SQL statement
18. Has implemented alarm system

To configuration OpCDbGateway it is necessary to perform four steps as follows:
1. definition of external OPC servers and data processed by them
2. definition of particular process databases, waysof accessing them and their structure
3. definition of operations that should be executed together with data in synchronous controller
4. definition of internal OPC server's address space

The configuration of external OPC server that provides data to/from a device can have a outstanding number of variables. To transfer these variables into OpcDbGateway configuration, it possible to use the in-built external OPC server configuration mapping function and this way to save lot of work.

Limitations:
* 1 hour running after every start

The license of this software is Free Trial Software, the price is $1699.00, you can free download and get a free trial.