When you have met all of the prerequisites noted in previous sections, you are ready to run the Database Loader and WebSphere Business Integration Connect installation wizards.
Business Integration Connect provides a launch pad program, see Figure 24, to provide one-stop access to the Product Overview, ReadMe File, product documentation, database loader, and Business Integration Connect Installer. Alternatively, you can start the database loader and installation programs using the supplied setup*.* programs. See, Creating the database, and Installing the components using the install wizard.
The launch pad executable file is located in:
{CD_ROM/MEDIA DIR}/LaunchPad.*
Business Integration Connect includes an installation wizard to set up the database tables. This wizard, Database Loader, gathers information to create and populate the tables for you. Alternatively, it can save the SQL files it uses to create the tables. You can then use the SQL files to create and populate the tables. Running the SQL files manually allows the database administrator to review the database tables before populating them.
Before you begin, verify that your database server is installed, configured correctly, and running.
The following procedure describes how to configure the database using the Database Loader GUI. You can also install the Database Loader without using the GUI.
To set up the database tables:
The Database Loader wizard starts and displays the Welcome screen. Click Next.
Select a location with enough space for your database and all the application data that will be stored in it.
Click Next.
DB2:
If you selected DB2, the DB2 Database Information screen appears. Enter the following DB2 database information:
Oracle:
If you selected Oracle, the Oracle Database Information screen appears. Enter the following Oracle database information:
DB2:
In the Database Location screen, Figure 27, type the location of the database and each one of its tablespaces on the RDBMS server. The text boxes must contain the full path. Click Next.
Figure 27. DB2 Database Location screen
Oracle:
In the Database Location screen, Figure 28, type the location of the database and each one of its tablespaces on the RDBMS server. The text boxes must contain the full path. Click Next.
Figure 29. Component Configuration screen
In the User name and Password text boxes for the Community Console, Document Manager and Receiver, type the name and password of the user for that component. These users were created when the server was configured.
In the Group Name text box, type the name of the group that contains the Business Integration Connect users.
Click Next.
The system displays the Mount point for shared information screen.
Figure 30. Run the SQL Files screen
If the Database Loader runs the SQL files, it does the following:
Because the Database Loader restarts the DB2 instance as part of its routine, disconnect any applications that are using the DB2 instance where you are setting up the Business Integration Connect database.
If you want the Database Loader to run the files for you, select the Run the SQL files check box.
Click Next.
When you have set up the Business Integration Connect database, you are ready to install the Business Integration Connect components.
Business Integration Connect has three main components: Community Console, Receiver, and Document Manager. All three components share common content. You can either install the components and common content on a single server or install each component on a separate server. You must install one instance of each component on at least one server. See Environment planning and "Topologies" for information on how to plan the placement of the various components on different servers.
Before you begin, make sure that the prerequisite software is installed and configured properly. Consult the Requirements for all Business Integration Connect servers table in Platform, hardware, and software requirements for software prerequisites and Verifying and configuring installed prerequisites for information on how to configure that software.
You must also have the Business Integration Connect database set up. For information on this, see Creating the database. Finally, your database server and WebSphere MQ must be running, including the queue manager and listener.
The following procedure describes how to install the components using the InstallShield wizard GUI.
To install Business Integration Connect follow the steps below:
Hub installer requires Administrator privilege to properly create the Windows service.
The wizard starts and displays the Welcome screen. Click Next.
Figure 32. Component Selection screen
The rest of this procedure assumes that you are installing all of the components on the server. If you are not installing all of them, some of the screens described in the rest of this procedure will not appear.
DB2:
If you selected DB2, the DB2 Database Information screen appears. See Figure 34.
Figure 34. DB2 Database Information screen
Enter the requested information about the DB2 database.
In the Host name text field, if DB2 is not on the current system, replace localhost with the name of the system containing DB2.
In the Port text field, type the port that the DB2 instance is using. To find out which port the DB2 instance is using, either use the DB2 Control Center (GUI) to determine the properties or type the following on a command line: db2 get dbm cfg. This information (DB2 configuration) is also saved by the Database Loader in the "system temp"/WBIConnect/logs directory. The default port is 50000.
The path for DB2 is:
C:\Documents and Settings\db2admin\Local Settings\Temp\WBIConnect\logs
The path for Oracle is:
C:\Documents and Settings\Administrator\Local Settings\Temp\WBIConnect\logs
In the Owner name, Owner Password, Database name, and Schema name text fields, enter the requested information. These are the names that were used in the Database Loader installation to define the database. See "Creating the database".
Click Next.
Oracle:
If you selected Oracle, the Oracle Database information screen appears. See Figure 35.
Enter the required information about the Oracle database. The default port is 1521.
Figure 35. Oracle Database Information screen
The Database Connection Confirmation screen will appear. See Figure 36. If your connection is successful, note and confirm
the Table, View, Function, and Procedure count information. If the
connection fails, review the information screen for guidance or refer to your
database documentation to address the error code.
Figure 37. WebSphere MQ Server screen
In the Host name text box, if WebSphere MQ is not on the current machine, replace localhost with the name of the system containing WebSphere MQ.
In the Queue Manager text box, replace the default name with the name that was used when configuring WebSphere MQ (see "Configuring WebSphere MQ".)
In the Listener Port text box, type the port that the listener is using (see "Configuring WebSphere MQ".) The default port is 9999.
Click Next.
Click Next.
Figure 39. Community Console screen
In the User name text box, type the user ID that the Community Console component uses to log into the database.
In the Password text box, type the password associated with the user name. Make sure that you enter the correct password, because the Community Console will not function with an incorrect password.
In the HTTP Port text box, type the number of the port on which the component listens for messages. The Community Console, Receiver, and Document Manager must have unique port numbers, and they must be available on this computer. The default port is 58080.
In the HTTPS Port text box, enter the number of the secure port on which the component listens for messages. The Community Console, Receiver, and Document Manager must have unique port numbers, and they must be available on this computer. The default port is 58443.
Click Next.
Click Next when you are finished.
Figure 40. Receiver Configuration screen
Figure 42. RosettaNet Configuration screen
In the Name text box, type the name of the person that should be contacted for RosettaNet problems.
In the Phone number and Fax number text boxes, type the telephone and fax numbers of the RosettaNet contact person.
In the E-mail address text box, type the RosettaNet contacts' e-mail address.
Click Next.
Figure 43. Alert Notification screen
In the SMTP relay text box, type the location of the SMTP server.
In the From e-mail address text box, type the e-mail address Business Integration Connect uses to send e-mails.
In the To e-mail address text box, type the destination e-mail address that users responding to Alert Notifications use when they send a response e-mail.
Click Next.
Repeat this procedure on each server where you want to install Business Integration Connect components. The common content needs to be installed only once because it is available to all computers via the shared file system.
When you have installed all Business Integration Connect components, see "Installing the components using the command line".