OPC Data Archiving

OPC Data Archiving

Use Integration Objects’ OPC client solutions for OPC data archiving to centralize your OPC data into databases or save them into flat files

Integration Objects’ OPC Data Archivers are advanced OPC clients software allowing users to connect to multiple OPC servers to collect real-time process data, historical process data or alarms and events from various process and automation data sources connected through the network and historize those data into relational databases or flat files.

The supported databases are Microsoft SQL Server, Oracle, MySQL, Microsoft Access or any other ODBC or ADO-compliant database.

Our OPC client software solutions for OPC data archiving are available for download for trial purposes.

1. OPC Logger for CSV

Download the OPC Logger for CSV and save your OPC data into CSV files

The OPC Logger for CSV is a feature component of OPC Easy Archiver. It provides users with an easy way to connect to one or more OPC DA and OPC HDA servers, to pull real-time and historical data, and to save the OPC data into CSV flat files.

This OPC archiver product enables users to archive the data they require at a suitable frequency within few clicks. Output CSV files can later be useful for data simulation and data analysis needs.

Product Features

·Fully compliant OPC DA & HDA client

·Browsing all local or remote OPC DA & HDA servers connected to the network

·Connection to one or more local and remote OPC DA & HDA servers at the same time

·Browsing any OPC DA & HDA server address space

·OPC DA synchronous and asynchronous group reads as well as report by exception (data changes)

·OPC DA synchronous and asynchronous data writes

·OPC HDA synchronous/asynchronous reads and updates, with annotations' support. A Loop manager is also available to allow you to schedule and automatically send synchronous and asynchronous requests.

·Archiving OPC data into CSV files and automatic creation of CSV files on configurable periodicity

·Automatic reconnection to OPC servers when the connection is lost

·Rule management functionalities

·Windows service capability

·Log event display and archiving

Operating System Compatibility

Windows XP SP3

Windows 7

Windows 8

Windows 10

Windows Server 2003 SP2

Windows Server 2008

Windows Server 2012

Windows Server 2016

Windows Server 2008 R2

Windows Server 2012 R2

OPC Compatibility

OPC Data Access 3.00

OPC Data Access 2.05

OPC Data Access 2.00

OPC Data Access 1.0

OPC Historical Data Access 1.10

OPC Historical Data Access 1.20

2. OPC HDA Logger for CSV

OPC HDA Logger for CSV stores your OPC historical data into CSV files!

The OPC HDA Logger for CSV is a feature component of OPC Easy Archiver. It provides users with an easy way to connect with OPC HDA servers, pull historical data, and record the OPC data into CSV flat files.

This OPC recorder product enables end users to archive the data they require at a suitable frequency. Moreover, it does not require involvement from database administrators. Thus, they can later use the output CSV files for specific data simulation and data analysis reasons.

Product Features

·Fully compliant OPC HDA client

·Browsing all local or remote OPC HDA servers connected to the network

·Connection to one or more local and remote OPC HDA servers at the same time

·Browsing any OPC HDA server address space

·Archiving OPC data into CSV files and automatic creation of CSV files on configurable periodicity

·Automatic reconnection to OPC servers after network glitches

·Windows service capability

·Log event display and archiving

3. OPC DA Logger for CSV

Download OPC DA Logger for CSV and save your OPC data into CSV files

The OPC DA Logger for CSV is a feature component of OPC Easy Archiver. It provides users with an easy way to connect to multiple OPC DA servers, gather real-time data, and save them into CSV files.

The OPC DA Recorder for CSV product enables users to archive their data within few clicks. Moreover, it does not require involvement from database administrators. Consequently, they can use the output CSV files for data simulation or analysis purposes.

Product Features

·Fully compliant OPC DA client

·Browsing all local or remote OPC DA servers connected to the network

·Connection to one or more local and remote OPC DA servers at the same time

·Browsing any OPC DA server address space

·OPC DA synchronous and asynchronous group reads as well as report by exception (data changes)

·OPC DA synchronous and asynchronous data writes

·Archiving OPC data into CSV files and automatic creation of CSV files on configurable periodicity

·Automatic reconnection to OPC servers when the connection is lost

·Rule management functionalities

·Windows service capability

·Log event display and archiving

4. 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 Servers and stores them in standard databases. It supports Microsoft SQL Server, Azure SQL, Oracle, IBM DB2, MySQL, Microsoft Access, PostgreSQL and CSV files. You can also use it to connect to databases via OLEDB and ODBC drivers.

Users can use the archived data for trend analysis, a sequence of events, calculations, and reporting.

Also, with the OPC Easy Archiver, you can also set up data transfer from databases to OPC DA Servers.

OPC Easy Archiver provides an affordable and reliable solution to increase data availability and empower users with insights about plant’s operations performance.

Moreover, users can configure rules to supervise a list of critical tags. For example, they can schedule to execute actions automatically when detecting specific statuses, such as sending notification emails, overwrite data values or start/stop archivers.

Product Features

·Fully compliant OPC DA and HDA client

·Browsing all local or remote OPC DA and HDA servers available within the network

·Connection to one or more local and remote OPC DA and HDA servers at the same time

·Browsing any OPC DA and HDA server address space

·Monitoring OPC Item changes (value, quality, and timestamp) over time

·OPC DA synchronous and asynchronous group reads and writes

·Data transfer and historization from OPC DA/HDA servers to any database

·Databases to OPC DA servers data transfer

·Continuous monitoring of the OPC and database servers' connection

·Automatic reconnection to OPC servers when the connection is lost

·Rule management functionalities

·Automatic reconnection to database servers when the connection is lost

·Windows service capability

·Log event display and archiving

5. OPC AE Archiver

Download OPC AE Archiver to collect and store OPC alarms and events into any database!

OPC AE Archiver collects OPC AE data and historizes them to an ADO/ODBC compliant database. This OPC data collector can monitor alarms and events from multiple OPC AE servers. It supports relational databases such as Oracle, MySQL, Microsoft SQL Server and Microsoft Access. You can also store your OPC alarms into Excel or CSV files.

OPC AE Archiver enables filtering on alarms and events, using criteria such as event type, category, areas, sources, and severity.

OPC AE Archiver manages OPC Server redundancy, allowing users to designate backup servers in case the primary OPC server goes offline. Users can also export the configuration of the archiver, in order to import it when needed.

Using this OPC AE historian, you will have a complete historical record of your plant events and alarms thus empowering you with a sequence of events. Consequently, it gives users a broader perspective of their plant activities which can improve the plant performance.

Product Features

·A fully compliant OPC AE Client software

·OPC Alarms and Events notifications, visualization, grouping, sub-grouping, and acknowledgement

·OPC alarms and events archiving in CSV files, XML files or any ODBC or ADO-compliant database

·Sophisticated graphical user interface that is simple and easy to use

·Automatic reconnection to OPC servers when the connection is lost

·Automatic reconnection to database servers when the connection is lost

· Windows service capabilities guaranteeing automatic restart when the host machine is restarted

·OPC server redundancy

·Log event display

6. OPC DA HDA Archiver

Transfer OPC DA and HDA data to a database or flat files using OPC DA HDA Archiver!

Integration Objects’ OPC DA HDA Archiver includes all of the features of the OPC Easy Archiver.

OPC DA HDA Archiver is powerful historian tool. It communicates with OPC DA or HDA servers and retrieves real-time and historical data from the various process and sources.

Furthermore, this OPC data historian stores the collected data in CSV files, or in ODBC or OLEDB compliant databases such as Oracle, MySQL, Microsoft SQL Server, Microsoft Access and PostgreSQL.

This OPC Archiver provides an intuitive user interface to graphically configure OPC data, database connections, historical data loops, transfers, and rules.

Users can centralize their plant data archives within few clicks for further processing, reporting, and analysis.

Product Features

·Fully compliant OPC DA/HDA client

·Sophisticated graphical user interface and simple to use

·OPC DA synchronous and asynchronous group reads and writes

·Automatic reconnection to database servers when the connection is lost

·Bi-directional data transfer between OPC servers and any compliant ODBC or ADO database

·Automatic reconnection to OPC servers when the connection is lost

·Windows service capabilities

7. OPC Client for Microsoft SQL Server

Archive your OPC data into a SQL database using the OPC Client for Microsoft SQL Server!

Integration Objects’ OPC Client for Microsoft SQL Server is a feature component of OPC Easy Archiver. In fact, this OPC client allows you to perform a bi-directional data transfer between one or more OPC DA servers connected to your network and any SQL Server database.

Using this OPC Client, you will have a complete historical record of your plant data within a few clicks. Then, you can use the archived data for trend analysis and reporting purposes.

The SQL OPC Client can provide you with valuable insights about your plant’s operational deviations. This information enables you to make informed decisions so that you can improve your system performance.

Product Features

·Fully compliant OPC DA client

·Connection to one or more local or remote OPC DA servers at the same time

·Browsing of the entire address space for any OPC DA server

·Monitoring of OPC item changes (value, quality, and timestamp) over time

·OPC DA synchronous and asynchronous read and write requests

·Bi-directional data transfer between OPC DA servers and SQL Server databases

·Automatic reconnection to OPC Servers when the connection is lost

·Alerts and rules configuration : using the OPC Client for SQL, you can configure a list of critical tags to supervise by setting rules and planning actions to be automatically undertaken when these rules become valid

·Windows service capabilities

·Log event display and archiving

8. OPC Client for MS Access

Store your OPC data into a Microsoft Access database using the OPC Client for MS Access !

Integration Objects’ OPC Client for MS Access is a feature component of OPC Easy Archiver. This OPC client provides two main functions. It acts as an OPC client explorer by offering a graphical interface to monitor OPC real-time data collected from OPC DA servers.

Moreover, it can perform bi-directional OPC data transfers between multiple OPC DA servers and any Microsoft Access database.

Then, users can benefit from the data archives created in MS Access for trend analysis purposes. Consequently, they can provide you with insights about your plant’s operational deviations and help you to improve plant performance.

Product Features

·A fully compliant OPC DA client

·Connection to one or more local or remote OPC DA servers at the same time

·Browsing of the entire address space for any OPC DA server

·Monitoring of OPC item changes (value, quality, and timestamp) over time

·Synchronous and asynchronous OPC DA data read and write requests

·Bi-directional data transfer between OPC DA servers and Microsoft Access databases

·Automatic reconnection to database servers when the connection is lost.

·Automatic reconnection to OPC servers when the connection is lost

·Windows service capabilities

·Log event display and archiving

9. OPC Client for Oracle

Use OPC Client for Oracle to collect and archive real-time OPC data into Oracle databases!

Integration Objects’ OPC Client for Oracle is a feature component of OPC Easy Archiver. This OPC DA client has two main functions. Firstly, it acts as an OPC DA explorer by offering a graphical user interface to monitor the real-time data collected from connected OPC DA servers. Second, it provides high-performance features to store real-time data into Oracle databases.

Consequently, this OPC archiver makes your historical data easily available and at your disposal for further analysis and processing needs.

Moreover, it does not require expertise in relational databases for users to set up their OPC historian.

Product Features

·Fully compliant OPC DA client

·Simultaneous connections to one or more, local or remote OPC DA servers

·Browsing of the address space for any OPC DA server

·Monitoring of OPC item changes (value, quality, and timestamp) over time

·OPC DA synchronous and asynchronous data read and write requests

·Bi-directional data transfers between OPC DA servers and Oracle databases

·Control of the OPC DA and database servers' connections

·Monitoring of critical tags by setting rules and defining related informative or corrective actions

·Automatic reconnection to databases' servers when the connection is lost

·Windows service capabilities

·Log event display and archiving

10. OPC DA Archiver

Centralize your OPC data into an ODBC or ADO database using the OPC DA Archiver!

Integration Objects’ OPC Easy Archiver‘s DA Component, OPC DA Archiver is an OPC data logger for databases. It can interface with several OPC DA servers to access real-time data from various data sources connected to your network. Then, it archives the collected data in ODBC or ADO-compliant databases. For example, these databases include Oracle, MySQL, Microsoft SQL Server, Microsoft Access and PostgreSQL.

Using this Archiver, you can store and archive your plant’s OPC real-time data. Consequently, OPC data archives will readily be available to you for processing, analysis and reporting purposes.

Product Features

·Fully compliant OPC DA client

·Listing of all local or remote available DA OPC servers within the network

·Connection to one or more local and remote DA OPC servers at the same time

·Browsing of any OPC DA server's address space

·Monitoring of your OPC Items´ changes (value, quality, and timestamp) over time

·OPC DA synchronous and asynchronous data read and write requests

·Bi-directional data transfer from DA servers to any compliant ODBC or ADO database

·Continuous supervision of the OPC and database servers' connection

·Automatic reconnection to OPC servers when the connection is lost

·Automatic reconnection to database servers when the connection is lost

·Windows service capabilities

·Log event display and archiving

11. OPC Archiver Enterprise

OPC Archiver Enterprise provides a comprehensive OPC client tools suite!

Integration Objects’ OPC Archiver Enterprise includes all of the features of the OPC Easy Archiver. It allows you to interface with any OPC DA and OPC HDA servers. In fact, it retrieves real-time and historical data from various automation data sources within your plant.

Furthermore, OPC Archiver Enterprise archives the collected data in CSV files or any ODBC or OLEDB-compliant databases such as Oracle, Microsoft SQL Server, MySQL and Microsoft Access.

Consequently, you can now store your plant’s real-time data and improve your system performance. This tool provides you with real insights into your data behavior and system performance.

Product Features

·A fully compliant OPC DA and OPC HDA client

·OPC DA synchronous/asynchronous reads and writes

·OPC data archiving in CSV files, or any ODBC or OLEDB-compliant database

·Bi-directional data transfer between OPC DA servers and any compliant ODBC or OLEDB database

·Rules manager features for real time data

·Automatic reconnection to OPC servers when the connection is lost

·Automatic reconnection to database servers when the connection is lost

·Windows service capabilities

·Log event display

12. OPC Client for ODBC

OPC Client for ODBC is an easy to use OPC Data Logger!

Integration Objects’ OPC Client for ODBC is a feature component of OPC Easy Archiver. This OPC client allows you to interface with several OPC DA servers. It can collect real-time data from various process and data sources connected to your network and store those data to any database via ODBC providers.

This advanced OPC client provides multi-threaded archiving. In fact, users can configure multiple archivers using different tables and databases. It also implements rules management features to notify users or manage your archivers based on watchdog tags monitored in real-time.

Using the ODBC OPC Client, you will, consequently, have a complete historical record of your process data collected from a single or multiple PLCs, control systems and SCADA. Users can benefit from the archived data for trend analysis, sequence of events, calculations and reporting purposes.

Product Features

·Fully compliant OPC DA Client software

·Browsing all local or remote OPC DA servers available in the network

·Connection to one or more local and remote OPC DA servers at the same time

·Browsing any OPC DA server address space.

·Monitoring OPC Item changes (value, quality, and timestamp) over time

·Synchronous and asynchronous group reads and writes

·Real-time data transfer and archiving from OPC DA servers to any database

·Continuous monitoring of the OPC DA servers and database servers' connection

·Automatic reconnection to OPC servers when the connection is lost.

·Automatic reconnection to database servers when the connection is lost

·Rule management functionalities

·Windows service capability

·Log event display and archiving

13. OPC Client for OLEDB

Gather and store your OPC DA data within few clicks using the OPC Client for OLEDB!

Integration Objects’ OPC Client for OLEDB is a feature component of OPC Easy Archiver. This OPC DA client allows you to interface with OPC DA servers to collect real-time data from various data sources connected to your network and archive those data to any database via OLEDB.

This advanced OPC client solution provides you with multi-threaded archiving by configuring multiple archivers using different tables and databases. It also provides rules management features allowing you to notify users or manage archivers based on watchdog tags monitoring.

Using this OPC Client, you will have a complete historical record of your process data regardless of their data sources. Then, you use the archived data in trend analysis, sequence of events, calculations and reporting applications.

This OPC archiver will help you not only to increase your data availability but also empower you with insights about your plant’s operations performance.

Product Features

·A fully compliant OPC DA client.

·Browsing all local or remote OPC DA servers available within the network.

·Connection to one or more local and remote OPC DA servers at the same time.

·Browsing any OPC DA server address space.

·Monitoring OPC Item changes (value, quality, and timestamp) over time.

·Synchronous and asynchronous group reads and writes.

·Data transfer and archiving from DA servers to any database.

·Continuous monitoring of the OPC and database servers' connection.

·Automatic reconnection to OPC servers when the connection is lost.

·Automatic reconnection to database servers when the connection is lost.

·Rule management functionalities.

·Windows Service capability.

·Log event display and archiving.

14. OPC Client for Databases

OPC Historian Made Easy with the OPC Client for Databases!

Looking for a solution to quickly deploy a real-time database? OPC Client for Databases is a feature component of OPC Easy Archiver that allows you to retrieve real-time data from OPC DA Servers as well as historical data from OPC HDA Servers. Then, it stores the collected data in your database. For example, the database can be Microsoft SQL Server, MySQL, Oracle or Microsoft Access. The OPC Client can also integrate with any other database via OLEDB or ODBC providers.

Using this OPC solution will help you increase your data availability by building comprehensive records of your process data. Then, you can use these records for trend analysis, sequence of events, calculations and reporting purposes. This empowers you with insights about your plant’s operations performance.

Product Features

·Fully compliant OPC DA and HDA client

·Browsing all local or remote OPC DA and HDA servers available within the network

·Connection to one or more local and remote OPC DA and HDA servers at the same time

·Browsing any OPC DA and HDA server address space

·Monitoring OPC Item changes (value, quality, and timestamp) over time

·OPC DA synchronous and asynchronous group reads and writes

·Data transfer and historization from OPC DA/HDA servers to any database

·Databases to OPC DA servers data transfer

·Continuous monitoring of the OPC and database servers' connection

·Automatic reconnection to OPC servers when the connection is lost

·Rule management functionalities

·Automatic reconnection to database servers when the connection is lost

·Windows service capability

·Log event display and archiving

Quick Navigation;