---
title: How to write on industrial device through an SQL Table
description: New feature that permits to use SQL to write the value directly to the machine ( available from Alleantia 5.1.1)
---
[Skip to content](https://kb.alleantia.com/how-to-write-on-a-device-through-an-sql-table#main-content)
English
Show submenu for translations
![Alleantia\_ATJ\_whitelogocolorbandtrasnpbg\_HR-Oct-21-2021-02-02-26-19-PM.png\]](https://kb.alleantia.com/hs-fs/hubfs/Alleantia_ATJ_whitelogocolorbandtrasnpbg_HR-Oct-21-2021-02-02-26-19-PM.png?height=40&name=Alleantia_ATJ_whitelogocolorbandtrasnpbg_HR-Oct-21-2021-02-02-26-19-PM.png)
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Visit our site](https://www.alleantia.com/)
[Visit our site](https://www.alleantia.com/)
Welcome to Alleantia, Industrial IoT Edge Gateway. How can we help you?
- There are no suggestions because the search field is empty.
1. [Alleantia Knowledge Base](https://kb.alleantia.com/)
2. [Stream Data - IIoT Apps](https://kb.alleantia.com/stream-data-iiot-apps)
3. [SQL](https://kb.alleantia.com/stream-data-iiot-apps#sql)
# How to write on industrial device through an SQL Table
## New feature that permits to use SQL to write the value directly to the machine ( available from Alleantia 5.1.1)
First, select the type of database to connect to Alleantia Core application, from the dropdown menu in the configuration window (Database type)
Select the desired variables to receive from DB by clicking on the "Telemetry variables" button:
For each variable that you want to write from DB you must enable Write checkbox in the relative row.
You also do this with Custom alarms and events
Then, on MySQL or SQL Server database, create again a database with compatible structure with IoT SCADA application. Click **“Download script”** to download the script of the creation of a new database on SQL platform, that contains all the dable needed to read data from IoTScada and to write data to IotSCADA.
After having entered the connection parameters to the database (IP address, Port, Database name, Tables suffix, Username, Password), check the connection by clicking **“Connection test”**. the message “Connection Success” will be shown.
The Written table is structured as follow:
| ID | DEV\_ID | VAR\_ID | DESCRIPTION | VALUE | TO\_WRITE | WRITTEN | TIMESTAMP | SN |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| | 1 | 1 | | 56 | | | | |
| | | | | | | | | |
The first colomn (ID) is autoincrement.
To write a value to IOTSCADA, you must filling the fields DEV\_ID, VAR\_ID ,VALUE, TO\_WRITE and SN (the dev\_id and the var\_id must be enabled in IOT SCADA as shown before).
The field TO\_WRITE enables Alleantia to read that row.
So when you complete the row with the fields required( as shown in the table above )you write 1 in field TO\_WRITE .
The field SN must contain a serial number (known also as Machine ID) of the Alleantia Core Installation.
After that Alleantia takes this information and write in field WRITTEN the result(1 =SUCCESS, 0 FAILED) and the timestamp of the operation.
**Be careful :** Once you have done the operation you must fill a new row in order to make a new operation.
---
### If you need support don't hesistate to contact us
- [Industrial IoT Connectivity in 4 steps](https://kb.alleantia.com/industrial-iot-connectivity-in-4-steps#main-content)
- [Industrial Connectivity in 5 minutes - Configuration Steps](https://kb.alleantia.com/industrial-iot-connectivity-in-4-steps#industrial-connectivity-in-5-minutes-configuration-steps)
- [Alleantia Platform Overview](https://kb.alleantia.com/alleantia-platform-overview#main-content)
- [Alleantia Core](https://kb.alleantia.com/alleantia-platform-overview#alleantia-core)
- [Cloud Portal](https://kb.alleantia.com/alleantia-platform-overview#cloud-portal)
- [Machine Drivers](https://kb.alleantia.com/alleantia-platform-overview#machine-drivers)
- [IIoT Apps - Connect Business Apps](https://kb.alleantia.com/alleantia-platform-overview#iiot-apps-connect-business-apps)
- [Site Manager](https://kb.alleantia.com/alleantia-platform-overview#site-manager)
- [Alleantia Core](https://kb.alleantia.com/alleantia-core#main-content)
- [Alleantia Core - Download and Configurations](https://kb.alleantia.com/alleantia-core#alleantia-core-download-and-configurations)
- [Licenses and Free Version](https://kb.alleantia.com/licenses-and-free-version#main-content)
- [License Management](https://kb.alleantia.com/licenses-and-free-version#license-management)
- [Alleantia Core - Free Version](https://kb.alleantia.com/licenses-and-free-version#alleantia-core-free-version)
- [Machine Drivers](https://kb.alleantia.com/machine-drivers#main-content)
- [How can I create a driver with spreadsheet template??](https://kb.alleantia.com/machine-drivers#how-can-i-create-a-driver-with-spreadsheet-template)
- [How can I create a driver with Driver Editor?](https://kb.alleantia.com/machine-drivers#how-can-i-create-a-driver-with-driver-editor)
- [Private Library](https://kb.alleantia.com/machine-drivers#private-library)
- [Machines connection configurations](https://kb.alleantia.com/machine-drivers#machines-connection-configurations)
- [Stream Data - IIoT Apps](https://kb.alleantia.com/stream-data-iiot-apps#main-content)
- [API REST](https://kb.alleantia.com/stream-data-iiot-apps#api-rest)
- [Modbus](https://kb.alleantia.com/stream-data-iiot-apps#modbus)
- [OPC UA](https://kb.alleantia.com/stream-data-iiot-apps#opc-ua)
- [AWS](https://kb.alleantia.com/stream-data-iiot-apps#aws)
- [Boomi](https://kb.alleantia.com/stream-data-iiot-apps#boomi)
- [Microsoft Azure](https://kb.alleantia.com/stream-data-iiot-apps#microsoft-azure)
- [Dropbox](https://kb.alleantia.com/stream-data-iiot-apps#dropbox)
- [MQTT](https://kb.alleantia.com/stream-data-iiot-apps#mqtt)
- [SQL](https://kb.alleantia.com/stream-data-iiot-apps#sql)
- [OneDrive for Business](https://kb.alleantia.com/stream-data-iiot-apps#onedrive-for-business)
- [TeamViewer](https://kb.alleantia.com/stream-data-iiot-apps#teamviewer)
- [Alleantia Certified Hardware](https://kb.alleantia.com/alleantia-certified-hardware#main-content)
- [Advantech](https://kb.alleantia.com/alleantia-certified-hardware#advantech)
- [Cisco](https://kb.alleantia.com/alleantia-certified-hardware#cisco)
- [Dell](https://kb.alleantia.com/alleantia-certified-hardware#dell)
- [Eurotech](https://kb.alleantia.com/alleantia-certified-hardware#eurotech)
- [Lenovo](https://kb.alleantia.com/alleantia-certified-hardware#lenovo)
- [Portwell](https://kb.alleantia.com/alleantia-certified-hardware#portwell)
- [Stratus](https://kb.alleantia.com/alleantia-certified-hardware#stratus)
- [Simulators and Starter Kit Industria 4.0](https://kb.alleantia.com/simulators-and-starter-kit-industria-4-0#main-content)
- [Simulators - PLCs, CNC, Energy meters](https://kb.alleantia.com/simulators-and-starter-kit-industria-4-0#simulators-plcs-cnc-energy-meters)
- [Starter Kit Industria 4.0](https://kb.alleantia.com/simulators-and-starter-kit-industria-4-0#starter-kit-industria-4-0)
- [Edge Operational Applications](https://kb.alleantia.com/edge-operational-applications#main-content)
- [Cobot Smart Service](https://kb.alleantia.com/edge-operational-applications#cobot-smart-service)
- [FAQs - Trouble Shooting](https://kb.alleantia.com/faqs-trouble-shooting#main-content)
- [Configurations](https://kb.alleantia.com/faqs-trouble-shooting#configurations)
- [System Setup](https://kb.alleantia.com/faqs-trouble-shooting#system-setup)
- [Interfaces to IIoT Apps](https://kb.alleantia.com/faqs-trouble-shooting#interfaces-to-iiot-apps)
- [Interfaces to Industrial Devices](https://kb.alleantia.com/faqs-trouble-shooting#interfaces-to-industrial-devices)
- [Connectivity](https://kb.alleantia.com/connectivity)
[](http://www.alleantia.com)
© 2024 Alleantia s.r.l
Copyright © 2026, ALLEANTIA SRL