This section provides a walk-through to writing ODBC data access code to Greenplum 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 Greenplum.
Use RODBC functions to execute SQL on Greenplum:
- See Querying Data to execute SELECT statements and iterate over the results.
- See Updating Data to execute other SQL data manipulation statements.
- 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.