Writing Data to ODBC Databases

Writing OPC data to a Microsoft SQL Server Database

A plant engineer in the textiles industry is using the OPC DataHub to write data into a SQL Server database, in order to track the performance of his plant machinery. He logs when any given machine starts or stops, based on product, shift and operator. Previously, this information had to be recorded manually by the operators themselves. Now, by linking his OPC server to an SQL Server database, he can automatically generate his reports, and they are always accurate.

Writing OPC data to an Access database

A manufacturing company is using the OPC DataHub to write end-of-day statistics into an MS-Access database. A DataHub script is used to write production values to various tables in the Access database. The script is scheduled to run in the middle of the night to avoid conflicts with other database users. Management personnel can now open the Access database and see up-to-date reports based on the previous nights totals.

Networking OPC data and archiving to SQL database

A power generation company in the United States used our software to collect data from several OPC servers and then tunnel the data across a network to an SQL Server. The data was archived by exception, so that when the data changed in the plant, a new record was added to the SQL database.

OPC server in Windows to Oracle in Linux

An IT manager in a municipality office has created a live data link between a Lookout OPC server in Windows and a custom Linux application. He has an OPC DataHub connected to his OPC server, mirroring data to a Cascade DataHub running in Linux. On the Linux side, he feeds the data into an Oracle database, and from there into his custom application. The data updates are so seamless that his Linux application thinks it is directly connected to the Lookout OPC server.

Recording Data from an OPC server in MySQL database

A specialized manufacturer of plastics is using the OPC DataHub to connect a KEPServerEX OPC server to MySQL. Using the OPC DataHub, they can maintain a record of each critical change in the behaviour of their production presses, accurate to a fraction of a second.

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.