#rstudio-server

[mjliu]

Just b/c hortonworks, cloud era and IBM they all using CentOS/RedHat, I switched

Actually, not that bad to have R and RStudio Server installed as long as you are using version 6.5 (I had hard time with 7.0)

$ sudo yum install epel-release

$ sudo yum install R

then follow the link from rstudio to install the server

http://www.rstudio.com/products/rstudio/download-server/

Last, launch your browser and enjoy!

[mjliu]

So I had some fun with Windows Azure VM and SQL Azure and of coz R

The Goal is to setup RStudio server and have it work with SQL Azure via RODBC

Step 1. Instal R

   26  sudo apt-get update

   28  sudo apt-get install r-base

Step 2. Install RStudio Server

   33  sudo apt-get install gdebi-core

   34  sudo apt-get install libapparmor1

   36  wget http://download2.rstudio.org/rstudio-server-0.98.1062-amd64.deb

   37  sudo gdebi rstudio-server-0.98.1062-amd64.deb

Step 3. Instal ggplot2, unixODBC and RODBC

   47  sudo apt-get install r-cran-ggplot2

   51  sudo apt-get install unixODBC

   52  sudo apt-get install r-cran-rodbc

Step 4. Install FreeTDS and configure the DSN to point to SQL Azure database

  123  sudo apt-get install tdsodbc

  127  sudo ln -s /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so /usr/lib/libtdsodbc.so

  128  sudo ln -s /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so /usr/lib/libtdsS.so

  130  odbcinst -j

  132  odbcinst -q -d

  154  tsql -H <azureserver>.database.windows.net -p 1433 -U mike -D <databasename>

  155 isql -v sqlserver mike pass 

here are the ini files

$ cat /etc/odbcinst.ini  # or ~/.odbcinst.ini

[FreeTDS]

Driver = /usr/lib/libtdsodbc.so

Setup  = /usr/lib/libtdsS.so

$ cat /etc/odbc.ini  # or ~/.odbc.ini

[sqlserver]

Description = SQL Azure

Driver = FreeTDS

Server = <azureserver>.database.windows.net

Database = <database name>

Port = 1433

TDS_Version = 8.0