How to exchange data between various
systems, databases and SAP ERP
  • Home
  • Solutions
  • How to Achieve IT and OT Data Convergence

What is preventing you from unlocking the potential of the IoT?

The IoT is a concept that describes the interconnection of various technological, production and IT systems and their data. Today, one of the main obstacles to leveraging the IoT is not insufficient data, but the inability to collect and capitalise on it.

What data and
how can you benefit from it?

First, think about what data you want and who you need to grant access to it.

In general, PLCs, HMIs, robots and other devices provide technological and production data. Technological data includes temperatures in control cabinets, motor vibrations and electric power consumption, while production data covers, for example, the number of pieces produced, the scrap rate and production targets achieved to date.

This shop floor data has to be transferred to higher-level systems, such as MES, SAP, databases, spreadsheets, visualisations and Business Intelligence platforms, and from these systems back down to the factory floor.

Who needs this data and
what for?

  • Maintenance staff – for more effective condition monitoring
  • Production personnel – for assessing KPIs and controlling the production process
  • The management – for better strategic decision-making and more effective planning

Given the multitude of proprietary communication protocols, how to interface all these different systems? This cannot be achieved without data standardisation. Only then can you seamlessly exchange data between the various systems.

How to Go About It

OPC Router data connector

Up until now you have had to acquire or develop various communication interfaces to be able to transfer data between disparate systems. OPC Router is a program that enables you to interface diverse industrial devices with IT systems, for example machine control systems, printers, readers, email, databases and SAP. In fact, we consider OPC Router's ability to integrate production assets with SAP to be an enormous advantage.

With OPC Router, you can exchange data automatically – fast, easily and without any programming skills. You can see all data transfers in a user-friendly graphical form.

Depending on what systems you would like to interconnect, you need a combination of OPC Router plug-ins for the particular data exchange project. This means that you do not have to buy all plug-ins, but only the ones that you really need. The most popular plug-ins include the SAP, the SQL Server, the OPC UA, the MQTT Client and the Heidenhain plug-ins.


OPC communication protocol

The KEPServerEX communications platform allows you to collect data from common industrial devices and convert it into the OPC DA/UA format. This standardised data can further be transferred to databases, visualisation programs and other IT systems, for example through OPC Router.

KEPServerEX offers over 150 communication drivers for hundreds of devices. You can purchase only the drivers that you really need or, for one low price, you can buy a driver suite with the most frequently used drivers in your industry.


Data collection via Ewon routers

For collecting data from common control systems, you can also use Ewon Flexy 205 routers. Although they are primarily designed for remote access, they also allow for access to data from common PLCs via the cloud, thus offering a fast, easy way of further leveraging this data.

Learn how to work with data

Would you like to learn more about exchanging data between diverse systems? We provide training in all the data collection and exchange tools mentioned above. Sign up for our training and learn how to leverage these tools.

Need help with data exchange?

Would you like to consult us about data exchange? Feel free to share your expectation with us. We will be happy to help you find the best solution for you.

Related Products

490.00 € (excl. VAT)
603.00 € (excl. VAT)
2 900.00 € (excl. VAT)
1 050.00 € (excl. VAT)
1 050.00 € (excl. VAT)
1 050.00 € (excl. VAT)
1 050.00 € (excl. VAT)
1 160.00 € (excl. VAT)

Blog Articles

Our quality management system is certified to ISO 9001:2015

Follow us on social media

Made by FOXON s.r.o. © 2021

Quick Enquiry


Enquiry type