Data warehouse automation (DWA) tools eliminate the manual effort required to design, deploy and operate a data warehouse. By providing an integrated development environment, DWA tools enable developers and business users to collaborate around designs and iteratively create data warehouses and data marts. This turns data warehouse development form a laborious, time consuming exercise into an agile one.