06-21-2010 08:00 AM
I have an application for my Compact RIO involving some data capture and analysis. My output is an waveform displaying the averaged data from say the last 1, 2 or 5 minutes. I'd like to be able to access the data from anywhere in the world from a range of devices (laptops, iphones etc).
My current thinking is to publish the data to the web via an SQL server, then dynamically build the website using the data in the SQL database. To do this (and this is the part I'm interested in finding more about) I need a way of getting the data from the Compact RIO, to a database. I have one of the modules at the following link http://www.sea-gmbh.com/en/products/compactrio-products/sea-crio-modules/
Does anyone have experience of publishing to the web direct from the cRio? Or furthermore connecting to an SQL database from the cRIO? I'm trying to get the remote panel for the cRIO working as we speak, but am aware that a LabVIEW runtime engine is required on the client computer to view this. This is something that would not be feasible for my application.
Any help or direction of where to start would be greatly received!
Thanks,
Ryan.
06-21-2010
11:08 AM
- last edited on
03-27-2024
04:14 PM
by
Content Cleaner
Hi there,
I've just recently done a project that has a cRIO writing to a local mySQL database using the NI SQL toolkit. To log the data to a remote database would only be a change in IP address when opening the connection to the database. (There are a number of methods of interfacing LabVIEW with databases...Google will find a few open/free tools for you)
You could then have your webpage running a PHP script to refresh from the database every so often.