Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Installing the Siebel Customer-Centric Enterprise Warehouse Environment > Process of Defining Your Installation Configuration >

Determining Configuration Requirements

This task is a step in the Process of Defining Your Installation Configuration.

To determine configuration requirements, you must identify the Siebel Business Analytics components to be installed and plan their configuration in your environment. Some factors that determine your installation configuration are:

• Hardware costs
• Operating system used to run Siebel Business Analytics
• Number of rows being extracted from the source
• Number of Siebel Business Analytics users

The configuration must specify:

• Connection information for source machines. Specify information about the network addresses of the source system from which data needs to be extracted, any associated constraints, ODBC connect strings, and so on.
• Physical location of the server. Identify the specific machines and their IP addresses, disk sizes, CPUs, memory, operating system, and so on.
• Physical location of the databases. Specify the database to be configured on the servers. The databases are used to house the data warehouse, staging tables, control tables, and so on.

  You must also make sure of the following in relation to the physical location of the databases:

  • It is recommended that you locate the staging area and the data warehouse in a single database with one user ID. This configuration makes it easier to create outer joins between the staging area and data warehouse tables, without needing multiple synonyms.
  • If you do create a separate user for the staging tables and the data warehouse, your staging area user must have select privileges on all the data warehouse objects. Create the appropriate grant and synonym creation scripts necessary for this purpose. To minimize input or output contention and improve performance, it is recommended that you create indexes in a separate tablespace.