Configuring the reporting variables for a study

Configuring the reporting variables for a study—Different database instances

Purpose—Configure reporting variables in an environment in which the study and reporting schemas are located in different database instances.
File to edit—configdiffdb.sql
File location—Folder in which the reporting software is located, for example, <Installation_Directory>\InForm\bin\DBOra\Reporting.

To configure reporting variables, you edit the configdiffdb.sql script. The installation and uninstallation scripts use the configdiffdb.sql file for user name, tablespace, and connection information.

There are some variables that are preset. You must not try to change them. These variables are indicated with a P in the table that follows.
When you set up the InForm environment to support the Reporting and Analysis module, you edited the configdiffdb.sql script to set the values of variables that remain constant for the database instance in the environment. These variables are indicated with an I in the table that follows.

Before you install the Reporting and Analysis module for a specific study, you must verify or update the configdiffdb.sql variables that are specific to the study. These variables are indicated with an S in the table that follows. When you finish updating the variables, rename the file ConfigDiffDB-<studyname>.sql.

Reporting variables and values

I/S	Variable	Value	Comments
	I=Set one time for the database instance; S=Set for each study; P= Do not change.
I	trialdb_tnsnames_alias	Tnsnames alias for the study database.	Used for connection to the study database. Also used as a part of the PUBLIC database link.
P	trialdbstring	@&&trialdb_tnsnames_alias	Preset variable. Do not change. Used for connection to the study database.
S	trial_schema_owner	InForm study schema owner.	Oracle user name of the study schema owner in the study database.
S	rep_proxy_user	New user. Prepend RP to the InForm study schema owner.	Oracle user name in the study database that serves as a proxy user for reporting database connections.
I	trial_to_rep_dblink _name	Global name of the reporting database.	Name of all database links in the study database. Connect to the reporting database and run the command: Select global_name from global_name; Use the value returned from this command for this variable.
P	trial_dblink_name_select	@&&trial_to_rep_dblink _name	Preset variable. Do not change. Used for connection to remote objects in the reporting database.
I	repdb_tnsnames_alias	Tnsnames alias for the reporting database.	Used for connection to the reporting database. Also used as a part of the PUBLIC database link.
P	repdbstring	@&&repdb_tnsnames_alias	Preset variable. Do not change. Used for connection to the reporting database.
P	rep_schema_owner	&&trial_schema_ow	Preset variable. Do not change.
I	rep_to_trial_dblink _name	Global name of study database.	Name of all database links in the reporting database. Connect to the study database and run the command: Select global_name from global_name; Use the value returned from this command for this variable.
P	rep_dblink_name_select	@&&rep_to_trial_dblink _name	Preset variable. Do not change. Used for connection to remote objects in the study database.