The MatrikonOPC Server for Relational Databases (ODBC) supports both real-time and historical data access to ODBC and Oracle compliant databases. Users may map the OPC point name, value, quality and timestamp by ODBC source table column, custom queries or through pre-configured stored procedures. Applications that require connectivity to databases can use this MatrikonOPC Server to access real-time and historical process data that is archived by an online analyzer, laboratory personnel, etc. Previously known as OPC Server for GDA (Generic Database Access)
Key features include:
- Support for ODBC compliant databases such as Microsoft SQL, Oracle, Microsoft Access, Rockwell RSSQL, Sybase, etc.
- Access to both real-time and historical data
- Support for reading and writing
- Connects to multiple databases simultaneously
- Executes database functions and procedures with OPC point values filing in the parameters.
- Aggregates List: Average, Count, DurationBad, DurationGood, Interpolated, Maximum, MaximumActualTime, Minimum, MinimumActualTime, PercentBad, PercentGood, StandardDeviation, TimeAverage, Total, Variance, and more...
The MatrikonOPC Server for General Database Access (GDA) now has enhanced features including:
- Supports using column names as tag names
- User friendly help tab (dynamically changes based on the options that are selected for GDA Object Devlink)
- Includes BatchIDs and Insert TimeStamps (BatchID makes a group of Tags unique and Insert TimeStamp stores the Time at which the write was done on the tag value regardless of what the actual timestamp was)
- Includes a Server Devlink connection indicator (shows whether you are currently connected to the database or not)
