How to link AVEVA Edge (InduSoft) with a MySQL Database Server

[@user-pp8nk8wl4y]

Thanks, If you run this on Linux device such as Pi, could it work on Pi.

[@luisalfredopachecocruz5331]

Hi! Engineer! Great video ! I have doubt , Aveva Edge has HTTP Request ? Regards!

[@GeorgeRoman]

congratulations, excellent video. I have a little doubt: Is the same procedure for example MariaDB?

[@avevaedgevideos78367]

Yes, the MySQL provider works with MariaDB.

[@zakwanizzat9797]

Thanks, can you help how to do register function using aveva with SQL, I mean register function like name, address and so on..., and at the same I able to search the detail. Which mean, in aveva I could key in the data and store into SQL, then can add search button to find the data

[@akashmaurya2193]

Great Video! Thanks for this.... I have tried same and it's working but my concern is that MySql DB Data Logging date & Time does not match with actual regional time. Any Solutions for this?

[@avevaedgevideos78367]

Probably you have the DB connection advanced options in the project set to save data in UTC format. Changing it to Local Time should fix that.

[@akashmaurya2193]

@@avevaedgevideos78367 Thank you that helped me... Also can you tell me or make video on this Question: I want to Filter Reports (I'm using Microsoft Report Builder) based on Date and Time but as you know our Date & Time is showing in One column of any Logging window. I have made a report format in report builder but I want to filter data based on Date and Time. I tried many ways but unfortunately ended up with disappointing output.