OPC Office Link Classic — Connect OPC real time data with Excel, Access, SQL Server, MySQL, Oracle and CSV files

Introduction | Quick Start | Features | Download Trial

The OPC Office Link application consists of two computer programs: OPC Office Link Stand-Alone/Client and OPC Office Link Server. You can buy a license for OPC Office Link Stand-Alone/Client by itself, or you can buy it together with an OPC Office Link Server license. The combination is called OPC Office Link Client/Server.

OPC Office Link Stand-Alone/Client works independently from OPC Office Link Server or as a client of OPC Office Link Server. It has the full functionality to link live OPC data into spreadsheets from local or remote OPC servers, and allows for user-controlled sampling into ODBC databases or text files. You can upgrade later to OPC Office Link Client/Server for extended functionality if required.

OPC Office Link Client/Server allows for centralized, user-independent sampling via a Windows service. With OPC Office Link Client/Server the sampling process can be started through the client’s user interface on the server machine or remotely across the network. Sampling continues controlled by OPC Office Link Server, even after logging out of Windows. With OPC Office Link Server sampled data can also be distributed directly via integrated Web service or to linked applications such as spreadsheets on network computers.

Once you have chosen OPC Office Link Stand-Alone/Client or OPC Office Link Client/Server you will need to determine how many licenses you require. Each of the OPC Office Link programs is licensed per Seat (Single License) or per Site (Site License).

Single License: A Single License allows you to install and use the OPC Office Link program (OPC Office Link Stand-Alone/Client or OPC Office Link Server) on a single computer or terminal only.

Site License: A Site License allows you to install and use the OPC Office Link program (OPC Office Link Stand-Alone/Client or OPC Office Link Server) on all computers situated at the same site (the same physical location or street address of your organisation).

Core Features

Feature OPC Office Link Stand-Alone / ClientOPC Office Link Client / Server
No OPC server connection limitThere is no limit on the number of OPC connections you can use with OPC Office Link.
No tag limitThere is no limit on the number of OPC tags you can use with OPC Office Link.
Remote OPC Server accessBrowse the network neighborhood OPC servers to connect to OPC servers on other computers, for example to factory-floor computers on the Intranet. All sampling modes plus Copy & Paste of data links into Excel are also supported for remote OPC servers.
Partial tag address space browsingOnly the newly entered branch of the address space is requested from the server in a network friendly way. This, in combination with browse filters, makes working with servers that offer a great number of OPC items easy.
Live Data displayLive value display capabilities have been added to provide a more generic tool for all OPC Office Link integration needs.
Automatic re-connectOPC Office Link re-connects automatically to OPC servers and databases should the connection be lost.

Data Sampling Features

Feature OPC Office Link Stand-Alone / ClientOPC Office Link Client / Server
Click & Sample into ODBC databases or text/CSV filesLog data into MS Access, SQL Server, Oracle, MySql, and other ODBC database or into Comma Separated Value text files; choose from synchronous, asynchronous or trigger-based sample modes.
Create tables automatically or manuallyDatabase table structures for data collection with matching field names and data types can be automatically created or user defined
Sampling of arraysOPC Office Link supports data logging of OPC arrays. The maximum number of array elements is limited only by the number of supported table fields of the database in use.
Automatically delete old dataOPC Office Link allows you to specify when old sample records should be deleted from the database.
Custom queriesUse your own queries for storing samples. Simply type your query and use place holders where actual OPC item values, timestamps or qualities are to be substituted.
Database to device samplingConfigure OPC Office Link to sample data from the database and write value changes back to the device. This gives database applications write access to the device without any additional programming.
Recipe TransfersOPC Office Link supports device-controlled data transfers from the database to the device ("recipe transfers"). Initiated by the device, data sets are looked-up and read from the database, then written back to the device via the OPC server.
Sampling ScheduleSpecify the times when logging of data should take place
E-mail AlertsSend e-mail alerts when a sampling error occurs or when no new data has become available for a defined period of time.
OPC Office Link Server Client to manage data collectionUse OPC Office Link Stand-Alone/Client to connect to OPC Office Link Servers elsewhere on the network and control or monitor the data collection process remotely. (client side)

Live Data Linking / Excel Linking Features

Feature OPC Office Link Stand-Alone / ClientOPC Office Link Client / Server
Copy & Paste live data links into spreadsheetsCopy & Paste live data into Excel, Word and other OLE-link-capable applications from local OPC servers or OPC servers on a different computer.
Link individual items or groups of itemsCopy links for individual items or efficiently copy whole groups of 1000s of items as a single link.
Link OPC array tagsOPC Office Link supports linking of arrays.
Configurable link update rateUpdate link data at a configurable rate.
Switch between OPC server hostsDesign spreadsheets pointing to one OPC server host and change to a different host later without modifying the spreadsheet.
Historic LinksLink historical values to show values-over-time charts or X/Y charts in your spreadsheet.
Function LibraryUse the OPC Office Link function library to easily extend the spreadsheet functionality with macros; i.e. read/write cells or cell ranges from/to to the OPC server on the click of a button
OPC Office Link Server Client to retreive data for live data linksOPC Office Link Server Client to retreive data for live data links(client only)

Web Services

Feature OPC Office Link Stand-Alone / ClientOPC Office Link Client / Server
Integrated Http Web server
Access HTML or XML formatted data from anywhere in your office. Simply point your browser to the OPC Office Link Server computer to view sampling states and latest snapshots of sampled tags. Use XML formatted data to prepare a view of current tag values in your own layout.
Automatically create ASP Web PagesAutomatically create Active Server Web pages for use with Internet Information Server or integrated Web server to retrieve samples from the database for Web presentation
.NET Web ServiceRelay data to business systems via a .NET Web Service interface; .Net clients are able to read or write OPC server tags through the Web service interface.

Miscellaneous Features

Feature OPC Office Link Stand-Alone / ClientOPC Office Link Client / Server
Script & Macro programmingUse the provided function library to read and write OPC tags with one line of code. Delphi, Visual Basic and other programming languages can also be used to access OPC Office Link as an Automation Server. This way it is possible to start and stop sampling externally controlled via a few lines of, for example, Visual Basic code.
Run as ServiceOPC Office Link Server runs independent of users logged in; this allows automatic re-start of sampling processes after re-boot
Event LogView OPC Office Link Server sampling events locally or across the network using OPC Office Link Stand-Alone/Client
OPC server redundancySwitch between primary and secondary OPC server hosts as the data source for data collection in case of a failure or controlled by a trigger.
OPC data bridgeSample data into a database table row from one OPC server and transfer the data from the database to a different OPC server.
OPC Server interfaceOPC Office Link Server is also an OPC DA 1.0 and OPC DA 2.0 compliant OPC server that exposes OPC tags to control and monitor sampling processes.
Individual auto-start settingsConfigure database authorization settings for auto-start data groups individually.
Optional Cloud ConnectionExchange data with the UA Office Link Cloud Service