Here's a customer success story about using Warehouse Builder for near-real-time data warehousing.
As the industry's first "by-invitation-only" consumer opinion panel,
eRewards uses Oracle Database 10g to power its program which rewards
members for the time they spend answering online surveys that have been
selected to match their interests, demographics, and life
circumstances. Through this program, members earn e-Rewards currency,
which can be redeemed for a variety of rewards including dining,
entertainment, travel and retail rewards. To process its influx of
data, eRewards depends on Oracle Database 10g, Oracle Real Application
Clusters, Oracle Automatic Storage Management, Oracle Data Guard and
Oracle Warehouse Builder 10g.
At the heart of eRewards' Web site is a powerful OLTP system
supported by Oracle Database 10g and Oracle Real Application Clusters
for online interaction with eRewards members. Complementing eRewards'
OLTP systems is a multi-terabyte data warehouse also running on Oracle
Database and Oracle Real Application Clusters. eRewards uses the
flexibility of Oracle Data Guard, traditionally a disaster recovery
feature, to keep its data warehouse up-to-date with the latest
information captured by the OLTP system. The data warehouse is used to
manage survey panels and provide valuable real-time analysis and
reporting captured from member response data. Additionally, eRewards
uses Oracle Warehouse Builder 10g to design, build and populate its
data warehouse and business intelligence systems.
"We evaluated competitive offerings and nothing could match the
combination of functionality, performance, manageability and the cost
structure offered by Oracle," said Joel Davis, Senior Vice President of
Technology, eRewards. "Near real-time synchronization of our data
warehouse with our OLTP system enables eRewards to more effectively
scale our environment to meet the needs of members, clients, and