ROracle Driver
ROracle is an open source R package supporting a DBI-compliant Oracle driver based on the high-performance OCI library. ROracle is publicly available on the Comprehensive R Archive Network (CRAN) and is maintained by Oracle. It enables highly scalable and performant connectivity to Oracle Database for data transfer, along with enables transaction level control and execution of user-provided SQL statements.
You can execute SQL and PL/SQL from R, work with many Oracle datatypes, and benefit from Oracle Database optimizations for pushdown filtering, joins, and aggregation inside the database rather than exporting data. It is cross-platform (Windows, macOS, Linux, Solaris, AIX), open source under LGPL for commercial or research use, and implemented as a compiled C or C++ binary that links against Oracle Instant Client libraries at runtime.
The ROracle package supports Oracle R Enterprise database connectivity.
Get Started
"In my position as a quantitative researcher, I regularly analyze database data up to a gigabyte in size on client-side R engines. I switched to ROracle from RJDBC because the performance of ROracle is vastly superior, especially when writing large tables. I've also come to depend on ROracle for transactional support, pulling data to my R client, and general scalability. I have been very satisfied with the support from Oracle -- their response has been prompt, friendly, and knowledgeable."
"Having used ROracle for over a year now with our Oracle Database data, I've come to rely on ROracle for high performance read/write of large data sets (greater than 100 GB), and SQL execution with transactional support for building predictive models in R. We tried RODBC but found ROracle to be faster, much more stable, and scalable."