Bridging SQL to PROFIBUS

23 August 2017

A client required some data on his SQL database to be sent to his PLC. He had a few sensors inserting data directly into his SQL database and he needed this data to be processed by his PROFIBUS PLC controller so that the correct actions could be taken.

The solution was an SQL to PROFIBUS bridge. IDX provided custom software that would extract the SQL data in real-time and expose the extracted data as a Modbus TCP slave device. The data could be converted to a PROFIBUS protocol, using a gateway such as the Anybus X-Gateway AB9001, and then be sent directly to the PLC controller.

IDX 8

We provided the client with a custom software called IDX 8 which is offered by IDX. It contains a suite of functionalities which includes tag management, remote monitoring, historian, alarms and events, data exchange, and more. The function of interest here is its data exchange component which allows for real-time data to be shared with different systems.

After the client installed IDX 8 on his test server, which he brought to IDX for a demonstration of our proposed solution, we continued to set up IDX 8 to extract the SQL data and expose it as a Modbus slave, the steps for the setup are as follows:

  • Setup Data Exchange service
  • Setup SQL interface
  • Setup Modbus Slave interface

After the setup, we demonstrated to the client that the data was indeed being extracted from the SQL database. This is shown below using the “Live Tag View” function that IDX 8 supplies:

The Anybus X-Gateway AB9001

To configure the AB9001, we require an “IPConfig.exe” tool supplied by the distributor of the product, HMS Networks, and a web browser. We used the “IPConfig.exe” tool to set up the IP address of the AB9001 gateway and then configured the Modbus settings using a web browser, by accessing the device’s web interface using the assigned IP address.

The hardest part of this process was the mapping of the Modbus transactions to instruct the Modbus master to read the correct values from the correct Modbus slave registers. Once that was done, we used the “Transaction Monitor” function that is provided by the device through its web server to demonstrate to the client that the values read by IDX 8 were indeed being exposed as a Modbus slave device. This is shown in the image below:

Setting up the Anybus X-Gateway as a PROFIBUS slave

Setting up the PROFIBUS DP slave on the Anybus X-Gateway was done by just assigning a slave address to the device on its “PROFIBUS DP V-1” menu in its web server. After that, we then checked the mapping of the Modbus Master registers to the PROFIBUS DP Slave device using the “Mapping Overview” page provided by the web server.

To confirm that the Gateway was indeed ready for PROFIBUS communication, we set up a PROFIBUS Master simulation using a tool called ProfiTrace from Procentec. We demonstrated to the client that the PROFIBUS Master was in data communications with the Gateway and that data that was originally from the SQL was indeed being sent through to the simulated master, this is shown in the image below:

<a href="https://blog.idx.co.za/author/jackson/" target="_self">Jackson Kao</a>

Jackson Kao

Software Developer

Jackson's passion includes full-stack development, where his wide-ranging expertise covers both front-end and back-end technologies. This requires a fusion of creative prowess and logical reasoning, a balance he navigates with finesse.

Show your love!

Recent Posts

Driving Productivity with LineView Training

In light of our partnership with LineView Solutions, our team has taken up the opportunity to equip themselves with insights into the LineView system and its impact on the industry. “LineView is a production line monitoring and recording system that automatically...

Exciting New Launch: Onsite ProfiDay

IDX is excited to announce the launch of our onsite ProfiDay offering. This is available to all industries and companies that utilise PROFIBUS and/or PROFINET within their industrial communications systems. What is ProfiDAY? An exclusive onsite program offering...

Introducing our Partnership with LineView Solutions

We are excited to announce our partnership with LineView Solutions, a leading UK-based company specialising in smart factory solutions for optimising production processes. LineView developed a cutting-edge software suite designed to automatically gather data from the...

Optimise PROFIBUS and PROFINET Network Performance

As a field technician handling PROFIBUS and PROFINET systems, it is crucial to recognise the common errors that can result in costly downtime. From improper network configuration to neglecting regular maintenance, these mistakes can greatly affect system performance...

Delighted Customer Shares Experience

We recently assisted a client in rectifying damage to the Anybus ABC4090 Communicator caused by incorrect power usage onsite. We arranged for the device to be sent to HMS in Sweden for repairs, and they restored it before promptly returning it to us. Here are some...

Price Decrease on PROFIBUS Connectors

PROFIBUS connectors play a crucial role in industrial automation and data exchange systems by facilitating smooth communication between devices and networks. We are pleased to announce a significant price decrease on all our PROFIBUS connectors. Thanks to recent...

PROFIBUS Standards: Functional bonding and shielding

Electromagnetic Interference (EMI) and earthing issues can significantly impact the performance of your network. By following these six proven recommendations, you can ensure that your network is always up and running.

PROFIBUS Standards: Terminations

What is the Volts Direct Current (VDC) required for optimal operation of a PROFIBUS DP termination circuit? Get the answers you need in our latest video on PROFIBUS Standards: Terminations. Don't miss out on this essential knowledge to boost your system's performance!

PROFIBUS Standards: Segment Cable Lengths

Finding the perfect balance between PROFIBUS cable length and network speed is crucial. While longer cable segments might seem tempting, they can lead to signal degradation and slower speeds. Conversely, too short segments might limit your layout options. Striking the...

Sign up for our newsletter

Get exclusive updates and a sneak peek into our world every two months. Stay connected, stay informed.

Related Posts

Our expertise lies in establishing, maintaining, and leveraging plant data for business benefit. Through our innovative solutions, we work alongside you to streamline processes, enhance efficiency, and reduce costly downtime.

CONTACT US

Main: +27 (11) 548 9960
Sales: +27 (11) 548 9970

SOCIAL MEDIA

Copyright @2024 Industrial Data Xchange. All rights reserved.