This section provides a walk-through to writing ODBC data access code to Act-On in R, using the RODBC module.

See Data Model for more information on the available API objects and any API limitations or requirements. See SQL Compliance for the SQL syntax.

Connecting from R

See Getting Started for the prerequisite information you need to deploy the driver and configure the connection to Act-On.

Dependencies describes the necessary steps to install RODBC. Once it is prepared, refer to Connecting to connect to Act-On.

Executing SQL

Use RODBC functions to execute SQL on Act-On:

• See Querying Data to execute SELECT statements and iterate over the results.
• See Modifying 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.