How to Use an SQL Server with Indusoft Web Studio?

When you are working with SCADA software, there is always a need to use some server like SQL, or Oracle with it. This is because, SCADA is used for larger systems in automation, and you need to handle large amounts of data backup daily. So, the servers play an important role in data management with SCADA software.

Various types of SCADA software are available in the market, but in this post, we will learn the concept with Indusoft Web Studio.

SQL Server with Indusoft Web Studio

We will learn how to use an SQL server with Indusoft Web Studio. Our focus will be only on data dumping in the server. Let us see the process step by step:

First, you need to link the SQL backup with the SCADA software. There are two places where you need to link the backup. The first place is shown in the first image and the second place is shown in the second image.

In the first image, after you have entered the correct details, click the Test Connection button to test whether your backup has been linked with the SQL server or not.

In the second image, you need to do the same process of entering proper details of SQL data, which you need to check whether SCADA has been linked with SQL or not.

Then, you need to create database tables in the SCADA software, by right-clicking the database option and clicking insert.

A table is a tool where you will insert the columns required to be shown in the SQL server. Whatever columns you configure here, you need to insert the same name in the SQL server table.

Refer to the below image for understanding. In the description, you need to add the table name; in connection, you need to add the connection name; in the table name, you need to add the same name which you will give in the SQL table; and in the insert tag, you have to add a tag which will trigger the table.

Data is dumped into the SQL server when this table is triggered; so you need to trigger the trigger tag every time you want to throw data. Once this basic setting has been done, you need to link tag names and the column names as shown in the figure.

Tag-name refers to the tag which is present in SCADA and its value needs to be dumped in the column corresponding to it. So, as per the below example, apart from local date and time, Sensor1_Pv will be dumped in the Sensor1_Pv column of SQL and Sensor2_Pv will be dumped in the Sensor2_Pv column of SQL.

Next, you need to trigger the tag which will in short trigger the whole table created by you. Refer to the below image for understanding.

In the scheduler tab, for example, I have triggered this tag every minute. This tag will toggle between 0 and 1 every minute; thus triggering the table. When the table is triggered, the last values of the tag are written in the SQL table.

Next, you need to create the table in the SQL server. Create a table with the same name – Auto Mode and create the columns with the same name as done in the SCADA backup. Refer to the figure below.

Once the table has been created, you can now run the SCADA backup and check whether the values are dumping in the SQL server or not.

When the value is triggered from your SCADA backup, at the same time, values must be reflected at the same time in the SQL server. Every time your value shows reflection correctly in the SQL server at every trigger, this means your table is properly linked with SQL now.

Do remember that the table name and column name must be the same on both the SCADA and SQL, otherwise, any change in name or any missing character will not show the value in SQL.

If you liked this article, then please subscribe to our YouTube Channel for Instrumentation, Electrical, PLC, and SCADA video tutorials.

You can also follow us on Facebook and Twitter to receive daily updates.

Read Next:

• Overview of SIEMENS PLC
• HMI and VFD Control System
• Sequential PLC Pneumatic Valves
• HMI Screen Design for Hazardous
• S7-1200 Hardware Configuration