History
The
client, a retail clothing giant, was facing difficulty in
coordinating their day to day operation,
customer and rewards lookup from their POS
system and various reporting needs. This is due to the fact that
the Data Warehouse running Oracle database and
Universe database was working in a batch mode and no integration
across its diverse portfolio of data.
Typically, all the POS data was collected
overnight and applied to the data warehouse in
a nightly batch mode.
Requirement
The
retail company embarked on integrating this
task in real-time and chose IBM InfoSphere
Information Server DataStage and Information
Services Director to perform real-time
integration web service.
Vision
The
clothing giant undertook the process of
upgrading their current POS and data warehouse
On-Line Customer environment with real-time
integration so that the POS system are made
available with immediate response from their
backend data warehouse system with real-time
updates.
Customer
& IBM approach AVS Systems
The
Customer and IBM approached us for help in
providing end-to-end installation and
implementation service.
AVS
Systems provided assessment, advise, planning
and was involved in the complete software
development life cycle (SDLC) implementation.
Technology
Used:
The
architecture uses 3-tier topology where IBM
Information Server DataStage and Information
Services Director (ISD) was installed on
one System-x machine and the WebShere
Application Server WAS-64 bit and the IBM DB2
database as Metadata Repository was
installed on another System-x machine
and the Client portions of the IBM Information
Server was installed on the Windows XP
desktops and laptops.
IBM
InfoSphere Information Server DataStage and
Information Services Director (ISD) was
installed and configured on System-x
platform having Red Hat Linux 5.4 operating
system and the jobs that was developed
using Datastage was exposed as Web Services
using IBM Information Services Director (ISD)
and deployed as an always-on service
and secured in a SSL environment using IBM
Data Power environment.
Key
Business Benefits
 |
Access
to Customer Info in real-time |
|
Ability
to update and renew changes to Customer
Gift Cards and Rewards |
|
Improved
data quality control, timeliness, data
coverage, data standards, business rules,
and optimal resource management |
|
Increase
satisfaction - provide data access view to
users and quicker response times for
requests. Also increased understanding of
data across the enterprise |
|
Cost
reduction through elimination of duplicate
data collection and maintenance efforts |
|
Improved
operational efficiency by eliminating
redundant data management infrastructures,
improving processes, and minimizing
exception handling in downstream
operations caused by operational
inaccuracies |
|
Oversight
and coordination |
