Client:
§
World’s most
complete, open, and integrated business software and hardware systems, with
more than 370,000 customers in more than 145 countries across the globe.
§
Oracle Innovations
Behind Cloud Computing.
§
Oracle aims to become
#1 in middleware and #1 in applications, just as they are in database
Business
Need:
§
To reduce demand
latency.
§
To improve the
consistency and accuracy of external demand data to more effectively leverage
demand data across functions, teams and applications.
§
Ad hoc queries and
analysis capabilities for users to create their own reports and dashboards.
§
Handling of huge
amount of volume
Solution:
We used the
following:
§
To capture data - Oracle Warehouse Builder.
§
To manage data -
Oracle Database 10g.
§
To analyze and
integrate data - Oracle Business Intelligence Enterprise Edition (OBIEE) &
BPEL.
§
To connect with
applications via standards-based integration
- Oracle Internet Application Server , Oracle SOA Suite.
§
Dedicated application
to capture and manage large volume of external data.
§
Scalable, extensible
data model based on the Oracle Data Warehouse for Retail data model.
§
Data captured, stored
and analyzed at the day/SKU/store level.
§
Pre-built category management, score carding dashboards and
reporting templates.
§
Proactive detection
and alerts based on user define goals and thresholds.
§
Prebuilt integration
of cleansed, harmonized data to Oracle
Demantra
Benefits:
§
Demand started being
fulfilled very quickly.
§
Better reporting
tools were developed helping in strategizing business.
Technology Platform:
§
Oracle Warehouse
Builder.
§
Oracle Internet
Application Server , Oracle SOA Suite.
§
Oracle Demantra