Combining OPC Tunnelling, ODBC and Excel in one application
A European plastics manufacturer is using the OPC DataHub to access data from a group of OPC servers. Connecting an Excel spreadsheet to the OPC DataHub gives engineers a way to view and interact with the OPC server from a powerful and familiar tool. Connecting SQL Server to the OPC DataHub gives the planning and accounting staff access to up-to-the second figures and records. In order to get the OPC data where it's needed, the company uses the OPC DataHub to tunnel the data across a company network between different locations.