Tutorials

SQL4Automation makes direct communication between controller and database straightforward and efficient.
You'll find more practical explanations, guides, and in-depth knowledge on our YouTube channel - ideal for anyone who wants to learn more about using SQL4Automation and its capabilities.

Connecting a Mitsubishi PLC with SQL Databases

Connecting a Mitsubishi PLC with SQL Databases

In this tutorial video, we show step by step how to connect a Mitsubishi PLC with a Microsoft Access database and a Microsoft SQL Server database. To test the connection, we use a sample project.
Watch Tutorial
Setting Up a Grafana Dashboard Step by Step

Setting Up a Grafana Dashboard Step by Step

In this tutorial video, we create a Grafana dashboard to visualize the data from the application in video T008.
Watch Tutorial
Logging Sensor Data from a Siemens PLC to a MariaDB Database

Logging Sensor Data from a Siemens PLC to a MariaDB Database

In this video, we create an application that measures the temperature and humidity in a room every 5 seconds and transfers the sensor data to a database. We use a Siemens S7 1200 PLC, an Intel NUC with the Connector, and a Synology Drive with a MariaDB database.
Watch Tutorial
Download and Installation of SQL4automation on Ubuntu

Download and Installation of SQL4automation on Ubuntu

In this tutorial video, we show how to install the SQL4automation Connector on a computer running Ubuntu via the command line. Afterwards, we explain how to stop, start, and restart the service.
Watch Tutorial
Connecting a Siemens S7 1200 PLC with a SQL Server Database

Connecting a Siemens S7 1200 PLC with a SQL Server Database

In this tutorial video, we show step by step how to connect an S7 1200 PLC with a Microsoft SQL Server database. To test the connection, we use a sample project.
Watch Tutorial
Connecting S4A with Microsoft SQL Server

Connecting S4A with Microsoft SQL Server

In this tutorial video, we show how to download and install Microsoft SQL Server on a computer running Windows 10. Afterwards, we create a sample database and connect to it with our S4A Connector.
Watch Tutorial

FAQ's

Below you will find answers to frequently asked questions about our services.

Why is SQL4automation faster than other solutions?

SQL4automation communicates directly with the PLC controller and SQL database, without OPC servers, middleware, or buffer systems. This eliminates delays caused by additional protocols or conversions. SQL is executed directly from the PLC. The simple SQL query language also enables fast and targeted data retrieval, further boosting performance.

Can I use SQL4automation with .NET?

Yes. SQL4automation provides a standardized OLEDB/ODBC interface that enables access from .NET applications. You can design your application to access the PLC using SQL commands, just like with a conventional database. This allows you to connect payment systems, MES, or web apps to machines.

What are typical use cases from our customers?

Direct and flexible communication between production and IT enables diverse practical examples without separate interface programming: Automatically writing production data to SQL databases, reading order data from ERP/MES systems, calculating OEE metrics directly from the PLC, process documentation and traceability of machine data.

Switch to SQL4automation now.

Connect industrial controllers directly to SQL databases. Proven in practice since 2007 for maximum performance and security, completely without middleware.