Does anyone have any experience using R to pull/push data from an ODBC compliant database? I'm working on a small project and am undecided about whether to use just R or use some other software for extracting and transforming. TIA Samir. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify our IT Department by telephone at 353-1-6769333 or e-mail mail.sweeper at norkom.com and delete the e-mail from your system. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
I'm working with that package it at the moment. My question was more to try and understand issues of reliability and performance. BTW I'm working on a Win NT platform. -----Original Message----- From: Uwe Ligges [mailto:ligges at statistik.uni-dortmund.de] Sent: Tuesday, November 14, 2000 12:55 PM To: Samir Mishra Subject: Re: [R] ODBC Connectivity On Tue, 14 Nov 2000, Samir Mishra wrote:> Does anyone have any experience using R to pull/push data from an ODBC > compliant database? I'm working on a small project and am undecided about > whether to use just R or use some other software for extracting and > transforming.Have a look at the package RODBC. Uwe Ligges> The information contained in this e-mail transmission is confidential andmay> be privileged. It is intended only for the addressee(s) stated above. Ifyou> are not an addressee, any use, dissemination, distribution, publication,or> copying of the information contained in this e-mail is strictlyprohibited. If you> have received this e-mail in error, please immediately notify our ITDepartment> by telephone at 353-1-6769333 or e-mail mail.sweeper at norkom.com and > delete the e-mail from your system.PS: Why did you send this nonsense? --- Sorry about the 'nonsense' My company's email system adds it on to every email There'll probably be another one generated for this email too. It's embarrassing. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify our IT Department by telephone at 353-1-6769333 or e-mail mail.sweeper at norkom.com and delete the e-mail from your system. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> From: Samir Mishra <samir.mishra at norkom.com> > Date: Tue, 14 Nov 2000 12:05:41 -0000 > > Does anyone have any experience using R to pull/push data from an ODBC > compliant database? I'm working on a small project and am undecided about > whether to use just R or use some other software for extracting and > transforming.I've been using it quite a bit recently (and there's a new manual on `R Data Import/Export' being written for 1.2.0 that you can see a draft of at http://developer.r-project.org/R-data.pdf, and also an early manual based on MySQL there). The RODBC package seems to have quite a number of users. There's a reported bug on R-bugs with data frames with NAs in that might be worth knowing about. -- 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 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
I've tried RODBC on both SQL Server and Access databases only to read in some data. I think especially if the size of your data sets is relatively small then RODBC will do the job. The only complaint I would have is the speed at which it runs but again this is a generic tool, it is flexible enough and relatively efficient for all the work it does. If you have particular needs and speed is critical then you would probably want something faster. Hope this helps YG ----- Original Message ----- From: "Samir Mishra" <samir.mishra at norkom.com> To: "R-Help (E-mail)" <r-help at lists.R-project.org> Sent: Tuesday, November 14, 2000 7:05 AM Subject: [R] ODBC Connectivity> Does anyone have any experience using R to pull/push data from an ODBC > compliant database? I'm working on a small project and am undecided about > whether to use just R or use some other software for extracting and > transforming. > > TIA > > Samir. > > > The information contained in this e-mail transmission is confidential andmay> be privileged. It is intended only for the addressee(s) stated above. Ifyou> are not an addressee, any use, dissemination, distribution, publication,or> copying of the information contained in this e-mail is strictlyprohibited. If you> have received this e-mail in error, please immediately notify our ITDepartment> by telephone at 353-1-6769333 or e-mail mail.sweeper at norkom.com and > delete the e-mail from your system. > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-> r-help mailing list -- Readhttp://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html> Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch >_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._. _._ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._