Create the streams between the InForm study schema and the Reporting schema, and install the Reporting schema

Purpose—Installs the Reporting and Analysis module in an environment where the study and reporting databases are in different database instances.
Script—install_reporting_diffdb
Where to run—Folder in which the reporting software is located, for example, <Installation_Directory>\Inform\bin\DBOra\Reporting.

Use the install_reporting_diffdb.sql script to install the Reporting and Analysis module in a multiple database environment. Before running the installation script, make sure that you have updated the study-specific variable settings with the configdiffdb-<studyname>.sql script. For more information, see Configuring the reporting variables for a study—Different database instances.

Open a Command Prompt window.
Change to the directory where the reporting software is located.
Run the script using the command:
install_reporting_diffdb

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.
Search the logs for the word Error. If the installation is successful, you should find no errors.
After the installation is complete, copy the configdiffdb.sql file to a different location with a different name.
You will need this file in the future if you want to uninstall or re-install the Reporting and Analysis module.

Note: If the installation process fails, run the deinstall_reporting_diffdb.sql script to remove all components associated with the Reporting and Analysis module for a single study schema and reporting schema. For more information, see About removing reporting elements and an InForm study.

For more information, see install_reporting_diffdb.