Data Base Communication(PLC) -Industrial Automation in India | PLC SCADA DCS Training in Chennai,

Data Base Communication(PLC)

           

Data base communication is communication between different software.  We might have data in Microsoft word or Microsoft Excel or other software and we need access for our program then this function of PLC helps us to communicate with them.

We take example of Microsoft Excel.

First we should open Microsoft excel then go to Excel Menu and select Excel option formula.

         Tick on working of formula R₁C₁ reference style. Here we save our file with name ‘g’ at any place you want.

Now go to RS View 32 (SCADA). Go to Configuration à Go to Configure then Add access name as below:

Access à Ritesh (Let us suppose)

Application nameà Excel

Topic Name à g.xlsx (here g is file name of excel and xlsx is extension name for Microsoft excel)

                DDE ( Fill the DDE which allow excel user to change in data in PLC.

                  Click Ok.

Take text display from menu and give its Tag name ‘a’ and select its type I/O real.

Access name à Ritesh

Item à Cell address (R₁C₁)

Here we run our scada program. When we change the value in Display, Same data pasted in Excel in Row first, column first. Same happens when we change in R₁C₁ of Excel, the data also changes in display of Scada.

Change in excel from scada

Scada display:

Change in excel:

Change in scada from excel

Excel display:

Scada display:

The valuable effect of this function is:

1.       User can access data from any file.

2.       Programmer can control multiple programs by single frame.

3.       A simple user (Not a PLC programmer) can control the full system with their best command software like Microsoft Office.

Note: There are different extension names for different software as already taken by manufacturer company.