DiffDB—Separate database instances for InForm and Cognos reporting software

If you choose to install the InForm and Cognos reporting software on separate database instances, you could use separate database instances for each of the following:

Each InForm server, which contains one InForm Admin schema and multiple InForm study schemas.
InForm Reporting schema.
Cognos 10 BI Content Store schema.
PFCap Admin schema
Note: The PFCap Admin schema can reside in a separate instance or the same instance as the Cognos 10 BI Content Store schema.

Observe the following architecture rules:

You must install the Reporting and Analysis environment (InForm Reporting database) in a different database instance than the instance for the study.
The InForm application server(s) and the Cognos 10 BI application server(s) must be in the same domain.
The Oracle user name for the reporting schema in the reporting database instance must be the same as the Oracle user name for the study schema in the study database instance. Because the users are in different database instances, the user names may have different passwords.
Only one reporting environment is allowed per study schema.
A single reporting database can hold multiple reporting schemas. The study schemas that are associated with these reporting schemas might exist in one or in multiple study databases.
The study and reporting schemas cannot be installed in the same database as the Content Store database for Cognos 10 BI Reporting. No other Oracle products, such as the CIS software or the Clintrial software, should already reside in or be added to the study and reporting database.
The study schema must be created with archive log mode enabled.
For more information, see Archive log mode in a multiple database environment.

Note: Automated deployments from the Central Designer application are not supported for environments that have the InForm database and the InForm reporting database installed on separate instances.