S7-MySQL Gateway

This section of the documentation is still under construction. Please contact us if you have any questions.

Contents:

  1. Siemens S7
    1. Project setup
    2. Connecting to the PLC
      1. General Settings
      2. Connection Settings
      3. PDU Settings
    3. Reading data from the PLC
      1. Adding a Tag
      2. Adding multiple Tags
  2. MySQL
    1. Project setup
    2. Connecting to MySQL
      1. General Settings

Siemens S7

Project setup

In the navigator right-click on the project and choose ‘Add Target’, next choose ‘Siemens S7’ as the target type and click Ok.

S7 Target

Connecting to the PLC

Right-click on connections and choose ‘New Connection’.

S7 Connection

It is possible to add multiple connections to a single S7 target, only one connection can be active simultaniously.

General settings

Name

Enter a unique name for the connection.

IP Address

The ip address of the S7 PLC.

Connection Settings

Rack

The default value is 0.

Slot

For S7-1200 PLC’s the slot should be set to 1

Connection type

PG, OP, S7 Basic

Local TSAP

The default value is 256.

Custom

Check this setting to enter a custom Remote TSAP

Remote TSAP

This value is automotically calculated from the Rack, Slot and Local TSAP settings.

PDU Settings

Reading data from the PLC

In the navigator right-click on ‘Tag Tables’ and choose ‘New Tag Table’, next double click on the newly created Tag Table to edit it. In the Tag Table editor right click on the Tag Table name and choose ‘Add Memory Area’.

S7 Memory Area

Adding a Tag

Right-click on a Memory Area and choose ‘Add Tag’

S7 Memory Area

Adding multiple Tags

Right-click on a Memory Area and choose ‘Add Tag Range’

S7 Memory Area

MySQL

Project setup

In the navigator right-click on the project and choose ‘Add Target’, next choose ‘MySQL’ as the target type and click Ok.

MySQL Target

Connecting to MySQL

Right-click on connections and choose ‘New Connection’.

It is possible to add multiple connections to a single MySQL target, only one connection can be active simultaniously.

General settings

Name

Enter a unique name for the connection.

-

Found a mistake or want to help improve this documentation? Contact us to suggest changes.

Schrijf je in voor de Plc-Lab nieuwsbrief.

Star

Copyright © 2019 Poelstra Besturingen - Leeuwarden