Connect OPC Data Access Classic real time data with Excel, Access, SQL Server, MySQL, Oracle and CSV files
This Web site provides you with information about Rensen OPC Office Link and is the place where you can purchase software licenses online directly from Rensen Information Services Limited. If you are interested in upcoming versions then please check out what’s coming next!
OPC Office Link is an OPC Data Access Client application enabling a no-programming-required data flow from the factory floor to business applications using the OPC Data Access Classic Interface. OPC Office Link collects this data via standard 3rd party OPC Data Access Server software that in turn talks directly to devices controlling the machinery. OPC Office Link has remained one of the few certified OPC Data Access clients. OPC Office Link is fully supported for all current Windows operating systems. (Note: for OPC UA interface support see UA Office Link.)
OPC Office Link simplifies the task of importing live data originating from any Data Access 2.0 or 3.0 OPC Server into office applications such as Microsoft Excel, Microsoft Access and databases like MS-SQL Server, Oracle, Interbase and any other database accessible via ODBC. Real-time factory floor data collection has never been easier! OPC Office Link has been proven in hundreds of installations world-wide. Its database and spreadsheet connectivity rivals solutions that can cost you many times more – compare!
Link live data into spreadsheets and other applications capable of OLE Linking via a simple ‘Copy & Paste’ operation. OPC Office Link works with Microsoft Excel “as is”; no programmnig required. Linked data will update in the spreadsheet at a configurable rate, even when dealing with thousands of tag values. Reading and writing groups of OPC items via Excel Visual Basic macros is simplified down to a single function call, allowing Excel to fully control any OPC accessible device in an effective way. In some cases this can eliminate the need for other HMI software.
Data collection is made just as easy. By default, OPC Office Link creates an empty Microsoft Access database which can be used to collect samples for later analysis or continuously as live status reports. Use other ODBC databases such as MS-SQL Server, Oracle, Interbase or text log files in the same way. OPC Office Link will sample into database tables and files as configured, either continuously or controlled by a trigger. Multiple sampling processes can be running concurrently, sampling into the same or different databases, while only one connection per database is required.
Distribute live production data enterprise wide by installing OPC Office Link on different computers to communicate with your remote OPC server or consider installing OPC Office Link on a single machine for live updates into an enterprise wide accessible database (for example, a SQL Server or Oracle database), then only install multiple copies of the reporting software. Use samples stored in your database by OPC Office Link as the basis for your own Web site to distribute live production data around the world!