Set Up SAS Data Extract

Users need access to the opapps account to run Oracle Clinical SAS Data Extract jobs.

For more information, see:

• Give Users Access to the opapps Account
  
• Add the opapps Account to the oclsascr User Group
  
• Give opapps Access to the Directory Specified in the RXC_SAS_VIEW Environment Variable
  
• Set Up SAS User Authentication and Set OCL_STATE Reference Codelist Values
  

Give Users Access to the opapps Account

The same setup is required for SAS users in Oracle Clinical as for PSUB users; see Enable Users to Submit PSUB Jobsfor UNIX and Enable Users to Submit PSUB Jobs for Windows.

Add the opapps Account to the oclsascr User Group

To add the opapps account to the oclsascr user group:

1. Add the opapps user to the oclsascr user group. It is the only user required to be in this group; see Create the oclsascr User Group for SAS.

Give opapps Access to the Directory Specified in the RXC_SAS_VIEW Environment Variable

See the Oracle Clinical Administrator's Guide for information.

Set Up SAS User Authentication and Set OCL_STATE Reference Codelist Values

To set up SAS user authentication and set OCL_STATE reference codelist values:

1. Choose one of the following user authentication methods:
   • Oracle Wallet
   • SAS password encryption with a proxy user
2. Indicate your choice in the OCL_STATE local reference codelist along with other SAS-related settings. By default the value is set to Oracle Wallet.

See the Oracle Clinical Administrator's Guide for more information.