MSSQL MySQL Library Database Connection Siemens Simatic S7-1200 S7-1500

PDSql Library for Siemens S7-1200 / S7-1500

TIA Portal V13 V14 V15 V16 V17 V18 V19

PDSql Library V1.3.2 Connect Without PC


MS SQL / MySQL
Functionality for Siemens S7-1200/1500

PDSql Library allows you to connect your PLC Siemens S7-1200 / 1500 system directly to Microsoft SQL / MySQL / MariaDB Database and also to connect directly to the Microsoft Azure SQL Database over the Internet. 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 (2000 or higher) / MySQL (5.x or higher) / MariaDB (5.x 10.x). 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 / MySQL / MariaDB Server are contained in only one function block.

Demo

PDSql Library will run for 2 hours at a time. The demo period can be repeated at any time by switching the PLC device to power off and on. There are no other limitations to the product.

Licensing

The PDSql library is fully functional and runs until purchased in a two-hour time-limited mode. By purchasing you get a license key binded to the serial number of the PLC device, or a license for an unlimited number of PLC devices.

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. The LITE version (without SELECT) consumes only 18kB of work memory.

TIA Portal Multiversion Compatibility

The latest version of the library is released for all the most used TIA Portal V13-V19.

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 MS SQL for Siemens S7-1200 / S7-1500

€119 / PLC

FULL VERSION

  • TIA Portal V13-V19
  • Siemens S7-1200 / 1500
  • Microsoft SQL
  • Full support
PDSql Library MS SQL for Siemens S7-1200 / S7-1500

Unlimited quantity

FULL VERSION

  • TIA Portal V13-V19
  • Siemens S7-1200 / 1500
  • Microsoft SQL
  • Full support
PDSql Library MySQL for Siemens S7-1200 / S7-1500

€119 / PLC

FULL VERSION

  • TIA Portal V13-V19
  • Siemens S7-1200 / 1500
  • MySQL / MariaDB
  • Full support
PDSql Library MS SQL for Siemens S7-1200 / S7-1500

Unlimited quantity

FULL VERSION

  • TIA Portal V13-V19
  • Siemens S7-1200 / 1500
  • MySQL / MariaDB
  • Full support
PDSql Library for Siemens S7-1200 / S7-1500

Machine / Device integration

Production, Downtime, Fault history

  • Suitable for ERP, MES
  • Data buffering
  • Summary reports

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)