This section provides a walk-through to writing ODBC data access code to HPCC 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 HPCC.
Use RODBC functions to execute SQL on HPCC:
- 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.