SQL Data Types
Wide support of SQL data types,
supports up to 18 data types.
Description
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.
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.
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.
Wide support of SQL data types,
supports up to 18 data types.
There are versions for S7-1200 and S7-1500. The S7-1500 version includes enhanced 64-bit features.
Supports basic SQL commands like SELECT • INSERT • DELETE • UPDATE • Execute Stored PROCEDURE and others (CREATE, ALTER, DROP etc.)
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.
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.
The latest version of the library is released for all the most used TIA Portal V13-V19.
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.
€119 / PLC
Unlimited quantity
€119 / PLC
Unlimited quantity
Machine / Device integration
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.
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.
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.