Installation and Upgrade > Installation and Configuration Guide > Using the PTC Solution Installer > Installing Windchill Solutions > Optional Product Settings > Windchill Business Reporting > Distributed Installation - Three Machines
  
Distributed Installation - Three Machines
In a three machine distributed installation scenario, the host components are installed on one machine, the gateway server on a second machine, and your Windchill solution on a third machine. The PSI is run three times, in the following order:
1. Install the PTC Windchill Business Reporting Host Components
2. Install the Gateway Server
3. Install Your Windchill Solution
Install the PTC Windchill Business Reporting Host Components
From the list of solutions to install, select the Standalone Product or Component checkbox.
Select from the following standalone product or component options:
* 
If you leave both the Oracle Configuration and SQL Server Configuration deselected, it is assumed that a database and associated user already exist, and that you will supply that information in the database information screen.
Option
Default
Description
Oracle Configuration
Deselected
Select this option if you are configuring an Oracle database as part of this installation scenario. Under this option, select the following as appropriate:
• Create Database - selected by default.
* 
When creating an Oracle database using PSI, you can launch PSI as the user that installed the database software, or as root user.
• Create PTC Windchill Database User Account - selected by default.
• Create PTC Windchill Business Reporting Database User Account - deselected by default. Select this checkbox to create a new database user. To use an existing database user, leave deselected.
SQL Server Configuration
Deselected
Select this option if you are configuring a SQL Server database as part of this installation scenario. Under this option, select the following as appropriate:
• selected by default.
• Create PTC Windchill Business Reporting Database and User - deselected by default. Select this checkbox to create a new database and user. To use an existing database and user, leave deselected.
PTC Windchill Business Reporting
Deselected
Select this option to install the Windchill Business Reporting components. Under this option, select as follows:
• Install the Host Components - Select this option to install the host. Select from the following as appropriate for your installation, you must select one:
Configure SQL Server Database
• Install the Gateway Server - Deselect this option.
Enter the following installation directory information:
Option
Default
Description
Installation Directory for PTC Windchill Business Reporting
<base installation directory>\Reporting
The location where the host components are installed.
* 
Installation Directory for PTC Windchill Business Reporting should be empty else Cognos installation fails.
Enter the following database information. If you selected the Create PTC Windchill Business Reporting Database User Account or Create PTC Windchill Business Reporting Database and User checkbox previously on the standalone product or component options screen, then the values entered in these fields are used to create the user. Otherwise, enter the values for an existing database user.
Options
Description
PTC Windchill Business Reporting Oracle Database User Name for the Database User Account
or
PTC Windchill Business Reporting SQL Server Database User Name for the Database User Account
The user name for the Windchill Business Reporting database user.
PTC Windchill Business Reporting Oracle Database Password for the Database User Account
or
PTC Windchill Business Reporting SQL Server Database User Password for the Database User Account
The password for the Windchill Business Reporting database user.
Confirm PTC Windchill Business Reporting Oracle Database Password for the Database User Account
or
Confirm PTC Windchill Business Reporting SQL Server Database User Password for the Database User Account
Confirm the password entered in the previous field. This field appears only if the Create PTC Windchill Business Reporting Database User Account or Create PTC Windchill Business Reporting Database and User option was selected previously from the optional products screen.
Specify the appropriate LDAP settings for your configuration. For more information, see Entering Your LDAP Settings.
Set the following optional product settings:
Option
Default
Description
PTC Windchill Business Reporting Gateway Machine’s DNS Registered Host Name
local machine
Location where the gateway server will be installed. Be sure to note this location to use when you install the gateway server.
PTC Windchill Business Reporting Gateway Machine’s Web Server Port
80
Port that the gateway server will listen on to communicate with the host components. Be sure to note this location to use when you install the gateway server.
Communication Port of the PTC Windchill Business Reporting Host
9300
Port used by Windchill Business Reporting host to communicate with the Windchill Business Reporting gateway.
Install the Gateway Server
From the list of solutions to install, select the Standalone Product or Component checkbox.
Select from the following standalone product or component options:
* 
If you leave both the Oracle Configuration and SQL Server Configuration deselected, it is assumed that a database and associated user already exist, and that you will supply that information in the database information screen.
Option
Default
Description
Oracle Configuration
Deselected
Select this option if you are configuring an Oracle database as part of this installation scenario. Under this option, select the following as appropriate:
• Create Database - selected by default.
* 
When creating an Oracle database using PSI, you can launch PSI as the user that installed the database software, or as root user.
• Create PTC Windchill Database User Account - selected by default.
• Create PTC Windchill Business Reporting Database User Account - deselected by default. Select this checkbox to create a new database user. To use an existing database user, leave deselected.
SQL Server Configuration
Deselected
Select this option if you are configuring a SQL Server database as part of this installation scenario. Under this option, select the following as appropriate:
• selected by default.
• Create PTC Windchill Business Reporting Database and User - deselected by default. Select this checkbox to create a new database and user. To use an existing database and user, leave deselected.
PTC Windchill Business Reporting
Deselected
Select this option to install the Windchill Business Reporting components. Under this option, select as follows:
• Install the Host Components - Deselect this option.
• Install the Gateway Server - Select this option to install the gateway server. The Configure Local PTC HTTP Server for Gateway check box must also be left selected (the default) for a local HTTP Server to be automatically configured by the PSI.
Enter the following installation directory information:
Option
Default
Description
Select Directory forPTC HTTP Server
Browse to the local HTTP Server location.
This field appears if the PTC HTTP Server check box was deselected on the standalone product or component screen.
Installation Directory forPTC HTTP Server
<base installation directory>\HTTP Server
The location where the HTTP Server will be installed.
This field appears if the PTC HTTP Server check box was selected on the Standalone Product or Component screen.
Installation Directory for PTC Windchill Business Reporting
<base installation directory>\Reporting
The location where the gateway server is installed.
Enter the following Web server and servlet engine information:
Option
Default
Description
HTTP Port Number
This value must match the value entered in the PTC Windchill Business Reporting Gateway Machine’s Web Server Port field when you installed the host.
Specify the appropriate LDAP settings for your configuration. For more information, see Entering Your LDAP Settings.
Set the following optional product settings:
Option
Default
Description
Mapped location of PTC Windchill Business Reporting Host installation (leave empty if locally installed)
The drive mapped to the host installation. You must share the host installation location on the host machine with read/write permissions for the machine where the Windchill solution is installed. Then, on the machine where the Windchill solution is installed, map a location to that shared host installation.
* 
This step must be completed before you can proceed with the installation.
DNS Registered Host Name of the PTC Windchill Business Reporting Host
local machine
This value must match the machine where the host components were installed.
Communication Port of the PTC Windchill Business Reporting Host
9300
Port used by Windchill Business Reporting host to communicate with the Windchill Business Reporting gateway.
This value must match the value entered when the host components were installed.
Install Your Windchill Solution
Install your Windchill solution, being sure to make the following Windchill Business Reporting related selections.
On the optional products screen, DO NOT select PTC Windchill Business Reporting.
On the product selections summary screen, set the following product features:
Option
Default
Description
Configure PTC Windchill for Business Reporting
Deselected
Select this field for Windchill Services to be properly configured for Windchill Business Reporting.
Set the following Data Loader Settings:
Option
Default
Description
Load base data
Selected
Loads the base data set, including the pre-defined reports for Windchill Business Reporting. PTC strongly recommends leaving this option selected, to avoid the need for certain manual post-installation configurations.
Specify the appropriate LDAP settings for your configuration. For more information, see Entering Your LDAP Settings.
Set the following administrative settings for Windchill Business Reporting:
Option
Default
Description
PTC Windchill Business Reporting Administrative User ID
wbradmin
This user has administrative privileges for Windchill Business Reporting but is not a Windchill administrative user. This user is created in the repository specified in the Base Distinguished Name for Administrative Users option on the LDAP settings screen.
PTC Windchill Business Reporting Administrative User Password
Enter the password for the Windchill Business Reporting administrative user.
Confirm Password for Administrative User
Confirm the password entered above.
Set the following optional product settings:
Option
Default
Description
PTC Windchill Business Reporting Gateway Machine's DNS Registered Host Name
local machine
Location where the gateway server was installed.
PTC Windchill Business Reporting Gateway Machine's Web Server Port
80
Port that the gateway server will listen on to communicate with the host components.
Mapped location of PTC Windchill Business Reporting Host installation (leave empty if locally installed)
The drive mapped to the host installation. You must share the host installation location on the host machine with read/write permissions for the machine where the Windchill solution is installed. Then, on the machine where the Windchill solution is installed, map a location to that shared host installation.
* 
This step must be completed before you can proceed with the installation.
DNS Registered Host Name of the PTC Windchill Business Reporting Host
local machine
This value must match the machine where the host components were installed.
Communication Port of the PTC Windchill Business Reporting Host
9300
Port used by Windchill Business Reporting host to communicate with the Windchill Business Reporting gateway.
This value should match the value entered when the host components were installed.
Location of PTC Windchill Business Reporting Host Installation as seen by the PTC Windchill Business Reporting Host
The installed location of Windchill Business Reporting as seen by the host component.