SQL Server Tools for Data Warehousing and OLAP

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.

See Also
Data Transformation Services Data Warehousing Support Server Improvements and New Features
Installing OLAP Services OLAP Services Data Warehousing Support
Overview of Data Transformation Services  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.