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)
The Datapower appliances support the use of the FTP protocols for message
transport. The purpose of this article is to present number of common use
case scenarios for FTP polling, illustrating correct configurations of the
device to support the use case.
The use case scenarios are as follows:
1- FTP Poller - polling files in one directory and transfer them to another
2- FTP Poller – polling files from FTP SERVER and forward them to another
3- FTP Poller (sFTP – FTP over SSL) - polling files from FTP SERVER and
forward them to another service
4- FTP Poller (sF... (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
The purpose of this article is to describe the steps involved in configuring
Datapower services for the browser-based HTTP type requests. The commonly
used methods for such requests are either the POST or GET HTTP method.
1. For the testing purpose create a loopback pass-through XML Firewall.
2. Create a new Multi-Protocol Gateway with the following values
3. Create a HTTP Front side handler with the followin... (more)
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)