The purpose of this article is to describe the steps involve to configure
Datapower service for the Database communication. The service will parse the
incoming parameters from the request, construct a SQL query string and
returns the data from the Database, based on the constructed query.
For the demonstration, the following table "DataPowerTest" is created in MS
SQL Server. The following columns and data were added as well.
1. In the Datapower, create SQL Data Source with the following values
Microsoft SQL Server
Connection User Name
Data Source ID
Data Source Host
Data Source Port
2. Create the GallagherDirectoryQuery.xslt file and type the following.
Upload the file... (more)
This article provides a list of general best practices to apply to any
WebSphere Application Server V7 and V8 environment. However, some of the
recommendations only apply to specific conditions and scenarios. These
recommendations could be used to set up any WebSphere environment.
General Best Practices for WebSphere Application Environments
1. All WebSphere Application processes should be running as non-admin/root
It's not a good practice to run a process as an admin/root user. For obvious
reasons, you don't want more folks to know about the admin/root password and
All services running inside the Datapower need to be installed on the
appliance IP address and on the port. As the number of services increase on
the appliance, it does create complexity and following underline issues to
Exposure of internal ports (and IP address in some cases) to outside their
hosting network. Firewall configuration to allow traffic on different ports
(and IP addresses) of Datapower Maintaining IP addresses and ports as the
number of services increases on the appliance
There may be other solutions to handle the above mentioned issues but one of ... (more)
This article demonstrates the steps performed to implement JSR 168 compliant
cooperative portlets using IBM Rational Application Developer V6.0 and
WebSphere Portal Server V5.1. The article illustrates passing multiple values
from source portlet to target portlet without defining complex data type
inside WSDL file.
The term cooperative portlets refers to the capability of portlets on a page
to interact with each other by sharing information. One or more cooperative
portlets on a portal page can automatically react to changes from a source
portlet triggered by an action or event ... (more)
This article offers guidance to migrating existing servlet Struts-based
applications to portlet Struts-based applications - with a minimum of steps -
using WebSphere Studio Application Developer v5.0 with the WebSphere Portal
v5.0 test environment.
This article does not cover expanding the functionality of the Web
application (e.g., using portlet communication), nor is it an introduction to
Struts, WebSphere Portal, or portlet programming. The purpose of this article
is to enable you - with the fewest changes possible - to run a servlet-Struts
application as a portlet-Struts app... (more)