TIA Portal SCADA Data Logging in SQL Server and Reporting With SSRS

hello guys today we will develop the reporting on tia portal 17. so let's start now first of all we are know about which tools which tools are required for this reporting services okay so first of all first tool required is tia portal right now we have a 17th version second tool is sql server third tool is sql server manage studio for tool is ssp sql server data just a minute sql server data okay and this server with sql reporting services okay so this tool is required first tool is ti a portal v17 second is sql server with reporting services okay second one is the sql server management studio and third one is ssdt so one by one i will explain all the tools first of all so every automation person every plc scada design person know about the what is the tia portal this is the siemens tool for the programming of the plc scada hmi drives and all the things of the human siemens part so we have using that this tie portal look at that here okay then second tool is our sql server management studio so we have right now sql server 2014 you can use any latest version okay not issue so sql server reporting services so this is opening okay so this one is and the management studio this is the studio s server in that and this is the studio okay so it will connect it done so this server is used right now the management studio is 12th version okay and the which sql server we are using right now the sql server is 2014. okay correct so this is the studio and the screen and the third one tool is and third tool is ssdt ss okay so this one is sql server and this sql server with reporting services so here reporting this sql server reporting services configuration manager okay so in that connect the sql server which server you want to store the data okay done so first of all one by one start okay first go with tia porter okay today in tia portal create new project project is auto reports then project is created right now it's creating let's open the great so i'm adding the devices first device is our it's pc journal for the scanner okay any tia developers and who work in the scada know about the what is the pa pc station okay this is the scada pc system okay so this is the pc station required some additional hardwares and like supporting communications modules so we suppose work on profinet ethernet using the journal ethernet industrial ethernet journal and application application is using the bin cc professional okay so professional now okay done so it's save open compile okay notation it's compiling okay that's 40 45 60 70 80 okay having a three wire warnings know that okay so first we go here okay i'm going with the property the ethernet address create any any network okay so this one is okay so ip addresses suppose we are decided from one one one okay you can choose any one okay so currently our pc name is this okay just use this okay so with this here this property is okay in this property no need to any change right now okay so save it save and this compile this it's to warning which warning is okay so okay this is the again then again compile no warning into errors okay it's not sounds good so now our squad is completely compiled go in hmi okay the screen okay so first of all we are creates so we are create in that so one screen not one two screens okay so first screen is okay this is the rename start okay this is zero starting add one more okay operation this one is similar to it we have created the blue screens this is the basic features know that every scada developer and this is not motive to tell you but uh this is for the developer we are create one button for the just only for the base switch okay so go with the startup page okay this one is click and bold done in property event okay next is screen active screen okay click on that click on this use there is active screen which is scatter which screen will be switched for the startup okay as it is same copy and then start the page okay this is a starter so operation done property change from here okay this one is operation page done save okay okay so our operation page we are taking some field field okay we'll use board some tasks okay and this one is okay no tissue this one and the where is text value this is the text okay suppose it is a it's suppose we have a boiler okay so boiler actual temperature actual temperature okay so we have put it here so over here okay in property okay styles takes so much left not to be centers miscellaneous okay journal and fit two objects will be removed from here okay so it's something it's large okay we create the tags in that notation and also can go in property property this is the input and output value and [Music] it's okay again and text format and this is the horizontal central and top it will the middle okay then we have copy oh again it's pressure this one is okay this is the actual temperature so this is last one is actual pressure okay so actual pressure and okay so temperature then actual pressure actual level okay so we have a three parameters first of all we are using the vba script vbs script to log this data in sql okay so first one is create the tag this one is hmi we have created some default tags it's temp okay taking this one as a real value currently we are using internal don't connect it with any plc if you have a plc so you can create the hmi connection and we'll connect and here mention the plc tag okay this is the temp temperature okay this one is pressure okay then third one is level okay so we have a three parameters correct so this time we have got this okay close this and add the tags go in journal after that oh it's great go with default tax and write your and time it the temperature then last second one is which is temperature pressure and its level okay all the three tabs are connected so first we look at here it's too much so [Music] pressure is it is uh this is the boiler temperature so definitely it will in positive okay so don't use the s so and that that is not more than around 150 so that's why using the triple line dot okay same as it is using from this way okay same and same then this start okay we have three parameters okay this one is also when you create one some uh this is operator name done and the operator name is which one is its string okay so you do see and using this one here okay and here browse and operator done so you big one use this big one tweet this one okay so use one button for one log data okay done with this so our next tool is sql server so first of all run this in just a minute okay so it is okay any error and something so it's now it's zero zero done with this so we are create the runtime okay starting the runtime simulator okay maybe it's time okay take the time to go with here so once again close this one write down as sms ssms sss and sql server management studio open this so here required some password and something the username is during the installation it will mention there okay go in database okay create any report suppose this is the report server okay so go and report server then table so here is the multiple tables so no tissue so create one database okay so put it the database name is ti is something tia 17 so okay done so one is ti 17 go over table create one table from here okay so first name is date sorry date this one is state and time so data type is also required from here the data time second is operate which operator so operator is n here so third one is so third one is temperature temperature and the temperature is which is this is the float value done again the temperature in pressure is also float okay the level is also float okay and go with this the date and time required it's default for the every entry okay so this one is get date record it's by default okay so save the pia [Music] so when time is not no already let's take time okay not issue you take the time okay so you take the time not issue so forgive them go with this script okay so create one new script okay so script name is rename for the log data done so everything is there so we have some script so for the where is my script script this one is okay so we have a writing script it's default okay not too worried about this this one okay so this one is i will explain this this is our global variables you declare from here okay so this one is a d ob connections for the records and this is the stream for the date connection with web for database connectivity okay so here is one is error okay so this one create one also tag error over and these are okay so it will done so first of all create the dsm so how to create the dsn go with odbc so odpc we are here to run odbc create okay so user dsm add one here so clear the sql server suppose this one is tia go with here sometimes there is not browse any like a server so go with here and connect and copy from this way okay so [Music] this is not this one okay so this one is is running the run time it's too time is okay so paste it next one using this the password provide the password this password is during the installation okay not issues [Music] [Music] [Applause] uh okay apparently i think so i'm forgetting the password vp this one has maybe i'll forget the password right now ah no it's corrected okay so using this database next one and everything is test shows okay test all the things go go go but stats complete is okay then everything is okay this is our run time okay so go with page and changes okay so change the page great so next one is everything is so so dsn is over which one is dsn i forget it uh odbc uh odc okay so which one is the t i a so put it here is d i a d s n s p i a okay and what is the catalog so catalog name is refresh this one so catalog name yes sorry this one is ti 70 so going to a portal so put it here is the tia okay so done done this okay so this is our script this is the error if any error so error code will be transferred this smart tag means this be a scatter tag okay so are before and after so we are we create the query between this okay so our table is this one if we query for the select user this is the select star from which is d i a log okay so this one is okay no any data and that right now so we are enter the operator temperature pressure and level so okay go design so put it here okay insert into ticket table what is the name of the table is the table name is this one okay so brackets the this one is operator okay so put it here operator in comma then again what is the temperature okay okay so this is temperature equal okay use this one yes then again is pressure okay then copy this one is okay then what is the value of that values this is normal insert query of this square sorry in so okay the answer what is the value so first value is how to write the first one is operator operator is string so go with single then double then to end and between the browser tag of that the operator name then again comma this is the float value so double not a single then two and done then browse that tag of which one is temperature then then double quote press and then again browser tab which one is this is pressure then comma then double one is double end it's browser tag layers okay so written this tag then this is the insert query okay so this is the insert query okay so save this project compile from here i think so one error where is some issue great there is issue there is no need to this okay clear first of all then again okay okay thank you so close this one so using this property going event okay here and which data login script to call with this button done so operations [Music] then from here so which operator is it's jack so what is the actual temperature is 0.7 okay the pressure is suppose is 24.5 the level is it's 78.1 so operator is jack this one is so lock the data go with this okay so need to stop the run time it's taking the time okay it's too much taking the time right now gonna stop then okay so run again it's taking time uh so so so so so so now now scada run time is active okay so first of all suppose operator name is check temperature value is 15.4 pressure is right now it's around 2.5 level is 99.8 okay so now this is the sql table okay so currently don't have any data okay so first of all okay this one is the first entry with respect to date and time so now we have saved the data in this okay so again suppose will be start the temperature rise is 30.7 then pressure is around 5.7 the pressure actual level is dropped it's 97.5 so data the actual pressure is 12.4 the level is 96.5 so again it's done okay this is the third entry this is the actual data okay so if we have a shooting using the scheduler okay so create the one task property okay this one select one property okay this here i know so add the trigger which trigger so so currently we don't using the trigger okay so it's using curves scanning based so it will every every every every three it's five seconds so go to the operations starts okay so next one is our next task is which one is sorry so next one is ssdt so go with the ssdt okay so this is the s build okay just okay once you stop the runtime because you make the scheduler sometimes it's not effective so it will start again okay so go with ssdt done with new project the project is like tia okay the report project this is the project go with solution with reports add new reports this here the data source which one okay new data so let's go without it which one okay so this one is which databases ti 17 the connection test is okay good done next one is the query builder so select the table name add okay this one is close so use all columns done this one is ascending order okay just okay so this one is okay next tabular formats no need to this okay stop just this is the bit by default but uh we don't need and delete this this one is first of all go with the case setup report property a4 size okay and this one is centimeter dataset is okay okay add header then insert head footer okay so it is the header and footer i will explain it this is which one is like text box okay this must text so text is so so foreign take amazing so this is the rectangular box okay so yeah so put its company name like uh okay apartment and this one is 80 in this [Music] okay so put it here it is so so suppose another insert rectangular this one is this point is right here this is enough so go with the acting the date time okay this one is dating and reports generated okay same put it here okay things are good with expression okay what is the expression in that okay looks like this okay so this one is date and time is also okay so some segregated above then this point okay it's it's not sound okay okay so it's little bit sound okay so insert this one stable okay so we have one two three four five so insert the problem is right then right go with this put it inside okay so first one is date second one is operator third one is temperature fourth one is pressure and last one is water level okay like this so it's something of this this like this hit center okay this one is use some color inside which one is done okay and okay go with the dark black let's do all outside border okay this one is okay [Music] this oh sorry need to be run you know so this one yes this is looking very nice okay so [Music] so this one is so this is the report of so this is so so okay so first put same value is suppose its temperature value is 87.6 pressure is around 44.5 level is 98.5 and now its operator is jack okay so go in database okay so every minute will be locked okay stop this so now so insert the text box let's mix it from here to an expression is equal to double this is page and and so i'll just turn it off the total uh i will explain it okay this is the globus dot page number end of this so we go with here so this is the prevention okay so though one entry is here okay then if you repress from here and do one entry okay so page one done so one more thing so enter this line so so line it is clear that this is the header and footer so that's why okay so it's looking sound okay so the point will be somewhere thick not issue okay same thing is from this okay done so create one more thing suppose uh what is right now we have a two entry right now so suppose uh operator will change and operator is heavy and pressure is uh drops six sorry temperature is drop pressure okay so next entry is this is the check okay wait some minutes go with the refresh three just just just come come first then this is 29 so maybe it will come 29 29 29.9 okay so it is yes one more thing create one parameter which parameter is operator name okay this is allowed to multiple increments okay so [Music] use this one yes close okay for the operator name okay this one is using is a which one is this okay this so let's okay so again go in parameter property value here from data set to operator operator okay so going preview we have a two operator suppose we have select with av so which entry is ah no because first both this data set query here is where is equal to operator operator in this just issue and at the rate of reactor under the score name okay so this one is one more thing so close but okay so this one is only for the jackfruit so it mean this is the filter okay if you want to both one is so just okay if you won't go with the pdf so this one so here it is report one so this is the report then it's very sounds looking okay so this is the time is increasing level okay so let's suppose now it's operator changing it's here okay it's real and the pressure is also changed that time sorry level is this 82.5 so again go with the report so this one the next tool is our with sql reporting services okay so this one is reporting configuration manager over this connect connecting again check with this this one is our reports okay this one is our board so when it will close this one take this property and place it there sorry this one wait a minute so not have rights to for this so first of all go with internet explorer right click run is administrator and this one is open okay put it from here oh sorry which one is this one place this okay this is the report server uh sorry this is okay it's copy okay this will just copy and paste okay go with folder settings add new rules which one is not okay copy this this is select all roles close right nice having some permissions issue so close on this and again the studio tools okay right click and as an administrator this is very typical point so what is the values so lots of the videos changing area is kind and yes john okay and pressure gas okay to just [Music] okay it's open so our project is t-i-e-a okay once again go with property sorry go with solution right click then the deploy once again so it's deploying it's successfully okay so it's complete successfully so again refresh this one sorry this is your report url this one is so this is the dia click on that the first is no this one is report which won't you all select click this is your web browser report with the help with the using of the dia portal 17 and the data log in sql okay and here is the trigger if you have any confusion so just test text me in comment box okay i will reply as soon as possible thank you very much

Channel: Automation Training

Views: 6,347

Keywords: siemens, TIA Portal, SCADA Reporting, Data Logging in SQL, SSRS, TIA Portal 17, Report Design, TIA Wincc Professional, TIA Wincc Advance, Wincc Reporting

Id: WWTjIiu6NC0

Length: 68min 8sec (4088 seconds)

Published: Sun Sep 18 2022