Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

IBM Application Portlet Builder (WPAI)

Product documentation

Overview

By selecting business objects available from the enterprise application, users can specify which data fields should be displayed in your portlet. When the portlet is created, the portlet can be made available to portal end users.

JCA adapters allow connections to multiple versions of PeopleSoft and Siebel servers on the same WebSphere Application Server machine. This adapter also allows markup-based configuration so that users can select and modify fields for each supported markup. In addition, portlets that are WML-enabled allow you to search and retrieve information through your WAP-enabled device.

Note:

Updates:

Using Application Portlet Builder

Users can view and modify the information from their enterprise application in the view mode of portlets created with Application Portlet Builder. Users may have to supply the user ID and password they use to access the enterprise application. Administrators can specify connection information and vault slot preference in configure mode.

Setting up Application Portlet Builder

Client requirements

This portlet supports browsers and devices capable of rendering HTML and WML markup. The following table provides detailed information.

Minimum requirements for HTML
Markup levelHTML 4.01 Transitional
Java applet

None

JavaScript

1.3

<iframe>

Domino only: Yes

Style sheets

Portal styles only

SoftwareThis portlet has been tested on the following browsers:
Accessibility

Yes

Minimum requirements for WML
Markup level
Other You must install WebSphere Portal Fix Pack 4.2.1 for WebSphere Portal 4.2, or install the Click-To-Action Version 4.1.1 portlet for WebSphere Portal 4.1.x.
SoftwareNokia 3.0 Simulator

Single sign-on is supported through the Portal Server Credential Vault. A user's credentials are stored in a slot assigned to each portlet. Initially, a separate slot is created for each portlet. However, a portlet's configuration mode can be used to set the name of a specific slot. If the same slot is used for all portlets that connect to the same application, a user's credentials need only be entered once.

See the WebSphere Portal documentation for information on using the Credential Vault.

Server requirements

Application Portlet Builder requires WebSphere Portal 4.1.2 or later. In addition, Application Portlet Builder requires one of the following enterprise applications:

Deployment/Installation

Application Portlet Builder requires several configuration steps that must occur before the portlet can be deployed in the Portal environment. Configuration steps specific to a particular enterprise application are noted.

Remove previous version of Portlet Builders (for WebSphere Portal 5.0.x only)

Application Portlet Builder (Domino and JDBC) is installed with WebSphere Portal v5 by default. This Application Portlet Builder must first be removed before installing the version from the WebSphere Portal and Lotus Workplace Catalog.

  1. Login as a portal administrator and go to Administration > Portlets > Manage Applications.
  2. Remove the following applications:

Install Struts (for WebSphere Portal 4.1.x only)

Before you install WPAI, you must install IBM Struts Portlet Framework Version 4.1.5, available from the WebSphere Portal and Lotus Workplace Catalog as NavCode 1WP10003N . Follow the instructions included with Struts for installation.

Install Click-to-Action (for WebSphere Everyplace Access 4.3.x only)

If you are using WebSphere Everyplace Access 4.3 or later, you must install WebSphere Portal Click-to-Action. Click-to-Action was shipped with the WPAI portlet package. If Click-to-Action is not currently installed on your WebSphere Everyplace Access server, follow these steps to install it:

  1. Stop the Portal Application Server.
  2. Save the c2asetup.jar file in a local directory. You can find the c2asetup.jar file in the WPAI zip file.
  3. Open a command prompt in the directory where you saved the c2asetup.jar file.
  4. Run the jar to launch the Installer. To properly execute this command, you must specify the WebSphere Application Server java bin as shown below:

    Example command line: C:\<was>\java\bin\java -jar c2asetup.jar, where <was> is the directory where WebSphere Application Server is installed on your machine.

  5. Follow the prompts in the Installer.

    Note: You will need to know the install directories of WebSphere Portal and WebSphere Application Server, the hostname of your machine, the WebSphere Application Server Node node name, and the WebSphere Portal administrator's user name and password. The wizard will display screens indicating that it is stopping the application server at the beginning and starting the application server at the end. It will not do so. Just click Next when you see these screens.

  6. Start the Portal Server.

Verify JCA support (for WebSphere Portal 4.x)

To verify that J2EE Connector Architecture (JCA) support is installed:

  1. Verify that the following files are in the was_root\lib directory, where was_root is the directory where WebSphere Application Server is installed (for example, C:\WebSphere\AppServer):
  2. If these files are not present in the was_root\lib directory, JCA support is not installed. Before continuing, uninstall Fix Pack 2 for WebSphere Application Server and then reinstall Fix Pack 2 with JCA support. Also be sure that you have met all other WebSphere Application Server requirements for WebSphere Portal 4.1.2 (refer to the WebSphere Portal documentation for more information on requirements).

Configure for PeopleSoft

WebSphere Portal 4.x:

If you have a previous version of Application Builder installed, you must first remove the existing JCA adapters before continuing. Use the following steps to remove the PeopleSoft 8 JCA adapter:

  1. Open the WebSphere Application Server Administrative Console.
  2. Remove any existing connection factories under the PeopleSoft adapters.
  3. Remove the PeopleSoft adapters.
  4. Close the Administrative Console.
  5. Remove the following files from was_root\lib\ if you installed the adapters prior to April 2003:
  6. Remove the file was_root\lib\psft8adapter.jar if you installed the adapters in April 2003 or later.
  7. Remove the directory and directory's contents from was_root\installedConnectors\psft.rar.
  8. Restart WebSphere Application Server.

After removing any existing PeopleSoft 8 connection factories and adapters, install the updated adapter using the following steps:

  1. Extract the contents of the download file to a directory of your choice, referred to as peoplesoft_home.
  2. Create a new empty directory in your hard drive, referred to as peoplesoft_lib_dir.
  3. Copy the following file from the PeopleSoft 8 server to peoplesoft_lib_dir:

    psjoa.jar, pstools.properties

  4. Deploy the PeopleSoft 8 JCA adapter in WebSphere Application Server
    1. Ensure that the WebSphere Application Server Administration Server service is running.
    2. Start the WebSphere Application Server Administrator's Console.
    3. Double-click WebSphere Administrative Domain in the tree view.
    4. Double-click Resources in the tree view.
    5. Right-click on J2C Resource Adapters, and select New.
    6. On the General tab of the J2C Resource Adapters Properties window, enter the following:
    7. In the Archive file name field, click the button labeled "..." to display the Install Driver window.
    8. Select the node where you want to deploy the resource adapter and specify the path and file name of the RAR file, peoplesoft_home\psft.rar, by doing one of the following steps:
    9. Click Install. The J2C Resource Adapters Properties window is updated to display the name of the RAR file you specified.
    10. Click OK to install the resource adapter. A confirmation message is displayed when the resource adapter is installed.
    11. Click OK to dismiss the message. The Administrator's Console is updated to display information about the resource adapter.
  5. Define a connection factory for the PeopleSoft JCA adapter.
    1. Double-click on J2C Resource Adapters in the tree view.
    2. Double-click on the resource adapter you just deployed. For example, PeopleSoft 8.
    3. Right-click on J2C Connection Factories, and select New.
    4. On the General tab of the J2C Connection Factories Properties window, enter the following:
    5. Click the Connections tab.
    6. Specify the properties for the PeopleSoft system you want to connect to by selecting the property from the list and entering a value in the entry field:
      hostName
      The host name of the PeopleSoft server to which you want to connect. For example, myserver.mycompany.com. The port number is for the JOLT Listener port. You can obtain the JOLT Listener port number from the PeopleSoft application server configuration file, psappsrv.cfg. An example location for that file is C:\PSFT_HRMS8.3\appserv\HR8DMO\psappsrv.cfg. An example hostName setting is //myserver.mycompany.com:9210. If you do not specify the port number, the default port number of 9000 is used.
      jarPath
      Enter the value peoplesoft_lib_dir, the directory where you placed the PeopleSoft libraries.
    7. Click OK.
  6. Copy server-specific files.
    1. Extract psft8adapter.jar from peoplesoft_home\psft.rar.
    2. Copy this file to the was_root\lib directory, where was_root is the directory where WebSphere Application Server is installed. For example, C:\WebSphere\AppServer.
    3. Restart WebSphere Application Server.
  7. The final step is importing the component interface list retrieval definition into PeopleSoft. There are two versions of the component interface: one for PeopleTools 8.18 and another for PeopleTools 8.42. If you are running PeopleTools 8.42 skip to step 8.
    Note: The component interface in the project, WPS_PS_CILIST, has been created and tested on PeopleTools 8.18, and is in general limited to that version of PeopleTools. If you attempt to import a component interface definition into another version of PeopleTools, you may crash the PeopleSoft Application Designer.
    1. Extract the contents of peoplesoft_home\wps_ps_cilist.zip to a directory of your choice (referred to as ci_home).
    2. Start the PeopleSoft Application Designer. To ensure that you can perform the steps below, log in to the Application Designer in two-tier mode.
    3. Select File > New to create a new project.
    4. Select File > Copy Project from File and specify the CI_home directory in the Import Directory field. You can enter the path directly or click "..." to browse to it.
    5. Verify that WPS_PS_CILIST is selected in the Project Name field.
    6. Click Copy.
    7. Select File > Save Project As, and enter a project name of your choice.
    8. Click OK.
    9. Exit the PeopleSoft Application Designer.
    10. Log into the PeopleSoft Web application.
    11. Select PeopleTools > Maintain Security > Use > Permission Lists .
    12. Add the imported component interface, WPS_CI_LIST to a permission list. You can use an existing permission list or create a new one. Select the Component Interface tab on the permission list to display the panel for adding the component interface.
    13. Edit the component interface to allow full access to all methods in it.
    14. Click Save to save your permission list changes.

      Note: Ensure that the intended user of the portlets participates in at least one role that contains this permission list.

    15. Skip step 8.

    Note: The component interface in the project, WPS_PT842_CILIST, has been created and tested on PeopleTools 8.42 and is in general limited to that version of PeopleTools. If you attempt to import a component interface definition into another version of PeopleTools, you may crash the PeopleSoft Application Designer.

    1. Extract the contents of peoplesoft_home\wps_pt842_cilist.zip to a directory of your choice (referred to as ci_home).
    2. Start the PeopleSoft Application Designer. To ensure that you can perform the steps below, log in to the Application Designer in two-tier mode.
    3. Select File > New to create a new project definition.
    4. Select Tools > Copy Project > From File and specify ci_home\WPS_PT842_CILIST\WPS_PST842_CILIST.ini directory in the filename field. You can enter the filename directly or browse to it.
    5. Verify that WPS_PT842_CILIST is selected in the Projects field.
    6. Click Open.
    7. Click Copy on the Copy from File dialog box.
    8. Select File > Save Project As and enter a project name of your choice.
    9. Click OK.
    10. Exit the PeopleSoft Application Designer.
    11. Log in to the PeopleSoft Web application.
    12. Select PeopleTools > Security > Permissions and Roles > Permission Lists.
    13. Add the imported component interface, WPS_CI_LIST, to a permission list. You can use an existing permission list or create a new one. Select the Component Interface tab on the permission list to display the panel for adding the component interface.
    14. Edit the component interface to allow full access to all methods in it.
    15. Click Save to save your permission list changes.

      Note: Ensure that the intended user of the portlets participates in at least one role that contains this permission list.

WebSphere Portal 5.0.x:

Install the JCA adapter using the following steps:

  1. Extract the contents of the download file to a directory of your choice, referred to as peoplesoft_home.
  2. Create a new empty directory in your hard drive, referred to as peoplesoft_lib_dir.
  3. Copy the following files from the PeopleSoft 8 server to peoplesoft_lib_dir:
  4. Deploy the PeopleSoft 8 JCA adapter in WebSphere Application Server
    1. Ensure that the WebSphere Application Server Administration Server service is running.
    2. Start the WebSphere Application Server Administrator's Console.
    3. Click Resources in the navigation tree.
    4. Click on Resource Adapters
    5. In the console workspace area, click on the Install RAR button.
    6. Specify the path and the file name of the RAR file by doing one of the following:
    7. Select the node where you want to deploy the resource adapter and click Next.
    8. Enter a name for the resource adapter such as PeopleSoft 8 and click OK.
    9. Save the configuration changes.
  5. Define a connection factory for the PeopleSoft JCA adapter.
    1. Click on Resource Adapters in the navigation tree.
    2. Click on the resource adapter you just deployed in Step 4. For example, PeopleSoft 8.
    3. Under Additional Properties, click on J2C Connection Factories, and click New.
    4. Enter the following:
    5. Click OK then click on the connection factory you just created.
    6. Under Additional Properties, click on Custom Properties.
    7. Specify the properties for the PeopleSoft system you want to connect to by selecting the property from the list and entering a value in the entry field:
      hostName
      The host name of the PeopleSoft server to which you want to connect. For example, myserver.mycompany.com. The port number is for the JOLT Listener port. You can obtain the JOLT Listener port number from the PeopleSoft application server configuration file, psappsrv.cfg . An example location for that file is C:\PSFT_HRMS8.3\appserv\HR8DMO\psappsrv.cfg. An example hostName setting is //myserver.mycompany.com:9210. If you do not specify the port number, the default port number of 9000 is used.
      jarPath
      Enter the value peoplesoft_lib_dir, the directory where you placed the PeopleSoft libraries.
    8. Click OK.
  6. Copy server-specific files.
    1. Extract psft8adapter.jar from peoplesoft_home\psft.rar.
    2. Copy this file to the was_root\lib directory, where was_root is the directory where WebSphere Application Server is installed. For example, C:\WebSphere\AppServer.
    3. Restart WebSphere Application Server.
  7. The final step is importing the component interface list retrieval definition into PeopleSoft. There are two versions of the component interface: one for PeopleTools 8.18 and another for PeopleTools 8.42. If you are running PeopleTools 8.42 skip to step 8.
    Note: The component interface in the project, WPS_PS_CILIST, has been created and tested on PeopleTools 8.18, and is in general limited to that version of PeopleTools. If you attempt to import a component interface definition into another version of PeopleTools, you may crash the PeopleSoft Application Designer.
    1. Extract the contents of peoplesoft_home\wps_ps_cilist.zip to a directory of your choice (referred to as ci_home).
    2. Start the PeopleSoft Application Designer. To ensure that you can perform the steps below, log in to the Application Designer in two-tier mode.
    3. Select File > New to create a new project.
    4. Select File > Copy Project from File and specify the CI_home directory in the Import Directory field. You can enter the path directly or click "..." to browse to it.
    5. Verify that WPS_PS_CILIST is selected in the Project Name field.
    6. Click Copy.
    7. Select File > Save Project As, and enter a project name of your choice.
    8. Click OK.
    9. Exit the PeopleSoft Application Designer.
    10. Log into the PeopleSoft Web application.
    11. Select PeopleTools > Maintain Security > Use > Permission Lists .
    12. Add the imported component interface, WPS_CI_LIST, to a permission list. You can use an existing permission list or create a new one. Select the Component Interface tab on the permission list to display the panel for adding the component interface.
    13. Edit the component interface to allow full access to all methods in it.
    14. Click Save to save your permission list changes.

      Note: Ensure that the intended user of the portlets participates in at least one role that contains this permission list.

    15. Skip step 8.

    Note: The component interface in the project, WPS_PT842_CILIST, has been created and tested on PeopleTools 8.42 and is in general limited to that version of PeopleTools. If you attempt to import a component interface definition into another version of PeopleTools, you may crash the PeopleSoft Application Designer.

    1. Extract the contents of peoplesoft_home\wps_pt842_cilist.zip to a directory of your choice (referred to as ci_home).
    2. Start the PeopleSoft Application Designer. To ensure that you can perform the steps below, log in to the Application Designer in two-tier mode.
    3. Select File > New to create a new project definition.
    4. Select Tools > Copy Project > From File and specify ci_home\WPS_PT842_CILIST\WPS_PST842_CILIST.ini directory in the filename field. You can enter the filename directly or browse to it.
    5. Verify that WPS_PT842_CILIST is selected in the Projects field.
    6. Click Open.
    7. Click Copy on the Copy from File dialog box.
    8. Select File > Save Project As and enter a project name of your choice.
    9. Click OK.
    10. Exit the PeopleSoft Application Designer.
    11. Log in to the PeopleSoft Web application.
    12. Select PeopleTools > Security > Permissions and Roles > Permission Lists.
    13. Add the imported component interface, WPS_CI_LIST, to a permission list. You can use an existing permission list or create a new one. Select the Component Interface tab on the permission list to display the panel for adding the component interface.
    14. Edit the component interface to allow full access to all methods in it.
    15. Click Save to save your permission list changes.

      Note: Ensure that the intended user of the portlets participates in at least one role that contains this permission list.

Configure for Siebel

WebSphere Portal 4.x:

If you have a previous version of Application Builder installed, you must first ensure that you have the current JCA adapter. To determine if the JCA adapter is out-of-date, open ra.xml in <was_root>\installedConnectors\siebel.rar\META-INF\. The current version number is 1.1. There should be four configuration properties: connectString, jarPath, traceLevel, and language. If any of these properties are missing, you must remove the JCA adapter and install the new version.

Use the following steps to remove the Siebel JCA adapter:

  1. Open the WebSphere Application Server Administrative Console.
  2. Remove any existing connection factories under the Siebel adapters.
  3. Remove the Siebel adapter.
  4. Close the Administrative Console.
  5. Stop the Application Server.
  6. Remove the following files from was_root\lib\app:
  7. Remove the siebeladapter.jar from was_root\lib\app\.
  8. Start the Application Server.

Install the JCA adapter siebel.rar using the following steps:

  1. Extract the contents of the download file (1wp10003t.zip) to a directory of your choice, referred to as siebel_home.
  2. Create a new empty directory in your hard drive, referred to as siebel_lib_dir.
  3. Copy the following files from the Siebel server to siebel_lib_dir:
  4. Deploy the Siebel JCA adapter in WebSphere Application Server
    1. Ensure that the WebSphere Application Server Administration Server service is running.
    2. Start the WebSphere Application Server Administrator's Console.
    3. Double-click WebSphere Administrative Domain in the tree view.
    4. Double-click Resources in the tree view.
    5. Right-click on J2C Resource Adapters, and select New.
    6. On the General tab of the J2C Resource Adapters Properties window, enter the following:
    7. In the Archive file name field, click the button labeled "..." to display the Install Driver window.
    8. Select the node where you want to deploy the resource adapter and specify the path and file name of the RAR file by doing one of the following:
    9. Click Install. The J2C Resource Adapters Properties window is updated to display the name of the RAR file you specified.
    10. Click OK to install the resource adapter. A confirmation message is displayed when the resource adapter is installed.
    11. Click OK to dismiss the message. The Administrator's Console is updated to display information about the resource adapter.
  5. For each Siebel application, define a connection factory for the Siebel JCA adapter.
    1. Double-click on J2C Resource Adapters in the tree view.
    2. Double-click on the resource adapter you just deployed. For example, Siebel.
    3. Right-click on J2C Connection Factories, and select New.
    4. On the General tab of the J2C Connection Factories Properties window, enter the following:
    5. Click the Connections tab.
    6. Specify the properties for the Siebel system you want to connect to by selecting the property from the list and entering a value in the entry field:
      connectString
      The connection string used to contact the Siebel server.

      The general format for this value is siebel://[machine name]/[enterprise name]/[object manager]/[servername]. The [object manager] value in the connection string should correspond to that specified in the JNDI binding path. For example, if you are defining a connection factory with a JNDI binding path of eis/siebel/ERMObjMgr, you would specify a connection string like siebel://machine1.mycompany.com/siebel/ERMObjMgr/server1. For details on the connection string format, refer to the Siebel documentation.

      jarPath
      Enter the value siebel_lib_dir, the directory where you placed the Siebel libraries.
    7. Click OK.
    8. Repeat the steps to create a connection factory for the remaining Siebel applications.
  6. Copy server-specific files.
    1. Extract the siebeladapter.jar file from the siebel_home\siebel.rar file, and copy it to the was_root\lib directory.
    2. Restart WebSphere Application Server.

WebSphere Portal 5.0.x:

If you have a previous version of Application Builder installed, you must first ensure that you have the current JCA adapter. To determine if the JCA adapter is out-of-date, open ra.xml in <was_root>\installedConnectors\siebel.rar\META-INF\. The current version number is 1.1. There should be four configuration properties: connectString, jarPath, traceLevel, and language. If any of these properties are missing, you must remove the JCA adapter and install the new version.

Use the following steps to remove the Siebel JCA adapter:

  1. Log in to the administrative console using a Web browser.
  2. Remove any existing connection factories under the Siebel adapters.
  3. Remove the Siebel adapter.
  4. Stop the Application Server.
  5. Remove the following files from was_root\lib\app:
  6. Remove the siebeladapter.jar from was_root\lib\app\.
  7. Start the Application Server.

Install the JCA adapter siebel.rar using the following steps:

  1. Extract the contents of the download file (1wp10003t.zip) to a directory of your choice, referred to as siebel_home.
  2. Create a new empty directory in your hard drive, referred to as siebel_lib_dir.
  3. Copy the following files from the Siebel server to siebel_lib_dir:
  4. Deploy the Siebel JCA adapter in WebSphere Application Server
    1. Verify that the application server for the administrative console is running.
    2. Point a Web browser to the URL for the administrative console and log in.
    3. Browse the administrative console using the navigation tree. Expand the Resources tab in the navigation tree and click on Resource Adapters.
    4. In the console workspace area, click on Install RAR.
    5. Specify the path and file name of the RAR file by doing one of the following:
    6. Select the node on which to install the RAR file and click Next.
    7. Enter a name for the resource adapter, such as Siebel. Click OK.
    8. Save the configuration changes.
  5. For each Siebel application, define a connection factory for the Siebel JCA adapter.
    1. Click on Resource Adapters in the navigation tree.
    2. Click on the resource adapter you deployed in step 4. (For example: Siebel.)
    3. Under Additional Properties, click on J2C Connection Factories.
    4. Click New.
    5. Enter the following:

Configure for SAP

  1. Download SAP's JCO adapter directory from SAP at http://service.sap.com.
  2. Click Download Software > Download > SAP Connectors > SAP Java Connector. Select the appropriate file to download based on your operating system and version of WebSphere Portal. Extract the contents of the ZIP file into a local directory.
  3. Complete the following steps according to your operating system and WebSphere Portal version.

    Note: was_root refers to the directory in which WebSphere Application Server is installed; for example, C:\WebSphere\AppServer. In addition, wps_root refers to the directory in which WebSphere Portal is installed; for example, C:\WebSphere\PortalServer.

WebSphere Portal 4.x:

WebSphere Portal 5.0.x:

4. Log in to WebSphere Portal as an administrative user to add the Application Builder to a page.

5. Click the Configure icon to modify the following configuration parameters:

ParameterValue
HostnameEnter the SAP server hostname.
Client numberEnter the SAP client number.
System NumberEnter the SAP system number.
LanguageEnter the two letter country code. For example, EN for English.
Connections per user poolEnter the maximum number of connections to use for connection pooling purposes.

Configure for SAP Business Object Editor

Note: Prior to installing the SAP Business Object Editor, you must install SAP's JCO adapter. Follow the first four steps in Configure for SAP under the section that is applicable to your version of WebSphere Portal. Install one of the following war files based upon your WebSphere Portal installation:

When you initially start the editor you will be prompted to enter the following configuration information:

ParameterValue
HostnameEnter the SAP server hostname.
Client numberEnter the SAP client number.
System NumberEnter the SAP system number.
LanguageEnter the two letter country code. For example, EN for English.
Slot nameEnter the name of a credential vault slot you have created.

Configure the JDBC adapter

WebSphere Portal 4.x:

Three fields are needed for input:

JNDI name
This is the same name displayed when creating a database data source using the WebSphere Administration Console.
User ID
This is the database user ID. It will be saved in the credential vault.
Password
This is the database password. It will be saved in the credential vault.

Configure a WebSphere Data Source

  1. Launch the WebSphere Administration Console.
  2. In the left hand panel, expand the Domain tree, and then the Resources tree.
  3. Select JDBC Providers.
  4. In the right panel, click Help. You will see Help Page 6.6.14.0: Properties of JDBC and data source providers.
  5. Follow the instructions for creating a JDBC Provider if you do not wish to use an existing one.
  6. Follow the instructions to create a database data source. The JDBC portlet builder will need the JNDI name listed by WebSphere for the database data source.

Configure a JDBC Business Object

The following parameters exist on the JDBC Business Object configuration page:

ParameterValue
Schema drop down listThis list contains schemas available through the JDBC connection.
Table list search string

This search string is used when tables are retrieved for a schema. The value can be any legal SQL search string syntax.

For example, enter % to get all tables, or use an _ (underscore) to match on a single character.

Table listResults of search.
  1. Set the Table list search string. This step is especially important if the schema contains a large number of tables. Otherwise, the default setting is Get all tables.
  2. Select the schema from the drop down list.
  3. Click Get tables. The search results will be displayed.
  4. Select a table in order to make it available to the portlet builder.

Note: There are two ways to refresh the table list:

  1. Use Get tables.
  2. Select a new schema.

When using a connection to an Oracle database, an additional configuration step is needed. You must update the Portal JVM properties:

  1. Launch the WebSphere Administration Server Console.
  2. In the left pane, expand the tree to the Application Servers, and select WebSphere Portal.
  3. In the right pane, select JVM settings.
  4. Add a classpath entry for Oracle classes12.zip.
  5. Click Apply.
  6. Stop and restart WebSphere Portal. This step is necessary to enable JDBC and connection pool implementation classes for Oracle.

Notes:

  1. This portlet uses the WebSphere JDBC data source so it can take advantage of connection pooling. You must consider how many portlets you run versus the size of your connection pool, since each portlet uses a connection. The connection is used and then released. If you run a large number of these portlets, you may need to increase the size of your connection pool.
  2. The JDBC portlet will not allow you to update or delete records for tables that do not have primary keys. When you attempt to delete or update records for a table that does not have primary keys, you see the following message: Fatal error occurred in BusinessObject Framework. Please see log for details.

    In the log you will see one of the following messages along with a stack trace:

  3. The JDBC Portlet Builder only supports DB/2 and Oracle databases as identified in the following table:

    Portal VersionPlatformsSupported Databases
    4.1
    4.2


WebSphere Portal 5.0.x:

Websphere Application Server Configuration for a Database Provider

  1. Start the Administrator's Console.
  2. In the left hand panel expand Resources.
  3. Select JDBC Providers.
  4. In the right hand panel specify the cell or node scope by browsing or entering it in the input field.Click Apply.
  5. Click New to create a JDBC Provider
  6. Using the drop down list, select the appropriate provider and click on the Apply button. Use the appropriate configuration information listed below for your provider:
  7. Save your changes to the Master Configuration.

Websphere Application Server Configuration for a Data Source

  1. Start the Administrator's Console.
  2. In the left hand panel expand Resources.
  3. Select JDBC Providers.
  4. In the right hand panel specify the cell or node scope by browsing or entering it in the input field.Click Apply.
  5. Select the appropriate JDBC provider.
  6. Select Data Sources in the Additional Properties table for the provider.
  7. Click on the New button to create a Data Source.
  8. Enter a value for the property Name.
  9. Enter a value for property JNDI Name.
  10. Click Apply.
  11. Use the following to configure the appropriate provider:

Notes:

  1. After creating the appropriate provider and data source, it will be necessary to stop and restart both the WebSphere application server and the WebSphere_Portal application server.
  2. For remote DB2 databases, the database connection needs to be set up using the DB2 Client Configuration Assistant. The database alias name entered here is the database name used for the data source. Note that "Test Connection" may fail because there is no awareness of the remote user ID and password. This authentication is handled when configuring the portlet and portlet builder.
  3. For Cloudscape, only one open conncetion is permitted on a database at a time. If you successfully test the connection using the test connection button on the Cloudscape data source, you may need to restart the server.
  4. If you are using Cloudscape viewer and you upgrade you may no longer be permited to view this database. This is because the viewer tool says the tool needs an upgrade to view the upgraded database.
  5. This portlet uses the WebSphere JDBC data source so it can take advantage of connection pooling. You must consider how many portlets you run versus the size of your connection pool, since each portlet uses a connection. The connection is used and then released. If you run a large number of these portlets, you may need to increase the size of your connection pool.
  6. The JDBC portlet will not allow you to update or delete records for tables that do not have primary keys. When you attempt to delete or update records for a table that does not have primary keys, you see the following message: Fatal error occured in BusinessObject Framework. Please see log for details.

    In the log you will see one of the following messages along with a stack trace:

  7. The JDBC Portlet Builder only supports DB/2, Oracle, and Cloudscape databases. The following table identifies the supported versions of DB2 and Oracle:

    Portal VersionPlatformsSupported Databases
    5


Configure for Domino

  1. Make sure there is a Domino server available and note the port number where the Domino server is running.
  2. In the Domino server document > Internet Protocols > HTTP, set Allow HTTP clients to browse databases to "Yes."
  3. Start Domino server.
  4. Type "load http" in the Domino server console window. Wait until this loads.
  5. Type "load diiop".
  6. Install WebSphere Portal.
    Note: If Domino server and WebSphere Portal are installed on the same machine, change the Domino server's http port number so it does not conflict with the http server in WebSphere Portal. Remember this port number.
  7. Install Click-to-Action if it is not installed with WebSphere Portal.
  8. Install the WebSphere Struts framework if it is not installed with WebSphere Portal.
  9. Install WPAIPortletBuilders.war and WPAIDominoTemplate.war.
  10. Create a page on the portal.
  11. Add the Portlet Builder for Domino portlet to the newly created page.
  12. Log out of WebSphere Portal and log back in.
  13. Switch the browser to the newly created page. If all the steps are successful, you will be able to create a new portlet using this page.
ParameterValue
Domino Server NameName of the Domino Server you are using.
Domino Database NameName of the Domino Database you are using.
Domino User IDUser ID
PasswordPassword

The version of Transcoding Technology that WebSphere Portal 4.1.2 uses causes a conflict with the J2C resource adapter in WebSphere Application Server. To use the adapters, you can resolve the conflict by doing one of the following two actions:

Configure for WebSphere Portal content publishing

The WebSphere Portal content publishing Runtime server and the Application Portlet Builder must be installed on the same WebSphere Portal. The builder obtains metadata from content resources that have been published to the WebSphere Portal content publishing Runtime server.

Portlet installation

Once you have completed the configuration steps, deploy the Application Portlet Builder in your portal environment using the following files from the extracted contents of the download file:

See the WebSphere Portal documentation for portlet installation instructions.

Configuration parameters

There are no configuration parameters for this portlet.

WPAI Profile Service

Large enterprise applications such as SAP have certain pieces of information which are frequently needed by users when querying information. The WPAI Profile Service expands upon the already existing user profile provided by WPAI (first name, last name, etc.) by allowing application-specific attributes which are frequently used during queries to be retrieved and cached on a per user basis. These attributes are retrieved "on demand" by the profile service and cached until the user logs out. In addition, since the profile service is actually a portlet service, these cached attributes are available to all WPAI portlets which are accessing the same account on an application.

WebSphere Portal 4.x:

Installing the WPAI Profile Service

Unzip the install file and perform the following steps to install and configure the profile service:

  1. Copy the files WEB-INF/lib/wpai_profile_service.jar and /WEB-INF/lib/boframework.jar to the <WAS_HOME>/lib/app directory.
  2. Copy the wpai_profile_service directory to <WAS_HOME>/lib/app
  3. Add the following three lines to the file <WAS_HOME>/lib/app/config/services/PortletServiceRegistryService.properties exactly as they appear below:

    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileService=
      com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl
    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl.factory=
      org.apache.jetspeed.portletcontainer.service.PortletServiceCacheFactory
    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl.BASE_CONFIG=
      wpai_profile_service.base_config
    
  4. Restart the WebSphere Application Server.

Configuring the WPAI Profile Service for Use with SAP

  1. Copy the sap_config folder to <WAS_HOME>/lib/app.
  2. Restart the WebSphere Application Server.

Setting up Logging for the Profile Service

  1. Add the following two lines to the file <WAS_HOME>/lib/app/config/services/LogService.properties exactly as they appear below.
  2. Add the following three lines to the file <WAS_HOME>/lib/app/config/jlog.properties exactly as they appear below.

    baseGroup.WPAIProfileServiceTraceLogger.parent=TraceLogger
    baseGroup.WPAIProfileServiceTraceLogger.isLogging=true
    

    #comment second out the line above this one to turn off logging for the WPAI Profile Service

    Note: To turn logging off, simply comment out the following statement from the file <WAS_HOME>/lib/app/config/jlog.properties by placing a number sign (#) at the front of the line.

  3. Restart the WebSphere Application Server.

WebSphere Portal 5.0.x:

Installing the WPAI Profile Service

Unzip the install file and perform the following steps to install and configure the profile service:

  1. Copy the files WEB-INF/lib/wpai_profile_service.jar and /WEB-INF/lib/boframework.jar to the <WPS_HOME>/shared/app directory.
  2. Add the JAR files to the application server's WPSLib shared library. You can edit WPSLib in the Administrative Console by selecting Environment > Shared Libraries > WPSLib.
  3. Copy the wpai_profile_service directory to <WPS_HOME>/shared/app.
  4. Add the following three lines to the file <WPS_HOME>/shared/app/config/services/PortletServiceRegistryService.properties exactly as they appear below:

    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileService=
      com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl
    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl.factory=
      com.ibm.wps.pe.pc.legacy.service.PortletServiceCacheFactory
    com.ibm.wps.portlets.wpai.profileservice.WPAIProfileServiceImpl.BASE_CONFIG=
      wpai_profile_service.base_config
    
  5. Restart the WebSphere Portal.

Configuring the WPAI Profile Service for Use with SAP

  1. Copy the sap_config folder to <WPS_HOME>/shared/app.
  2. Restart the WebSphere Portal.
  3. Enable logging for the com.ibm.wps.portlets.businessobject package

Additional references

Additional documentation is included in the download file, 1wp10003t.zip. When you unzip 1wp10003t.zip, you will find the following references in the doc subdirectory:

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help