[R] New to R

Lalitha Kristipati Lalitha.Kristipati at techmahindra.com
Wed Jan 21 10:28:31 CET 2015


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.
============================================================================================================================



More information about the R-help mailing list