|
|
|
|
SameDB—Single database instance for InForm and Cognos reporting software
or the default configuration, Oracle recommends installing the InForm software and the Reporting and Analysis module in the same database instance, and installing in different database instances only in certain cases.
- You can install in the same database instance if your study has up to 70 concurrent users and 8 concurrent reporting connections. The 8 reporting connections can be any combination of running an ad hoc query, a standard or custom report, or a report job.
- If your study requires more than 70 concurrent users and 8 concurrent reporting connections, installing in the same database instance may still be acceptable. However, you may want to consider installing the InForm software and the Reporting and Analysis module in different database instances.
- If your study requires 16 or more concurrent reporting connections, Oracle recommends installing in different database instances.
Observe the following architecture rules when setting up a single database instance for the InForm software and the Reporting and Analysis module:
- A single database can hold multiple reporting schemas.
- The study and reporting schema 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 InForm study and reporting database is not required to run in archive log mode.
