Working with the RA Oracle Retail Agent Solution

The basic steps for implementing the RA Oracle Retail Agent solution include:

• Running the Retail_recovery_proc.sql script
• Loading the RA Oracle Retail Agent .jar file into the Automation Engine
• Creating RA Oracle Retail Agent JDBC and program Connection objects
• Creating an RA Oracle Retail Agent solution Agent object and specifying runtime values for it
• Creating RA Oracle Retail Agent Jobs

Running the Retail_recovery_proc.sql Script

Run the Retail_recovery_proc.sql script in the Oracle Retail database as the Oracle Retail user. The Retail_recovery_proc.sql script is provided as part of the RA Oracle Retail Agent distribution.

Creating RA Oracle Retail Agent JDBC Connection Object

To link the RA Oracle Retail Agent to Oracle Retail, you must create:

• An RA Oracle Retail Agent JDBC Connection object for the Agent to connect to the Oracle Retail database.
• One or more RA Oracle Retail Agent Program Connection objects for the Jobs to connect to Oracle Retail.

For more information, see topic Creating RA Oracle Retail Agent JDBC and Program Connection Objects.

Creating an RA Oracle Retail Agent Solution Agent Object and Specifying Runtime Values for It

You create the RA Oracle Retail Agent as you would create any Agent in Automation Engine, then specify runtime values for it. For more information, see topic Creating an Oracle RA Oracle Retail Agent Solution Agent Object.

Creating RA Oracle Retail Agent Jobs

RA Oracle Retail Agent Jobs include a special Oracle Retail tab, where you specify parameters. Oracle Retail parameters are also available where Jobs are assigned to Workflows. For more information on RA Oracle Retail Agent Jobs, see topic Creating RA Oracle Retail Agent Jobs.