1 Introduction
The Parallel Data Warehouse Data Portability Overview document provides an overview of the components and methodologies that are used for data portability within the SQL Server Parallel Data Warehouse (PDW) system.
This document provides examples of some of the common user scenarios for data export. It does not restate the details of formats that are used for data portability. These details are described in the specifications for each of the formats that are used by this system.
This document provides an overview of data portability between a Microsoft SQL Server 2008 R2 Parallel Data Warehouse (PDW) database and another vendor’s database. The document focuses on exporting data from SQL Server PDW to a SQL Server 2008 R2 database. The BCP data portability document [MS-DPBCP] focuses on portability between a SQL Server 2008 R2 database and another vendor’s database.
SQL Server PDW is a highly scalable appliance for enterprise data warehousing that uses massively parallel processing (MPP) to deliver high performance and scalability on Microsoft SQL Server 2008, the Windows Server 2008 operating system, and industry-standard hardware. The appliance ships with software, hardware, and networking components that are architected together to provide high-speed parallel query processing, highly scalable data storage, and high-speed data transfer among the appliance components.
SQL Server PDW consists of a set of nodes. Each node has specific hardware and software that are architected together to carry out the functions of that node. Data is usually loaded through the node called the Landing Zone. Data is stored on a set of 8 to 10 or more Compute nodes. Queries run in parallel on the Compute nodes. The results are finalized on the Control node, and then returned to the user.
Figure 1: SQL Server PDW appliance nodes
The data export scenario in this document describes how to use SQL Server Integration Services to use the SQL Server PDW parallel data export feature to export data to a SQL Server 2008 R2 database.
Figure 2: Conceptual overview of SQL Server PDW export data portability