Microsoft® SQL Server™ provides several tools for building data warehouses and data marts, and OLAP systems. Using DTS Designer, you can define the steps, workflow, and transformations necessary to build a data warehouse from a variety of data sources. After the data warehouse is built, you can use Microsoft SQL Server OLAP Services, which provides a robust OLAP server that can be used to analyze data stored in many different formats, including SQL Server and Oracle databases.
Data Transformation Services Data Warehousing Support | Server Improvements and New Features |
Installing OLAP Services | OLAP Services Data Warehousing Support |
Overview of Data Transformation Services |