OPC HDA Server for Microsoft SQL Server

Integration Objects' OPC HDA Server for Microsoft SQL Server is a PC-based software application that enables your OPC HDA Client to interface with any SQL database that is ADO compliant.

The OPC HDA Server for Microsoft SQL Server reads and updates data from/to the historical databases via the ADO (Active Data Objects) technology so that you can easily process and analyze the historical data found in your SQL database.

Product features:

• Multiple, simultaneous connections to SQL Server databases via ADO technology.
• Sophisticated graphical user interface, simple and easy to use for server/database configuration.
• Building and filling of the OPC server´s historical database using existing SQL scripts.
• Provides full access to historical data for any OPC HDA Client.
• Compliant with HDA OPC Clients requesting synchronous and asynchronous reads for:
• Raw data
• Data at time
• Processed data (such as interpolative, minimum, maximum, average, range and total aggregates)
• Modified data
• Item attributes
Compliant with HDA OPC Clients requesting synchronous and asynchronous updates to:
• Insert / Replace item values
• Delete Raw
• Delete at time
• Automatic reconnection to database servers when the connection is lost.
• Windows Service capabilities.
• Log event display and archiving.

Vendor: Integration Objects

view complete profile

Integration Objects is a world-leading systems integrator and solutions provider specializing in intelligent performance management, preventative detection of abnormal conditions, and automated root cause analysis. Integration Objects excels at optimizing customer’s business and manufacturing processes to maximize plant safety, increase asset availability, and facilitate better resolution decision-making. Together with industry insight and wide range of experience in over 30 countries, Integration Objects’ team of engineers and domain experts are always available to create integral links between business and operational objectives to assist customers obtain operations excellence.