Specifications

Parallel Data Warehouse Architecture CHAPTER 6 113
Development Studio, SQL Server Integration Services, SQL Server Analysis Services, and SQL
Server Reporting Services. The Nexus client is the query editor that you can use to submit
queries by using SQL statements to Parallel Data Warehouse. Parallel Data Warehouse also
includes DWSQL, a command-line tool for submitting SQL statements to the control node.
These client tools use Data Direct’s SequeLink client drivers that support the following data
access driver types:
■
ODBC
■
OLE DB
■
ADO.NET
SQL Server
SMP SQL database
Appliance nodes
Client access tools
SQL
Server BI
(AS, RS, IS)
Data rack
Compute
DMS
SQL Server
User data
Control rack
Management
Backup
DMS
Landing Zone
Landing tool
DMS
Control
IIS
Admin
Console
Data
Movement
Service
(DMS)
MPP Engine
SQL Server
Control
database
OLEDB
ODBC
ADO.NET
NEXUS
query
editor
DWSQL
FIGURE 6-2 Appliance software