SQL Server DB Plug-In for OPC Router - License type: Subscription license

OPC Router is a software program that allows you to connect data from various industrial devices and IT/OT systems to each other. All this quickly, automatically and without programming knowledge. In addition, you can see all data flows in a clear visualization.  

Collect data, connect systems, perform calculations, compare values and enter results into databases. You can do all this with OPC Router for PLC systems, OPC servers, printers, RFID readers, emails, Excel spreadsheets, databases, cloud systems, MQTT brokers, ERP systems SAP R3, SAP HANA, etc. For installation on a single computer you need a basic module and one or more plug-in modules.

Microsoft SQL Server Plug-In

Microsoft SQL Server is one of the most common SQL servers in the industrial environment. In the modern Industry 4.0 production, databases form the heart of networked production. All relevant production data is stored in them and made available to other systems.

With OPC Router's MS SQL Server plug-in, you can easily connect to a MS SQL Server and access its tables, views and procedures. In combination with other OPC Router plug-ins, you can easily collect data from various other systems and store it in MS SQL Server databases. This data can then further be transferred to other systems, using the appropriate OPC Router plug-ins.

An example of an OPC to SQL to OPC connection with Stored Procedure call

Every time the PalletNumber (1) changes, PalletID, PalletHeight and PalletWeight are read out from the OPC UA server (2) by the OPC UA client and transferred to the Stored procedure (3) in the MS SQL database. The procedure returns WarehouseNo, StorageBin, ApprovalCode and ErrorCode and sends them back to the OPC UA server (4).