Filter products

Product filter
Show categories Hide categories

SQL Server DB Plug-In

This OPC Router plug-in allows you to read/write data from/to MS SQL databases. Before writes / after reads, data can be mathematically processed in the OPC Router. This plug-in is an OPC Router accessory.
IMPORTANT WARNING ABOUT PRODUCT Read
Part no:
IA2002889

Price (tax excl.):18 720 Kč

Price (tax incl.):22 651,20 Kč

This product can only be purchased along with
(this item will automatically be added to your basket):

Information

The OPC Router is a modular system that consists of the Basic module and plug-in modules. Your choice of plug-in modules depends on where from and where to you need to transfer data. A single OPC Router PC installation requires the Basic module and at least one plug-in module. You also need to purchase the Year 1 Support & Maintenance package for the first year. It will automatically be added to your basket. During the first year or when the package has expired, you can purchase Support & Maintenance for subsequent years.

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).

 

Download

Software

NameTypeVersionSizeDescriptionDownload
OPC Router – Softwareexe4.27.5006.69303.19 MBInstallation file for such current OS systems as Windows 10 and Windows Server 2016

Manufacturer’s documentation

NameTypeVersionSizeDescriptionDownload
OPC Router – Manualpdfv4.252.68 MBUser guide (in English)
OPC Router – Case Study 1pdfv1.03.11 MBIIoT Management of Milk Collection Vehicles at Germany’s Largest Dairy Group
OPC Router – Case Study 2pdfv1.02.08 MBAutomated communication with the use of the SAP Plug-In – Herma GmbH
OPC Router – Case Study 3pdfv1.02.17 MBSeamless communication between labellers/printers and SAP – Auria Solutions GmbH
OPC Router – Case Study 4pdfv1.02.29 MBInterconnecting OPC Router with KEPServerEX and systems integration with the use of the OPC Plug-In – X-Rite

FOXON documentation

NameTypeVersionSizeDescriptionDownload
OPC Router – Brochurepdfv1.01.45 MBPromotional brochure (in Czech language)
OPC Router – User Guidepdfv1.01.29 MBInstallation, licencing, user interface and configuration (in Czech language)

Subscription Licensing

Subscription licensing is an alternative to perpetual licensing (i.e. the purchase of the Basic Module and individual plug-ins). It comes in three different plans.

As the initial investment is lower, acquiring and trying the OPC Router becomes easier.

Annual OPC Router subscription

Plan

Plain

Standard

Enterprice

Included

  • OPC Router's Basic module including:
    • Scripts
    • Calculator
    • XML Transfer / XPath
    • JSON transfer
    • CSV transfer
    • Time trigger / Cron trigger
    • Variables
    • Constants
    • Text replace
    • File transfer (not via network)
  • Support and maintenance for the period rented
  • Additional plug-in modules can be purchased anytime
  • OPC Router's Basic module
  • Support and maintenance for the period rented
  • standard plug-in modules, i.e.:
    • OPC UA / DA Client
    • OPC UA Server
    • Databases (InfluxDB, SQL Server, Oracle, ODBC, OLE, MySQL MS Access, SQLite, Codebase / Foxpro and MongoDB)
    • REST
    • MQTT
    • Excel
    • E-mail
    • Network File Access
    • RFID-AutoID (OPC UA)
    • Printer (Domino, Videojet, Generic, Wolke, Windows and Zebra)
    • Barcode Scanner
    • CHARM
    • Telegram Messenger
  • Additional plug-ins/add-ons can be purchased anytime (not included in the price)
  • Innovation Guarantee – any future Category 1 plug-ins will be included
Annual fee

230 EUR
+ more or less 60 % of basic price of plug-ins of your choice*

5900 EUR

9900 EUR


* According to Inray's current price list. Based on your choice of plug-ins, we will be happy to prepare a quote for you.

**Category 1 Plug-Ins

  • OPC UA Server
  • Databases (InfluxDB, SQL Server, Oracle, ODBC, OLE, MySQL MS Access, SQLite,
  • Codebase / Foxpro and MongoDB)
  • REST
  • MQTT
  • Excel
  • E-mail
  • Network File Access
  • RFID-AutoID (OPC UA)
  • Printer (Domino, Videojet, Generic, Wolke, Windows and Zebra)
  • Barcode Scanner
  • CHARM
  • Telegram Messenger

License Activation

The latest OPC Router 4.25 release does not only bring new capabilities, but also new licensing. From now on, all licenses have to be activated on the OPC Router license portal.

Licenses can be activated online or offline.

Online OPC Router Activation

If the computer that you want to activate OPC Router on has Internet access and thus access to the OPC Router license cloud portal, you can activate OPC Router online. Compared to offline activation, this option is faster.

Offline OPC Router Activation

If the computer that you want to activate OPC Router on does not have Internet access, the activation of your new license is a little more complicated.

To help you with your license activation, we have prepared a License Activation Guide for you. Click on the button below to download it in PDF format.

Download Guide

FAQs

Where can I download the trial version and how does it work?

The trial version is available for download in our online shop.

It is a full-featured trial version, which means that all plug-ins and add-ons are available for you to try. As it is a 2-hour demo, after it has been running for 2 hours, for it to run for another 2 hours you simply have to restart the OPC Router.

Download OPC Router Trial Version


What is the Update & Support program for and why do I have to purchase it?

The Update & Support program is compulsory only during the first year of using the OPC Router. In subsequent years, it is optional.

With the Update & Support program, you are entitled to technical support, all released software updates and license recovery in the event of a computer/server failure (without this program you would lose your license).


How do I connect devices that do not support the OPC UA protocol (e.g. the S7-300) to the OPC Router?

The OPC Router does not enable you to read data from PLC systems deployed in production. For this purpose, you can use the KEPServerEX platform. After that, you connect KEPServerEX to the OPC Router – via the OPC UA protocol. For more information, please read this article on our blog.

Try OPC Router

Try OPC Router for Free

Before you purchase the OPC Router, we recommend that you download and install the free 2-hour trial version. After it has been running for 2 hours, for it to run for another 2 hours simply restart the OPC Router.

Try OPC Router


If you would like to try the OPC Router for a longer period of time, we can provide you with the free trial version for up to 7 days. For more information, please contact our Technical Support.


Videos

How OPC Router Works | Data Connector from inray (in Czech)

OPC Router | How to Transfer KEPServerEX Variables via MQTT (in Czech)OPC Router | Setting Email Alerts (in Czech)
OPC Router | How to Automatically Store KEPServerEX Data in MS SQL Database (in Czech)OPC Router | Reading Data from S7-1500 and Storing It in MS SQL Database (in Czech)
OPC Router | Exchanging Data between SIEMENS Simatic S-1500 and Ewon Flexy 205 Router (in Czech)OPC Router | How to Read Data from KEPServerEX / OPC UA and Mathematically Process It (in Czech)
OPC Router | How to Read Barcodes and Save Them (with Timestamps) to a Database (in Czech)
OPC Router – OPC to SAP (in English)Creating Telegram Bots (in English)
OPC Router – Industry 4.0 Software (in English)OPC Router – End-to-End Communication between Shop Floor and SAP ERP (in English)

Articles

OPCrouter / 09/01/2022

Data v Power BI pomohla snížit zmetkovost i prostoje

V Kiekertu nasadili předpřipravené reporty rychle, další se naučili vytvářet sami. Přečtěte si případovku o tom, jak sbíráme da...
OPCrouter / 07/28/2022

Jak na sběr dat technicky a kde na to vzít

V tomhle článku jsme shrnuli spoustu informací o projektech digitální transformace a sběru dat ze strojů. A tak máte na jednom ...
OPCrouter / 07/26/2022

Chcete digitalizovat? Využijte dotace

Uvažujete o digitalizaci některých procesů, např. sběru dat ze strojů nebo reportingu v Power BI? Teď vám může náklady snížit d...
OPCrouter / 09/20/2021

Digitální transformací nejde neprojít, můžete ji jenom prošvihnout

O digitální transformaci firem se mluví napříč obory i strukturou jednotlivých společností – transformovat se mají finanční odd...
OPCrouter / 08/16/2021

J. Blažek vyzkoušel OPC Router a vizualizační systém Grafana s PLC Simatic S7-1200

Jak dostat data z PLC SIMATIC S7-1200 do OPC Routeru a databáze s následným zobrazením ve vizualizačním nástroji Grafana? I kd...
OPCrouter / 08/04/2021

Datová konektivita | Začněte malými kroky, myslete na velké cíle

Jak dostat data z PLC do různých databází? A dál do nadřazených systémů, jako třeba MES nebo SAP? Začněte postupně, ale nezapom...

System Requirements

Computer Performance

The OPC Router is a server application and thus needs to run on appropriate hardware. This hardware should meet the following requirements:
  • A multi-core processor
  • At least 4 GB RAM
  • Enough hard disk space (with RAID 5 technology)

Operating System

We recommend Microsoft Windows Server operating systems (see the list below). For testing purposes, you can also use Client operating systems (64-bit).

  • Windows Server 2008 x64
  • Windows Server 2008 R2 x64
  • Windows Server 2012 x64
  • Windows Server 2012 R2 x64
  • Windows Server 2016 x64
  • Windows Server 2019 x64
  • Windows 7 x64
  • Windows 8 x64
  • Windows 8.1 x64
  • Windows 10 x64
  • Windows 10 IoT x64

OPC Servers Supported by the OPC Router

OPC servers in the OPC Router enable you to connect control systems and other devices via OPC UAOPC DA 4.0 or OPC XML.

If you would like to use the OPC server functionality, you need to purchase the OPC Module license.

Database Servers Supported by the OPC Router

Database servers are not part of the OPC Router installation. They need to be installed separately. The OPC Router supports these database systems:

  • MS SQL
  • Oracle
  • MySQL
  • MS Access
  • XML
  • ODBC-compliant databases
Database system plug-ins are not included in the Basic licence. They need to be purchased separately.

SAP Plug-In

The SAP Plug-In supports SAP systems 4.0b and newer. The SAP Log-on pad must be installed on the server that the OPC Router runs on.

The SAP Plug-In is not included in the Basic licence. It needs to be purchased separately.

Related Products

Viewed products

Quick enquiry
close