Using Oracle Warehouse Builder with Exadata: Success Story at Allegro Group
By antonio romero on Jun 09, 2009
Oracle Magazine’s feature story, “Lead with Intelligence”, documents the successful experience of Oracle Exadata at Allegra Group, the largest e-commerce company in Eastern Europe. Warehouse Builder was selected as the ETL tool for this multi-terabyte warehouse project on Oracle’s most advanced data warehouse architecture delivering extreme data warehouse performance.
The HP Oracle Database Machine, announced at Oracle OpenWorld in September 2008, is a grid of eight database servers with 64 Intel processor cores running Oracle Database 11g and Oracle Real Application Clusters on Oracle Enterprise Linux. This data warehouse solution also includes a storage grid of 14 HP Oracle Exadata Storage Servers with 112 processor cores that’s connected to database servers over InfiniBand. …
In December 2008, Allegro Group deployed the HP Oracle Database Machine and began generating operational and statistical reports using Oracle Business Intelligence Suite, Enterprise Edition Plus. Allegro Group also created an interface to its existing systems using Oracle Warehouse Builder, a core component of Oracle Database 11g. Each day, Oracle Warehouse Builder automatically loads production data into Allegro Group’s Oracle data warehouse, which already holds more than 7TB of data on the HP Oracle Database Machine.
More at Oracle Magazine.