Advance Engineers Forum

To log data in MS SQL Server Table using Node-RED, you can follow these steps: 1. Install the node-red-contrib-mssql-plus module in your Node-RED instance. This module provides nodes for interacting with MS SQL Server databases. 2. Create a new MS SQL Server database table where you want to log your data. 3. Add an mssql node to your Node-RED flow, and configure it with the appropriate database connection details. 4. Add a function node to your flow, and write the code to prepare and insert data into the database table. Here's an example code: javascriptCopy code var timestamp = new Date().toISOString(); var value1 = msg.payload.value1; var value2 = msg.payload.value2; var sql = "INSERT INTO mytable (timestamp, value1, value2) VALUES ('" + timestamp + "', " + value1 + ", " + value2 + ")"; msg.topic = sql; return msg; This code takes the current timestamp, as well as two values from the msg.payload object, and inserts them into the mytable table. You can customize the code to match your own table schema and data types. 1. Connect the function node to the mssql node, and deploy your flow. Now, whenever your flow receives new data, it will be logged to the MS SQL Server table. Keep Testing ! Keep Learning !

WinCC Flexible is a software package used for programming Siemens' HMI (Human Machine Interface) devices. Here is a general guide to installing WinCC Flexible on your PC: 1. Check your PC meets the system requirements: Ensure your PC meets the minimum system requirements before installing WinCC Flexible. Check the Siemens website for the latest system requirements. 2. Obtain the WinCC Flexible software: You can obtain the WinCC Flexible software from a Siemens distributor or partner. Make sure you have the installation files or DVD. 3. Run the installation file: Insert the WinCC Flexible DVD into your PC, and run the setup.exe file. Alternatively, you can download the software from Siemens website and run the setup.exe file. 4. Follow the installation wizard: Follow the on-screen instructions to complete the installation. The installation wizard will prompt you to accept the software license agreement, choose an installation location, and select the components to install. 5. Activate the software: After installation, you need to activate the software. To do this, launch WinCC Flexible, go to the Help menu, and select "Activate WinCC Flexible." Follow the activation instructions provided during the installation process. 6. Configure the software: After activation, you will need to configure the software to connect to your hardware. Follow the instructions provided in the WinCC Flexible user manual to configure the software. That's it! Once you have completed these steps, you should be ready to use WinCC Flexible on your PC. Happy Support !