Hi, I am trying to connect R to databases. I found two ways to connect. 1.By using specific package (eg RMySQL to connect to R) 2.By using connectors and RODBC package. can any one tell me the difference between those two methods. Regards, Lalitha K. Associate Software Engineer 917411291011 ===========================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra. =========================================================================================================================== [[alternative HTML version deleted]]
On 21/01/2015 05:51, Lalitha Kristipati wrote:> Hi, > > I am trying to connect R to databases. > > I found two ways to connect. > > 1.By using specific package (eg RMySQL to connect to R) > > 2.By using connectors and RODBC package. > > can any one tell me the difference between those two methods.See the 'R Data Import/Export Manual' which ships with R. There is a specific list for such questions, R-sig-db, where less vague questions should be asked.> > > > Regards, > > Lalitha K. > > Associate Software Engineer > > 917411291011-- Brian D. Ripley, ripley at stats.ox.ac.uk Emeritus Professor of Applied Statistics, University of Oxford 1 South Parks Road, Oxford OX1 3TG, UK
This is not really a question about R... it is a question about databases
because similar divisions occur in every imperative programming language that
deals with databases. ODBC is a software layer that aims to create a uniform API
for the programmer among different variations of SQL databases (though it
doesn't entirely succeed). RODBC gives R access to that API. You have to use
OS-specific utilities outside of R to link ODBC Data Source Names to specific
ODBC-to-DB "drivers".
The alternatives are usually much more specific to the DB back end, with
potential ability to take advantage of DB- specific features, and disadvantages
of being more closely tied to that particular software.
There is a mailing list (R-sig-db) where you should ask more specific questions
about how R deals with these non-R- specific APIs, but each of the R packages
maps to much more extensive documentation about those APIs that you will need to
be familiar with in order to make progress with them.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On January 20, 2015 9:51:44 PM PST, Lalitha Kristipati <Lalitha.Kristipati at
techmahindra.com> wrote:>Hi,
>
>I am trying to connect R to databases.
>
>I found two ways to connect.
>
>1.By using specific package (eg RMySQL to connect to R)
>
>2.By using connectors and RODBC package.
>
>can any one tell me the difference between those two methods.
>
>
>
>Regards,
>
>Lalitha K.
>
>Associate Software Engineer
>
>917411291011
>
>
>===========================================================================================================================>Disclaimer:
This message and the information contained herein is
>proprietary and confidential and subject to the Tech Mahindra policy
>statement, you may review the policy at
>http://www.techmahindra.com/Disclaimer.html externally
>http://tim.techmahindra.com/tim/disclaimer.html internally within
>TechMahindra.
>===========================================================================================================================>
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.
Thanks
Regards,
Lalitha K.
Associate Software Engineer
917411291011
________________________________________
From: Jeff Newmiller <jdnewmil at dcn.davis.CA.us>
Sent: 21 January 2015 21:34
To: Lalitha Kristipati; R-help at r-project.org
Subject: Re: [R] New to R
This is not really a question about R... it is a question about databases
because similar divisions occur in every imperative programming language that
deals with databases. ODBC is a software layer that aims to create a uniform API
for the programmer among different variations of SQL databases (though it
doesn't entirely succeed). RODBC gives R access to that API. You have to use
OS-specific utilities outside of R to link ODBC Data Source Names to specific
ODBC-to-DB "drivers".
The alternatives are usually much more specific to the DB back end, with
potential ability to take advantage of DB- specific features, and disadvantages
of being more closely tied to that particular software.
There is a mailing list (R-sig-db) where you should ask more specific questions
about how R deals with these non-R- specific APIs, but each of the R packages
maps to much more extensive documentation about those APIs that you will need to
be familiar with in order to make progress with them.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On January 20, 2015 9:51:44 PM PST, Lalitha Kristipati <Lalitha.Kristipati at
techmahindra.com> wrote:>Hi,
>
>I am trying to connect R to databases.
>
>I found two ways to connect.
>
>1.By using specific package (eg RMySQL to connect to R)
>
>2.By using connectors and RODBC package.
>
>can any one tell me the difference between those two methods.
>
>
>
>Regards,
>
>Lalitha K.
>
>Associate Software Engineer
>
>917411291011
>
>
>===========================================================================================================================>Disclaimer:
This message and the information contained herein is
>proprietary and confidential and subject to the Tech Mahindra policy
>statement, you may review the policy at
>http://www.techmahindra.com/Disclaimer.html externally
>http://tim.techmahindra.com/tim/disclaimer.html internally within
>TechMahindra.
>===========================================================================================================================>
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.
===========================================================================================================================Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may review
the policy at http://www.techmahindra.com/Disclaimer.html externally
http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
============================================================================================================================