+ Reply to Thread
Results 1 to 4 of 4

Thread: Read Oracle database from R

  1. #1
    Points: 2,938, Level: 33
    Level completed: 26%, Points required for next Level: 112

    Posts
    35
    Thanks
    2
    Thanked 1 Time in 1 Post

    Read Oracle database from R




    Dear friends,

    Please, do you know how to import data of an Oracle database from R? I tried with R-packages ROracle and ROracleUI but they do not work under Windows.

    Do you know the way to work with these packages with Windows? Or another way to import Oracle databases from R?

    Thank you and Regards,
    ruski

  2. The Following User Says Thank You to ruski For This Useful Post:

    mlangosch (06-28-2013)

  3. #2
    Dark Knight
    Points: 6,762, Level: 54
    Level completed: 6%, Points required for next Level: 188
    vinux's Avatar
    Posts
    2,011
    Thanks
    52
    Thanked 241 Times in 205 Posts

    Re: Read Oracle database from R

    R is not a database. If you wanted to access data (from Oracle) using R... use RODBC package.

    Steps are ..1) first set up dsn(data source name).
    Control Panel -> Administrative Tools -> Data Sources(ODBC)) ...

    2)
    library(RODBC)
    con = odbcConnect(’oracledb’)
    oracledb is the dsn name.

    *i haven't tried this. check the documentation of RODBC package for supplying passwd...
    http://cran.r-project.org/web/packages/RODBC/index.html
    In the long run, we're all dead.

  4. #3
    Points: 2,938, Level: 33
    Level completed: 26%, Points required for next Level: 112

    Posts
    35
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Read Oracle database from R

    Thanks a lot, vinux!
    I am working with RODBC without problems,

    Best regards,
    ruski

  5. #4
    Points: 118, Level: 2
    Level completed: 36%, Points required for next Level: 32

    Location
    Ann Arbor, MI
    Posts
    11
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Read Oracle database from R


    So after having a similar problem and being a beginner when it comes to databases, http://stackoverflow.com/questions/9...onnection?rq=1 this thread helped me out tremendously!! I had difficulties setting up an ODBC connection. R is the next step....

+ Reply to Thread

           




Similar Threads

  1. Replies: 0
    Last Post: 02-02-2011, 08:17 AM
  2. Replies: 0
    Last Post: 10-20-2010, 03:44 PM
  3. Setting up a database for election results
    By ajb1970 in forum Statistics
    Replies: 5
    Last Post: 11-17-2009, 05:25 PM
  4. Statistics Platforms to analyse Oracle
    By Tiffy in forum Statistics
    Replies: 1
    Last Post: 01-10-2009, 10:10 AM
  5. Database Assistance
    By Jonny Fenster in forum General Discussion
    Replies: 0
    Last Post: 01-10-2007, 04:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats