[R] JDBC DB access in R
binabina at bellsouth.net
Sat Oct 23 14:13:01 CEST 2004
Thanks for the reply - thru R i have large data sets in oracle, mssql,
postgres and we have jdbc drivers for all of them - most of these systems
are on UNIX/LINUX and ODBC is not used - we use JDBC to hit the DB's usually
in java applications we have. other than that we are a large SAS shop and i
am trying to find an alternative to SAS, i think R has a good chance.
For R and SQL - i assume using the wrapper below is the easiest way to hit
databases via SQL - are there any other ways i am missing? or is JDBC route
the easiest when ODBC is not available?
not sure if R contains some standard database routines that i am not seeing?
does R have some good data manipulations function - if so, could you point
me in the right direction (similiar to DATA steps in SAS)
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: Saturday, October 23, 2004 3:03 AM
Cc: r-help at stat.math.ethz.ch
Subject: Re: [R] JDBC DB access in R
The J is for Java (I presume, you did't actually say), and R is written in
C. So `all' you need to do is to call a Java wrapper from R and call JDBC
from that. I believe it has been done via RSJava.
But if all you want to do is to retrieve a dataframe, isn't this rather
On Fri, 22 Oct 2004, zubin wrote:
> Hello, i see packages referencing using ODBC access to databases via R,
> there any packages that use JDBC to submit SQL to a database and return
> a data frame?
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
More information about the R-help