In order to make the connection between R and the database, you need to have RStudio first. You can download RStudio for free by clicking here.
Once you’ve opened RStudio, go to Tools –> Install Packages…
And it will open a window prompting you for a package. Under the title “Packages,” type in “RMySQL” and hit install.
Once the package is installed, you can now establish the connection between R and the WAI database, and obtain the data. You can access the simplified code for the connection by clicking AccessWAIThroughR.