×
Siemens Industry Online Support
Siemens AG
Entry type: Application example, Entry ID: 109479140, Entry date: 08/27/2015
(9)
Rate

SIMATIC ODK 1500S SQL driver

  • Entry
  • Associated product(s)
Connection of an SQL database to an S7-1500 Software Controller

Overview

This application example shows how to connect an S7-1500 Software Controller to an SQL database by means of the ODK 1500S SQL driver. The drivers allows a direct access to an SQL database from a STEP 7 application.

 

Functionality

With the included function blocks it is possible to establish and close a connection to an SQL database, to read and write data and to edit an SQL database.  All prevalent standard data types are supported. The ODK1500S SQL driver uses the ODBC interface to connect to an sql database (local or remote).

As a user interface to the database, two function blocks are available. One function block enables to execute SQL statements (e.g. Select, Insert, Update, Delete) with flexible arguments.

The second function block can be used to write data from a data block into a database without using SQL statements.

 


More information about this driver can be obtained from the provided PDF-documents.


History


August 2015 V 1.0
  • First version
 June 2016 V1.1
  • Support of 64-bit floating point numbers
  • Direct input of SQL statements possible (Separation between data and string not necessary)
  • Generation of demo database via sql script
 July 2017

 V2.0

  • Implementation with ODK 1500S V2
  • New user interface
  • New function block for writing process data without SQL strings/statements
  • New function bock for executing SQL statements without arguments
  • Support of optimized data blocks
  • Support for additional data types (datetime, bit…)
  • SQL statements with up to 16000 characters in the user program
 August 2017

 V2.1

  • Support of unicode datatypes WString resp. nvarchar
  • Support of variable string length in read and write direction (up to 254 characters)
  • Increased data interface from 8kByte to 265 kByte (sqlArguments / sqlReceivedData)
  • Improved diagnostic with SQL Viewer


Obtaining

If you are interested, please contact your local sales partner:
Contacts worldwide

 

Downloads

 Registrierung notwendig  Documentation (2,8 MB)
  Flyer (145,9 KB)

 

Security information
In order to protect plants, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art industrial security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about industrial security, please visit
http://www.siemens.com/industrialsecurity.