MSSQL Library Database Siemens Simatic S7-1200 S7-1500

PDSql Library for Siemens S7-1200 / S7-1500

TIA Portal V13 V14 V15

PDSql Library V1.2.0 Connect Without PC


MS SQL Functionality for
Siemens S7-1200/1500

PDSql Library allows you to connect your PLC Siemens S7-1200 / 1500 system directly to Microsoft SQL Database. With this library you are able to read and write data from/to SQL Database. As the communication between the PLC and the SQL Server takes place directly you don't need any PC as a broker in the communication between the PLC and SQL Server.

Description

Easy integration into your project

PDSql library was built for PLC Siemens S7-1200 (FW 4.2+) and S7-1500 (FW 1.8+). Main requirements for this library is TIA Portal V13+ and Microsoft SQL Server (2005 or higher). This library allows you to execute all the basic SQL commands like • SELECT • INSERT • DELETE • UPDATE • Execute Stored PROCEDURE. However, in addition to these basic SQL commands, other commands can be also executed depending on string content in query input.

The whole concept of this library was built on the ease of implementation into user projects. Therefore, all functions for communication with MS SQL Server are contained in only one function block.

PDSql Library for Siemens S7-1200 / S7-1500

PDSql Library Features

SQL Data Types

Wide support of SQL data types,
supports up to 18 data types.

S7-1200 / 1500

There are versions for S7-1200 and S7-1500. The S7-1500 version includes enhanced 64-bit features.

SQL Commands

Supports basic SQL commands like SELECT • INSERT • DELETE • UPDATE • Execute Stored PROCEDURE and others (CREATE, ALTER, DROP etc.)

Reliability

More than 5 million queries for each SQL statement were executed during tests in industrial environments that means the total more than 25 million successfull queries.

PDSql Library

Small Code Footprint

The main function block with its instant data block consumes only 27kB of work memory.On request, the version (without SELECT) with a smaller footprint (<20kB) can be delivered.

TIA Portal Multiversion Compatibility

The latest version of the library is released for all the most used TIA Portal V13, V14 & V15.

Simplicity

Simply trigger the SQL statement and if necessary system will be automatically connected to the SQL server (according login credentials) and execute requested command or query.

Pricing

PDSql Library for Siemens S7-1200 / S7-1500

€119 / PLC

FULL VERSION

  • TIA Portal V13,V14 & V15
  • Siemens S7-1200 / 1500
  • Full support
  • Lifetime updates
PDSql Library for Siemens S7-1200 / S7-1500

€119 / PLC

FULL VERSION

  • TIA Portal V13,V14 & V15
  • Siemens S7-1200 / 1500
  • Full support
  • Lifetime updates

Other Services

PLC Software Development

Long-term experience in programming of Siemens S7-300 / 400, S7-1200 / 1500 PLC systems. Software development for single-purpose machines or large production lines. Integration of external servo systems and robots (Fanuc, Kuka, ABB). Modifications in existing software for machines and production lines. Direct integration of SQL database functions into PLCs for production reports.

SCADA Visualization

Complete visualizations for HMI panels (Siemens, Weintek), PC runtime systems (InTouch, WinCC, Rockwell FactoryTalk) or customized .NET applications without the need for expensive runtime licenses). Interface with SQL databases.

Windows App Development

Development of windows desktop applications in Visual Studio (C#, VB.NET, C++). Integration with devices such as scanners, printers, cameras, PLC systems (Siemens, Allen Bradley, Fanuc Robots etc. Interface with SQL databases.

Contact Us


Please write to us what you are interested in

Name *

Email *

Subject *

Message *   (will be send to info@plcdirectsql.com)