This is Grégory Vandenbrouck's Typepad Profile.
Join Typepad and start following Grégory Vandenbrouck's activity
Grégory Vandenbrouck
Recent Activity
@jangorecki: rsqlserver depends on rClr which in turn depends on the .Net framework. Therefore it may have performance issues similar to RJDBC/RSQLServer due to the marshalling of objects from native to managed.
Can't tell for sure since on my test machine rClr failed to install due to a failure to download NuGet package http://www.nuget.org/packages/DynamicInterop
It's unclear what the root cause is. Here's what I tried in case that helps:
- bash
sudo apt-get install libssl-dev libcurl4-openssl-dev libxml2-dev mono-complete libglib2.0-dev libmonosgen-2.0-dev
- R
install.packages("devtools")
library(devtools)
install_github("jmp75/rClr") # fails
Using Azure as an R datasource, Part 4 - Pulling data from SQL Server to Linux
by Gregory Vandenbrouck Software Engineer, Microsoft This post is the fourth in a series that covers pulling data from Microsoft SQL Server or MySQL/MariaDB on Azure to an R client on Windows or Linux. In the previous posts, we covered pulling data from SQL Server to Windows and from MySQL/Mari...
Nice; I didn't know about the public AdventureWorks. I was not able to get RSQLServer to work with it, while it works fine with my DB. Not sure why. If anyone has ideas, let me know. I was however able to get RODBC and RJDBC to work. Here are the corresponding code snippets:
library(RODBC)
conn <- odbcDriverConnect("Driver=SQL Server;Server=mhknbn2kdz.database.windows.net;Database=AdventureWorks2012;Uid=sqlfamily;Pwd=sqlf@m1ly")
sqlQuery(conn, "SELECT TOP 2 * FROM Person.Person")
close(conn)
library(RJDBC)
drv <- JDBC(
driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver",
classPath = "C:/JDBC/Microsoft JDBC Driver 4.1 for SQL Server/sqljdbc_4.1/enu/sqljdbc41.jar")
conn <- dbConnect(drv, "jdbc:sqlserver://mhknbn2kdz.database.windows.net", database = "AdventureWorks2012", "sqlfamily", "sqlf@m1ly")
dbGetQuery(conn, "SELECT TOP 2 * FROM Person.Person")
dbDisconnect(conn)
Using Azure as an R data source, Part 1
by Gregory Vandenbrouck Software Engineer at Microsoft This post is the first in a series that covers pulling data from various Windows Azure hosted storage solutions (such as MySQL, or Microsoft SQL Server) to an R client on Windows or Linux. We’ll start with a relatively simple case of pullin...
@Jeroen: oops, you're right, RMySQL doesn't require the JDK. Thanks for pointing it out!
Using Azure as an R datasource: Part 2 - Pulling data from MySQL/MariaDB
by Gregory Vandenbrouck Software Engineer, Mirosoft This post is the second in a series that covers pulling data from various Windows Azure hosted storage solutions (such as MySQL, or Microsoft SQL Server) to an R client on Windows or Linux. Last time we covered pulling data from SQL Azure t...
@Carlos
Windows 7 64bit should be OK. The clients I tested are: Windows 8.1, 10 "insider preview" and Server 2012 (all 64bit).
@Yolanda
I didn't find a DocumentDB R package or ODBC driver. It does however provide a REST API. So it should be possible to query DocumentDB from R, maybe with the rjson package. Sounds like a great topic for a subsequent post :)
Using Azure as an R data source, Part 1
by Gregory Vandenbrouck Software Engineer at Microsoft This post is the first in a series that covers pulling data from various Windows Azure hosted storage solutions (such as MySQL, or Microsoft SQL Server) to an R client on Windows or Linux. We’ll start with a relatively simple case of pullin...
Grégory Vandenbrouck is now following The Typepad Team
May 13, 2015
Subscribe to Grégory Vandenbrouck’s Recent Activity