OPC Server for Microsoft SQL

Deploy OPC Server for Microsoft SQL to easily share your data through OPC!

Integration Objects’ OPC Server for Microsoft SQL is a feature component of OPC Driver for Databases. This OPC Server software provides your OPC clients with full access to data collected from one or more SQL databases using ADO technology. Your OPC Clients will be able to read and update data from/to your SQL database. This OPC Server supports both OPC data access and historical data access.

With this level of connectivity, you can have all of your real-time and historical process data at your fingertips and ready to be processed and analyzed. For example, you can make your historical data available to third-party applications for analysis and reporting purposes. Or, you can use the OPC server to synchronize data between historians.

This OPC server for SQL is the bridge that you have been looking for to establish an OPC link between your enterprise databases and control systems such as SCADA, DCS, HMI or historians. With this OPC link, users will be able to transfer SQL data to OPC based systems. The transferred data can be real-time data, raw historical data or processed data using aggregations such as interpolation, minimum, maximum, average, range, and total.

OPC Server for Microsoft SQL

Product Features

  • Multiple and simultaneous connections to diverse databases via ADO
  • Sophisticated graphical user interface, simple and easy to use for server/database configuration
  • Building and filling of the OPC servers historical database using existing SQL scripts
  • Full access to real-time data for any OPC DA Client
  • Support of OPC DA synchronous/asynchronous read and write requests
  • Full access to historical data for any OPC HDA Client
  • Compliant with OPC HDA Clients requesting synchronous and asynchronous reads for:
  • Compliant with OPC HDA Clients requesting synchronous and asynchronous updates to:
  • Automatic reconnection to database servers when the connection is lost
  • Windows service capabilities
  • Log event display and archiving

Operating System Compatibility

  • Windows XP SP2
  • Windows Seven
  • Windows Server 2003 SP1
  • Windows Server 2008
  • Windows 8
  • Windows Server 2012
  • Windows 10
  • Windows Server 2016

OPC Compatibility

  • OPC Data Access 1.0a
  • OPC Data Access 2.00
  • OPC Data Access 2.05a
  • OPC Data Access 3.00
  • OPC Historical Data Access 1.00
  • OPC Historical Data Access 1.10
  • OPC Historical Data Access 1.20

Does this product meet your needs?

Spotlight

OPC Easy Archiver

OPC Easy Archiver

Historize OPC DA and HDA data into a database or flat files using OPC Easy Archiver!
OPC Easy Archiver collects real-time and historical data from multiple OPC DA/HDA [. . .]

Increasing your data availability and visibility
OPC Server Enterprise

OPC Server Enterprise

Use OPC Server Enterprise to access your historian data via OPC!
Integration Objects’ OPC Server Enterprise is a plug and play OPC server software. It provides OPC DA and HDA [. . .]

Deploy an open architecture for your databases
OPC Server for Oracle

OPC Server for Oracle

Use OPC Server for Oracle and easily deploy an OPC interface to your Oracle database!
The OPC Server for Oracle is a feature component of OPC Driver for Databases. This [. . .]

Deploy an open architecture for your Oracle historian
OPCNet Broker DA

OPCNet Broker DA

Avoid DCOM configuration issues with OPCNet Broker DA
Tired of DCOM issues complicating connectivity between your OPC systems? Or looking for an easy solution to secure your OPC communications? OPCNet [. . .]

Protecting your assets while maintaining reliability and availability