Enable your OPC clients to access historical data

Home > OPC Products > OPC Servers > OPC HDA Server for InSQL


	OPC HDA Server for InSQL

Integration Objects´ OPC HDA Server for InSQL is a PC-based software application that enables your HDA OPC Clients to interface and exchange data with the one or more Wonderware IndustrialSQL databases.

The OPC HDA server for InSQL reads and updates data from/to the historical databases via the ADO (Active Data Objects) technology so that you can process and analyze the archived data.

Product features:

Multiple simultaneous connections to diverse InSQL databases via ADO technology.
Sophisticated graphical user interface that is 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.

Operating System Compatibility

Windows 2003 Server (SP1)

Windows XP (SP1 & SP2)

Windows 2000 (SP4)

Windows NT4.0 (SP6a)

OPC compatibility

OPC Historical Data Access 1.00

OPC Historical Data Access 1.10

OPC Historical Data Access 1.20

OPC Foundation Self-Tested for Compliance logo is a trademark of the OPC Foundation and may be used only by written permission of the OPC Foundation. Any unauthorized use of the Self-Tested for Compliance logo is prohibited. OPC Foundation Self-Tested for Compliance logo indicates that this product has been tested by the manufacturer to be compliant with the following OPC Specifications:

Historical Data Access 1.00
Historical Data Access 1.10
Historical Data Access 1.20

Additional information about compliance testing, logo program and a summary of test results for OPC HDA Server for InSQL 1.0.1 can be found at www.opcfoundation.org.


	Date:04/14/2009 Integration Objects´ products pass OPC Foundation Compliance Testing Integration Objects is pleased to announce that five of their OPC software products have passed the OPC Foundation's Self-Tested Compliance test. The following products are now OPC Foundation Compliance certified: OPC HDA Server Enterprise, OPC HDA Server for InSQL, OPC HDA Server for MS Access, OPC HDA Server for Oracle and the OPC HDA Server for SQL Server. The "Self Tested" level of testing provides a process where OPC vendors can verify the correct operation of their products with a series of tests developed by the OPC Foundation. These tests determine what features of OPC specifications the product supports and verifies that these features are correctly implemented. You can find our product listing on the OPC Foundation website at the following address: http://www.opcfoundation.org/Products/CompanyDetails.aspx?CM=1&RI=149&CU=5 . ------------------- Date:03/12/2009 New White Paper Published Open Architectures to Improve Plant Visibility and Performance This paper discusses some of the options available for integrating automation islands and for distributing information at any level in the organization. Real world examples will be presented to show benefits provided by open architectures. To access the rest of the article, please follow this link: New White Paper ------------------- Date:11/24/2008 Upgraded version of OPCNet Broker released: Now DA and HDA compliant! Upgraded version of OPCNet Broker released OPCNet Broker� DA HDA for industrial network security and connectivity ensures fast, reliable, and secure OPC remote communication by bypassing DCOM bottlenecks and by tunnelling data through multiple firewalls and domains. To access the rest of the article, please follow this link: OPCNet Broker Article ------------------- Date:11/04/2008 New release of the OPC Data Transfer OPC Data Transfer Manufacturers now have a simple and secure solution to enable their different control systems to exchange data. To access the rest of the article, please follow this link: OPC Data Transfer Article -------------------

Date:02/17/2009

Webinar: OPC Training Institute� on February 26th� 2009. Register at http://www.opcti.com/webinars.aspx

Integration Objects will co-host a webinar with their partner, the OPC Training Institute, on February 26th, 2009. The webinar is entitled "Upgrading or Expanding Control Systems: What every integrator needs to know". Visit http://www.opcti.com/webinars.aspx to register and please find below further information regarding this informative webinar. The majority of plant upgrades or expansion projects go overtime and over-budget. This is due in part to retrofitting new systems within existing infrastructure. Join the OPC Training Institute and Integration Objects for an online webinar to see how some integrators are cutting costs and time using standards-based technology. Automation personnel, integrators, process control engineers, IT architects and others involved in plant and manufacturing operations are invited to attend the live, online presentation to learn the tools and techniques used to share industrial data among multiple systems and applications. Find out how to:

Consolidate plant information in a single console

Deploy a console-replacement solution

Connect two DCSs together

Gather data from disparate control systems

Integrators frequently use OPC technology to connect one Industrial Automation system (PLC, DCS, SCADA, HVAC, etc) with another so data can be shared between the two systems. OPC technology is based on the Client/Server architecture and so technically, two OPC Servers cannot communicate with each other directly. A variety of vendors provide an intermediate software solution, generically called an "OPC Bridge," to facilitate communication between servers. The OPC Data Transfer from Integration Objects is one example of such OPC bridge software. Join the webcast and learn how to fast-track your project to completion using off-the-shelf, standards-based solutions.
For more information and to register for the webinar in any of the available times, please follow this link: http://www.opcti.com/webinars.aspx.

-------------------

OPC HDA Server for InSQL

Integration Objects´ products pass OPC Foundation Compliance Testing

New White Paper Published

Upgraded version of OPCNet Broker released: Now DA and HDA compliant!

New release of the OPC Data Transfer

Webinar: OPC Training Institute� on February 26th� 2009. Register at http://www.opcti.com/webinars.aspx