Running the pfrinit utility

• Purpose—Configures Cognos for each study.
• Location of file—<InstallationDirectory>\InForm\Bin
  • pfrsetuptrial.xml—Supplies database connection information used by the pfrinit utility.
  • pfrinit—Sets up connection information, permissions, and folder structures needed for accessing the Reporting and Analysis module from the Oracle InForm application.
• Where to perform—The Oracle InForm application server.

1. On the Oracle InForm application server, open the pfrsetuptrial.xml file, located in the <Installation_Directory>\InForm\bin directory folder, and make the following changes:
   • connectionstring—Oracle connection string for the reporting database (in a single database configuration, use the study database connection string).
   • dbuid—Update the DBUID parameter with the UserID of the study owner.
2. Save and close the PFRsetupTrial.xml file.
3. Open a Command Prompt window, and type the following command:

   pfrinit

   You are prompted for the following parameters:

   • sysadmin_namespace—Oracle Directory Server admin namespace.
   • sysadmin_uid—User name for the Oracle Directory Server admin namespace.
   • sysadmin_pass—Password you chose when creating the crnsysadmin user.
   • publisher_namespace—Custom Authentication Provider (CAP) namespace. Enter informcap.
   • publisher_uid—Oracle InForm study user who is a member of the following Reporting groups:
     • Publishers.
     • Either Sponsor Users or Site Users.
   • publisher_pass—Password of the Oracle InForm study user.
   • dispatcher_url—Internal URI that the Oracle InForm server uses to communicate with the Cognos Analytics server.
   • trial_name—Name of the Oracle InForm study.
   • reportdb_pass—Study PID.
   • in_place_upgrade—Y/N. Indicate if the PFRInit command is being run as part of an in-place upgrade (required for an in-place upgrade).

   For more information, see pfrinit.