install_reporting

install_reporting_diffdb

Purpose

Installs the Reporting and Analysis module in an environment where the study and reporting databases are in different database instances.

Location

Folder where the reporting software is located, for example, <Installation_Directory>\InForm\bin\DBOra\Reporting.

Usage

install_reporting_diffdb

Command line prompts

You are prompted for the following parameters:

trial_schema_owner_password—Password for the study schema owner.
rep_schema_owner_password—Password for the reporting schema owner.
dbauser_trial_password—Password for the study DBA user.
dbauser_rep_password—Password for the reporting DBA user.
streams_admin_user_rep_passwd—Password for the reporting streams admin user.
streams_admin_user_trial_pwd—Password for the study streams admin user.
rep_proxy_user_password—The password for the user that exists in the study database who has read-only access to the specified study schema.

For legacy purposes, you can also pass the parameters by using the /accountparams:"path_to_parameter_file" command option.

When specified, this option includes the path to a text file that contains the values required to run the command. The format of the parameter file is parameter=value. There is a new line for each parameter, and there are no spaces on a line.

Notes

Before running the installation script, make sure that you have updated the study-specific variable settings with the configdiffdb.sql script.

Note: The InForm database installation and administration scripts are designed to be run using the InForm Application Server. The scripts can also be run from the Oracle database home on an InForm Reporting Server. Running them from a different Windows Oracle client or from a non-Windows Oracle client or database home may work, but is not supported.