WebLogic Portlets for Siebel Installation Guide
WebLogic Portlets for Siebel Installation Guide
This document explains how to install the BEA WebLogic Portlets for Siebel application.
The BEA WebLogic Portlets for Siebel application integrates BEA WebLogic Portal with the Siebel 7.0.4 system.
This guide contains the following sections:
Installation Prerequisites for BEA WebLogic Portlets for Siebel
Hardware Requirements
The server should have the following configuration:
- Pentium 4, 1GHz or higher
- 1GB RAM or more
- 40GB HDD
Software Requirements
The following software must be installed on the server:
- BEA WebLogic Platform 8.1 SP2 or SP3
- Siebel 7.0.4
- One of the following databases should be available:
- Oracle 8i or higher
- MS SQL Server 2000 SP2
- One of the following web browsers should be available:
- Internet Explorer 6 or higher
- Netscape 7.1 or higher
- Java 2 SDK
Administrator Privileges
You must have BEA WebLogic Platform administrator privileges in order to install and configure the BEA WebLogic Portlets for Siebel application.
Licensing and Encryption
The WebLogic Platform software cannot be used without a valid license. You can purchase licenses for the entire WebLogic Platform product or for individual components. For information about the licenses available for WebLogic Platform, contact your sales representative or visit the BEA corporate Web site at http://www.bea.com.
About 128-Bit Encryption
Secure sockets layer (SSL) encryption software is available with two levels of encryption: 56-bit and 128-bit. Licenses for the 128-bit client version of SSL are available in the United States and Canada. With proper authorization, customers outside the United States and Canada may also acquire licenses with 128-bit encryption enabled.
A WebLogic Platform license comes with 56-bit encryption enabled by default. Enabling 128-bit encryption for SSL requires that a 128-bit encryption license be present in the license.bea file of the target BEA Home directory before you install the WebLogic Platform software.
Installing BEA WebLogic Portlets for Siebel
Before you start the BEA WebLogic Portlets for Siebel installation ensure that you are installing BEA WebLogic Portlets for Siebel on a supported platform. See Installation Prerequisites for BEA WebLogic Portlets for Siebel on page 2.
Installing BEA WebLogic Portlets for Siebel
BEA WebLogic Portlets for Siebel can be installed on both Unix and Windows operating systems using graphical-mode installation.
Graphical-Mode Installation on a Windows System
To start the installation:
- Log in to the Windows system.
- Insert the BEA WebLogic Portlets CD-ROM into the CD-ROM drive.
- Navigate to the folder and run the installation file
Bea_Siebel.exe
.
- The program prepares your system for the installation task.
Figure 1 Installation Initialization Screen
- The Introduction screen appears. Click Next to continue.
Figure 2 Introduction Screen
- In the Choose Installation Folder screen, specify the path of the installation directory or click Choose to select the
\bea\weblogic<version>
directory. This is the path where BEA WebLogic Portlets for Siebel will be installed.
Figure 3 Choose Installation Folder Screen
Note: If a folder other than \bea\weblogic<version>
is selected then you need to manually copy the templates files from <selected folder>\workshop\templates
to \bea\weblogic<version>\workshop\templates
.
- The Pre-Installation Summary screen displays your installation preferences. Click Install to continue.
Figure 4 Pre-installation Summary Screen
- The Installing BEA WebLogic Portlets Installation Setup screen displays the progress of the installation.
Figure 5 Installing Screen
- The Install Complete screen confirms that BEA WebLogic Portlets for Siebel was installed successfully. Click Done to complete the installation.
Figure 6 Install Complete Screen
Graphical-Mode Installation on a Unix System
To start the installation on Unix system:
- Log in to the Unix system.
- Mount the BEA WebLogic Portlets CD-ROM into the CD-ROM drive.
- Open a command-line shell.
- Go to the CD-ROM directory and navigate to the folder for the installation program
install.bin
.
- Invoke the procedure by entering the following command:
./install.bin
- The program prepares your system for the installation task.
Figure 7 Installation Initialization Screen
- The Introduction screen appears. Click Next to continue.
Figure 8 Introduction Screen
- In the Choose Installation Folder screen, specify the path of the installation directory or click Choose to select the
\bea\weblogic<version>
directory. This is the path where BEA WebLogic Portlets for Siebel will be installed.
Note: If a folder other than \bea\weblogic<version>
is selected then you need to manually copy the templates files from <selected folder>\workshop\templates
to \bea\weblogic<version>\workshop\templates
.
Figure 9 Choose Installation Folder Screen
- The Pre-Installation Summary screen displays your installation preferences. Click Next to continue.
Figure 10 Pre-Installation Summary Screen
- The Installing BEA WebLogic Portlets For Siebel screen displays the progress of the installation.
Figure 11 Installing Screen
- The Install Complete screen confirms that BEA WebLogic Portlets for Siebel was installed successfully. Click Done to complete the installation.
Figure 12 Install Complete Screen
Reviewing the Installation
The installer will install files in the following directories:
Configuring the BEA WebLogic Portal
After the installation is completed, perform the following tasks using the BEA WebLogic Workshop.
For a New Portal:
- Create a new Basic WebLogic Portal Domain using the Configuration Wizard.
- Create a new Portal Application in WebLogic Workshop.
- Create a new Portal Project.
- In the WebLogic Workshop's Application, right-click the Data directory and choose Install > PortletsForSiebelPropertySet.
- In the WebLogic Workshop's Application, right-click the portal project directory and choose Install > Portlets for Siebel.
Downloading the Third Party Software
Table 1 List of JAR files required for BEA WebLogic Portlets
JAR file
|
Component
|
Download from /Copy From
|
Directory
|
xercesImpl.jar
xalan.jar
xml-apis.jar
xmlParserAPIs.jar
|
XMLhelper
|
Download from http://xml.apache.org/dist/xerces-j/old_xerces2/
|
<\%BEA_HOME%>\user_projects\application\<protalapplication>\<portalproject>\WEB-INF\lib
Example:
C:\bea\user_projects\applications\BeaPortalNetApp\beaportal\WEB-INF\lib
|
classes12.zip (JDBC driver for Oracle database)
|
BEAPortalnet dbAccessLayer
|
Download the appropriate driver from http://otn.oracle.com/software/index.html
OR
Copy from <%ORACLE_HOME%>/jdbc/lib directory.
|
Set it in the CLASSPATH
|
SiebelJI_Common.jar
|
Siebel
|
Copy from the Siebel installed directory.
|
<\%BEA_HOME%>\user_projects\application\<protalapplication>\<portalproject>\WEB-INF\lib
|
SiebelJI_enu.jar
|
Siebel
|
SiebelJI.jar
|
Siebel
|
Jce.jar
|
Encryption
|
|
bcprov-jdk14-122.jar
|
Encryption
|
|
Downloading Oracle JDBC Drivers
To download Oracle JDBC drivers, you can either:
- Sign in and download the
classes12.zip
.
Or, if you already have Oracle installed:
- Set the CLASSPATH for
classes12.zip
to the <%ORACLE_HOME%>/jdbc/lib
directory.
Configuration and Settings for Siebel (on Unix)
Make the following changes on the Unix system:
- Open the file startWLS.sh located in ${WL_HOME}/server/bin directory, for editing.
- At the bottom of the file, locate the following java command that starts the application.
"${JAVA_HOME}/bin/java" ${JAVA_VM} ${MEM_ARGS} ${JAVA_OPTIONS} -classpath
- Add the following statement to the java command:
-Dfile.encoding="ISO8859_1"
as shown below:
"${JAVA_HOME}/bin/java" ${JAVA_VM} ${MEM_ARGS} ${JAVA_OPTIONS} -Dfile.encoding="ISO8859_1" -classpath
- Save the changes and close the file.
- Open the DOMAIN_HOME/startWeblogic.sh file for editing.
- At the bottom of the file, locate the following java command:
${JAVA_HOME}/bin/java ${JAVA_VM} ${MEM_ARGS} ${JAVA_OPTIONS} -Dweblogic.Name=${SERVER_NAME}
- Modify the java command with the following statement:
-Dfile.encoding="ISO8859_1"
as shown below:
${JAVA_HOME}/bin/java ${JAVA_VM} ${MEM_ARGS} ${JAVA_OPTIONS} -Dfile.encoding="ISO8859_1" -Dweblogic.Name=${SERVER_NAME}
- Save the changes and close the file.
- Copy the jar files
SiebelJI_Common.jar
, SiebelJI_enu.jar
, SiebelJI.jar
to any directory.
- Open the $DOMAIN_HOME/setDomainEnv.sh file for editing.
- Add the files to the CLASSPATH variable.
- Save the changes and close the file.
Configuration and Settings for BEA WebLogic Portlets
Setting Up Siebel Portlets Repository
Creating Schema and Importing Metadata in MS SQL Server
To create schema and import metadata for WebLogic Portlets for Siebel in MS SQL Server run the following scripts in MS SQL Server's Query Analyzer in the order given below.
- If WebLogic Portlets for Siebel has not been installed on your machine, then run the following scripts.
The scripts for creating schema are located at the following path:
<%BEA_HOME%>\weblogic<version>\portal\thirdparty\siebelportlets\scripts\schema\mssql
- MSSQL_PNET_DROP_TABLE.SQL
- MSSQL_PNET_ CREATE_TABLES.SQL
- MSSQL_PNET_DROP_FKEYS.SQL
- MSSQL_PNET_CREATE_FKEYS.SQL
- The script for importing metadata is located at the following path:
<%BEA_HOME%>\weblogic<version>\portal\thirdparty\siebelportlets\scripts\data
MSSQL_PNET_INSERT_SCRIPTS.SQL
- If WebLogic Portlets for SAP has been installed on your machine, then run the following queries:
- ALTER TABLE PNET_USER_PARAM_MAP ADD PARAM_VALUE1 VARCHAR (30);
- ALTER TABLE PNET_USER_PARAM_MAP ADD PARAM_VALUE2 VARCHAR (30);
Creating Schema and Importing Metadata in Oracle
To create schema and import metadata for BEA WebLogic Portlets in Oracle database run the following scripts in Oracle's SQL Plus in the order given below:
- If WebLogic Portlets for SAP has not been installed on your machine, then run the following scripts:
The scripts for creating schema are located at the following path:
<%BEA_HOME%>\weblogic<version>\portal\thirdparty\siebelportlets\scripts\schema\oracle
- ORACLE_PNET_DROP_SEQUENCE.SQL
- ORACLE_PNET_DROP_FKEYS.SQL
- ORACLE_PNET_DROP_TABLE.SQL
- ORACLE_PNET_CREATE_TABLES.SQL
- ORACLE_PNET_CREATE_ SEQUENCE.SQL
- ORACLE_PNET_CREATE_FKEYS.SQL
- The script for importing metadata is located at the following path:
<%BEA_HOME%>\weblogic<version>\portal\thirdparty\siebelportlets\scripts\data
ORCLE_PNET_INSERT_SCRIPTS.SQL
- If WebLogic Portlets for SAP has been installed on your machine, then run the following queries:
- ALTER TABLE PNET_USER_PARAM_MAP ADD PARAM_VALUE1 VARCHAR2 (30);
- ALTER TABLE PNET_USER_PARAM_MAP ADD PARAM_VALUE2 VARCHAR2 (30);
Configuring the SiebelPortalNet.properties File
To configure the properties file:
- Open the SiebelPortalNet.properties file from the
\bea\user_projects\applications\<application>\<project>\WEB-INF\classes
subfolder for the product installed and change the settings.
- Modify the repository connection information, DATASOURCE=<datasource_ name>
For example: DATASOURCE=EISDB
Registering Java Data Source
To create a Java Data Source:
- Start the WebLogic Server for your domain.
- Go to Tools > WebLogic Server > DataSource Viewer. The DataSource Viewer window appears.
- Click "New Data Source" button to add a new data source. The Configure DataSource window appears.
Figure 13 Configuring DataSource (for Oracle) Screen
Figure 14 Configuring Data Source (for MS SQL Server) Screen
- Enter the Data Sources as EISDB.
- Select the Pool as <Create New Pool>.
- Enter the Pool Name as EISDB.
- Configure the Driver, URL, User and Password and click OK.
Activating the License for BEA WebLogic Portlets
To activate the license for BEA WebLogic Portlets:
- Copy the license file license.bea into the
<%BEA_HOME%>
directory.
- Restart the WebLogic Portal server.
- Login to BEA WebLogic Portlets with the weblogic account.
Uninstalling BEA WebLogic Portlets for Siebel
To uninstall BEA WebLogic Portlets for Siebel:
- Shut down any servers that are running. If any of these servers is configured as a Windows service, you should stop the service(s) before uninstalling the software.
- Navigate to the directory where BEA WebLogic Portlets is installed.
- Navigate to the
\Uninstall_Bea Weblogic Portlets for Siebel
directory.
- Run the
Uninstall BEA Weblogic Portlets for Siebel.exe
uninstallation program.
- Click Next to start the uninstall program.
- Select Complete Uninstall or Uninstall Specific Features option and click Next.
- Click Done to exit the uninstallation program.
Troubleshooting
Table 2 Troubleshooting WebLogic Portlets for Siebel
No.
|
Problem
|
Cause
|
1
|
Running the scripts throws SQL error
|
Make sure that you run the scripts in the order specified in the installation document
|
2
|
Unable to connect to the database
|
Check if the JDBC Drivers are configured properly.
|
3
|
Invalid datasource entry error
|
Check if the DataSource is configured properly in WebLogic Workshop
|
4
|
Cannot connect to Siebel
|
Verify if the files SiebelJI , SiebelJI_Common and SiebelJI_enu are placed under the directory <\%BEA_HOME%>\user_projects\application\<protalapplication>\<portalproject>\WEB-INF\lib
|
5
|
License Expired
|
Check if the license.bea file is updated under the folder <%BEA_HOME%>
|
6
|
Unknown Source Exception
|
Make sure that you have given the IP Address and machine name of the Database server and Siebel server in the file named hosts.file which is located at C:\windows\system32\drivers\etc
|
7
|
Unable to run the installation setup for Unix
|
Check if Java Virtual Machine (JVM) is installed.
Check if the environment variables PATH and JAVA_HOME are set.
|
Installation Verification Tests for BEA WebLogic Portlets for Siebel
Customer Name
|
|
Install Date
|
|
Install Specialist
|
|
Install Contact
|
|
DBMS Type
|
|
Version
|
|
Operating System
|
|
Version
|
|
Instructions
This section provides instructions on running the installation verification test.
- This Installation Verification Test is designed to confirm that BEA WebLogic Portlets for Siebel has been installed properly. The Installation Verification Test is not designed to serve as a comprehensive test of BEA WebLogic Portlets for Siebel functionality.
- BEA specialists performing this test should provide one copy of this test to the customer installation contact by attaching it to a copy of the Post Installation Checklist.
- Unless otherwise indicated, each section covers functionality for all platforms that BEA WebLogic Portlets for Siebel currently supports. Please note that not all products are available on all platforms.
- Microsoft SQL Server on Windows
- Oracle on Windows
- The BEA WebLogic Platform Installation Verification Test should be completed prior to starting this test.
- BEA WebLogic Portlets for Siebel must have been installed as per the Installation Guide for BEA WebLogic Portlets for Siebel.
- The following tests should be performed using BEA WebLogic Workshop and BEA WebLogic Administration screen.
- Please refer to the User Guide and the Administration Guide for BEA WebLogic Portlets for Siebel for more details on using the product.
Installation Verification
Verify Project Templates
Project related templates would be copied into a directory at <%BEA_HOME%>\weblogic81\workshop\templates
.
Verify that the following files are present in the folder:
wlp-portletsforsiebel.zip
wlp-portletsforsiebeldata.zip
Verify Sample View Templates
Sample view templates (for .jsp and .jpf files) will be copied into a directory at <%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\newportlets
.
Verify that the following files are present in the folder:
viewtemplate.jsp
viewtemplatecontroller.jpf
Verify Product Documentation
Third party product documentation, if provided, will be copied into a directory at <%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\docs
.
Verify that the following files are present in the folder:
- BEA WebLogic Portlets Administration Guide.doc
- BEA WebLogic Portlets Installation Guide.doc
- Development Guide for BEA WebLogic Portlets.doc
- User Guide for BEA WebLogic Portlets.doc
Verify SQL Scripts
SQL scripts for MS SQL Server will be copied into a subdirectory of <%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\scripts\schema\mssql
.
Verify that the following script files are copied into the folder:
- MSSQL_PNET_DROP_TABLE.SQL
- MSSQL_PNET_ CREATE_TABLES.SQL
- MSSQL_PNET_DROP_FKEYS.SQL
- MSSQL_PNET_CREATE_FKEYS.SQL
Also verify that the insertion script file MSSQL_PNET_INSERT_SCRIPTS.SQL is copied into the following folder:
<%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\scripts\data
SQL scripts for Oracle will be copied into a subdirectory of <%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\scripts\schema\oracle
.
Verify that the following files are present in the folder:
- ORACLE_PNET_DROP_TABLE.SQL
- ORACLE_PNET_CREATE_TABLES.SQL
- ORACLE_PNET_DROP_SEQUENCE.SQL
- ORACLE_PNET_CREATE_ SEQUENCE.SQL
- ORACLE_PNET_DROP_FKEYS.SQL
- ORACLE_PNET_CREATE_FKEYS.SQL
Also verify that the insertion script file ORCLE_PNET_INSERT_SCRIPTS.SQL is copied into the following folder:
<%BEA_HOME%>\weblogic81\portal\thirdparty\siebelportlets\scripts\data
.
Database Verification
Verify Database
Prerequisite: DataSource Creation has been done either using the BEA WebLogic Workshop / WebLogic console.
Assumption: DataSource/Connection pool has been created using either BEA WebLogic Workshop/WebLogic console as specified in the Installation document.
To verify database settings:
- In BEA WebLogic Workshop, select Tools > WebLogic Server > DataSource Viewer.
- Select the datasource as EISDB.
- The following datasource information should be displayed:
Figure 15 DataSource Viewer Screen
Note: The DataSource Name field should display as above, but the remaining fields may contain different information depending on your specific installation.
EIS Administration Verification
Verify EIS Administration Portlet Initialization and Authentication
To verify administration authentication:
- Build the project and start the BEA WebLogic server.
- Log in to BEA WebLogic Portlets for Siebel using the administrator account, with
Username: weblogic
Password: weblogic
- Verify that the server is running. Also verify that you are able to login successfully.
Verify EIS Instance Creation
To create an EIS instance:
- Login to BEA WebLogic Portal as administrator.
- Click the Administration tab.
- Click the EIS Instance Setup link.
- Select the EIS Application as SIEBEL7.0.4 and click Create.
- Enter an Instance Name of your choice.
- Enter the Native Base URL. This is the URL of the Siebel system.
- Enter the User Id and Password for logging in to the Siebel system.
- Enter the Enterprise Name.
- Enter the Siebel Server Name.
- Enter the number of Maximum Connections allowed for the Siebel system.
- Click Submit to create the instance.
- Verify that the newly created EIS instance appears in the list of Existing EIS instances.
Verify EIS Credential Mapping
To create an EIS credential mapping:
- Login to BEA WebLogic Portlets as administrator.
- Click the Administration tab.
- Click the EIS Credential Mapping Details link.
- Use any one of the following search criteria:
- Enter the Portal User Id and click search.
- Click Show All Portal Users link.
- Click on an alphabet with which the portal user's login name starts.
- The list of Portal Users matching the search criteria is populated in the Portal User Id drop down box. Select the Portal User Id.
- Select the Instance Name.
- Click Search. The list of existing EIS User credentials is displayed.
- Select the User Type as either CUSTOMER or EMPLOYEE.
- Enter the Siebel User Id and Password.
- Select the Allow Drilldown To EIS option to give Native drill down to view the information in the Portlet though ITS (Internet Transaction Service) by the portal user as required.
- Select the Allow Detailed Information option to give Target drilldown to view the Siebel window information in the Portlet by the portal user as required.
- Select the Status of the user as Active to activate this EIS user account in retrieving information from the selected EIS Instance (in above step), Otherwise select the Status as Inactive. Only one EIS mapping will be active at a given time.
- Verify that the newly created EIS mapping appears in the list of EIS credential mappings.
Portlets Verification
Verify Authentication
- Log in to BEA WebLogic Portlets for Siebel using the EIS user credential mapping that you created above.
- Verify that all the following portlets are shown:
- Sales Order
- Shipping Status
- Service Request
- Service Request Activity
- My Accounts
- My Team Accounts
- Agreements By Expiry Date
- All Assets By Account
- Contacts By Account
- Customer List With Address Info
- Repair Status
- RMA Order Status
Note: The visibility of the portlets will vary depending on the permission set by the administrator to the users for the above listed portlets.
Verify the Sales Order Portlet
Prerequisite: The user has successfully logged into the Portal.
To view an existing sales order:
- Scroll down to the Sales Order portlet. Verify that the list of sales orders is displayed.
- Click the Order # hyperlink to view details for the required Sales Order.
- Verify that the Siebel screen for the selected Sales Order is displayed.
To create a new sales order:
- Scroll down to the Sales Order portlet.
- Click Create Sales Order hyperlink. A new screen is displayed.
- Search for the Customer Id.
- Enter the Quantity Requested.
- Select the Product Discount percentage.
- Specify the Promised Delivery Date.
- Click Create. The Sales Order portlet is displayed.
- Verify that the new sales order was created.
Verify the Shipping Status Portlet
Prerequisite: The user has successfully logged into the Portal.
To edit / update a sales order shipping status:
- Select the sales order by clicking on the Status of the Sales Order portlet.
- The Sales Order Shipping Status portlet shows the shipping status information pertaining to the selected sales order.
- Under the Actions column, click the edit icon in order to edit / update the sales order shipping status details.
- Update the details for Quantity Requested and Status.
- Click Update. The Shipping Status portlet is displayed.
- Verify that the shipping status was updated.
Verify the My Accounts Portlet
Prerequisite: The administrator has given permission, for this portlet, to the portal user, who can be either an employee or an administrator or both.
To view My Accounts Portlet:
- Log in to BEA WebLogic Portlets for Siebel.
- Scroll down to the My Accounts portlet. Verify that the list of accounts is displayed.
- Click the Account Name hyperlink to view details of that Account.
- Verify that the Siebel screen for the Account is displayed.