This section provides a walk-through to writing ODBC data access code to Quandl in R, using the RODBC module.
Connecting from R
See Getting Started for the prerequisite information you need to deploy the driver and configure the connection to Quandl.
Use RODBC functions to execute SQL on Quandl:
- See Querying Data to execute SELECT statements and iterate over the results.
- See Parameterized Statements to execute parameterized statements. Parameterized statements provide a means to efficiently execute queries more than once and to mitigate SQL injection attacks.
Executing Stored Procedures
See Executing Stored Procedures to execute stored procedures as SQL statements.