FactoryTalk View | SE | Allen Bradley | SCADA | Tutorial 13 | Data Logging in SQL Database

so in this video we are going to discuss about the data logging in SQL database so first of all in the previous video I will show you how to connect a database so you will see a setting I am connected to my SQL database and you will see here is my username and password of my SQL database which is connected again CC and here is my username and password tomorrow I'm going to click OK and then I am going to select the data login so you will see how I am going to data log I am going to select a new and new which is my database now I am going to click OK and select my database which is also I think I am going to create a new one first of all we need to delete the other and I think we don't have an older now I'm going to create a new OBC database so you will see I'm going to create a new file letter source and I am going to select an SQL Server I am going to browse that and save into my desktop with the name of new you will see that I am going to give my desktop I am going to select that and select desktop and open I think it is not created now I'm going to do that again file data source SQL Server next I'm going to browse and I'm going to save that new to my desktop selector next and finish now I'm going to connect to with my database so I'm going to copy that my address of my server name copy and I am going to paste it there like that now I'm going to selectness and select Windows SQL Server notification and I am going to select an essay which is my password of my identities database and the password foreign there you will see a new database I'm going to finish that and you will see test Source our database is actually connected and our data login is start now I'm going to create tables so you will see our database table is now created and I think we need and again our server login and password foreign password I think we have done now I'm going to select an import we don't want a backup of that I am going to log into the trigger and I am going to select a product on one second because we don't have a time now again we are going to select until tag so I'm going to select a tank and you will see my level tag in the previous video I'm going to remove clear them and level and our set point which is there I am going to select an OK add that and okay I'm going to component name with the new the new and our data load file is now created now I'm going to my screen so you will see my data log screen in is created in the previous video data logging I will show you how we data lock so I am going to create a new button and up opinions I am going to select a log on and the action I am going to select a data log and log on like that select our log file finish that okay I am going to create a new button and I am going to name it a load or connection I am going to select the logo there and my log file which is New Finish and okay I think our both buttons has now created now I'm going to save that whole project and start my runtime to see disconnected or not and you will see my factory is also connect it I am going to make it open to select a set point and what we need to do so you will see our screen is now started and first of all we are going to make a KP value for our and I am going to select a set point which is I think 5.0 and you will see our tank is now working now I am going to log and I am going to select the logo so you will see obdc no module has a starting logo and after it will reaching the point I will off the logo so you will see our tank is logging and here is our set point which is 5.0 now I am going to change that to 6.0 so check it will change that you will see our tank and now I am going to load and I think I have done nodes take time but I am going to log off so you will see our stock data log is now stop now I'm going to database to check that our login is done or not we will see new and the table and I am going to select that top 100 row check so you will see that it is logging our data so that is our set point which is where and that is our level that is our statement and the below is our level and you will see that now we are going to change variable 36 and that is our level I'm going to tag table so you will see the set point and the level if these our data loading now I need to check that our more data logging is done or not so I am going to you will see it will never other data logging which is you will see alarm it will have an alarm data login the alarm we are created in the previous videos between data logging of that I am going to name it C users and tables it will uh it is our before previous alarm track record so you will see and if I'm going to my desktop so we will see that on the desktop you will see that our database is there so I think that's it so thank you very much for watching my video Please Subscribe my channel like my video and click the Bell icon and don't forget to watch my other tutorials of windowsoft skydiving scada and Factory IO tutorials as well so if you want to learn watch my videos so thank you very much again for watching my video

Channel: The Automation Craze

Views: 1,547

Keywords: Factory Talk View, Factory Talk View ME, Factory Talk View SE, Allen Bradley, PLC, HMI, Micrologix, Compactlogix, Contrologix, PLC5, SCADA, SLC500, DCS, Tutorials, Factory I/O, Siemens, S7300, S71200, FTV, FTVME, FTVSE, Studio 5000, RSlogix5000, RSlogix500, RSlinx, Studio5000, Powerflex, S71500, TIA Portal, Factory IO

Id: ekLul9cNmr4

Length: 8min 18sec (498 seconds)

Published: Fri Jan 27 2023