SQL Case Study: Reducing the Costs of Enterprise Data Warehouse Creation and Data Acquisition

Microsoft IT Showcase is pleased to announce the publication of Reducing the Costs of Enterprise Data Warehouse Creation and Data Acquisition, which discusses how Microsoft IT is improving its data warehouse management efficiencies.

Metadata Driven Extract Transform and Load (METaL) was developed by Microsoft IT to enable the rapid configuration, deployment, and operation of data warehouse applications utilizing evolving Microsoft warehouse technologies such as SQL Server 2008 and SSIS. METaL provides an extensible platform to manage an enterprise warehouse environment. The application enforces enterprise standards, improves developer productivity, reduces the amount of repetitive coding required to implement standard ETL Patterns. Business Case Study