Appliance installation and configuration for Analytics Platform System

Walks Analytics Platform System (APS) appliance administrators through the initial steps to set up and get started using your new appliance.

1. Install the Hardware

Your new appliance will be delivered on pallets to the dock at your data center.


In some cases, your IHV will unpack, rack, and connect the appliance for you in your data center. If so, these instructions are not necessary and you can skip to the 3. Configure the Appliance section below.

If your IHV is not performing the hardware install, use the following steps to install the hardware.

Task Description
Confirm documentation Confirm that you have received all necessary documents and information from your independent hardware vendor (IHV). See Information to Obtain from Your IHV (Analytics Platform System).
Install hardware Verify the data center can accommodate the appliance. Move the appliance components to the data center. Rack the network switches, PDUs, and cabling. See Hardware Installation (Analytics Platform System).

2. Power On the Appliance

Task Description
Power on the appliance Power on each appliance component node in the required order, waiting as necessary to confirm that no errors are encountered.

3. Configure the Appliance

Task Description
Configure the appliance by using the SQL Server PDWConfiguration Manager Use the Configuration Manager to set appliance passwords, time zones, network and firewall settings, security certificates, and performance and other settings on your appliance. See Appliance Configuration (Analytics Platform System).


Configuration changes should only be made using the SQL Server PDWConfiguration Manager. Changes not exposed through Configuration Manager are not supported. For example, the SQL Server PDW appliance only supports the US-English language setting.

4. Set Up Software Servicing

Task Description
Apply SQL Server PDW updates (Optional) You may need to apply one or more SQL Server PDW updates to update your SQL Server PDW software to the latest version. See Apply Analytics Platform System Hotfixes (Analytics Platform System).
Configure Windows Server Update Services Configure the appliance to receive updates from Windows Server Update Services for supporting software. See Download and Apply Microsoft Updates (Analytics Platform System).

Next Steps

After you have completed all of the preceding steps, your appliance is ready for use. You or other personnel at your location can proceed with the following tasks.

Task Description
Install SQL Server PDW drivers and configure connectivity Configure local computers to connect to SQL Server PDW by using SQL Server Data Tools, sqlcmd, business intelligence software, or other tools.
Create logons and server roles, and assign permissions Plan and create logons and server roles that will allow users to log on to SQL Server PDW with the appropriate permissions.
Configure the Azure Data Management Gateway The Gateway enables Azure users to access on-premises APS data by exposing APS data as secure OData feeds. The Gateway is installed on the Control node already. Ask Microsoft for assistance with configuration.
Monitor queries and appliance users Use the Admin Console and other resources to monitor the queries and appliance users. See Monitor the Appliance by Using the Admin Console (Analytics Platform System).
Load data to SQL Server PDW Load data to your appliance.
Create a disaster recovery plan Plan how you will protect your data from hardware failures or data overwrites. Create a plan using regular backups and restore plans in case of data corruption or loss.
Monitor the appliance Monitor the appliance state, health, and performance by using system views, logs, and the Admin Console. Correct or report any problems. See Monitor Appliance Health State (Analytics Platform System).