| title | ms.custom | ms.date | ms.reviewer | ms.suite | ms.tgt_pltfrm | ms.topic | ms.assetid | caps.latest.revision | author |
|---|---|---|---|---|---|---|---|---|---|
Configure SQL Server PDW for Remote Table Copies (SQL Server PDW) |
na |
01/13/2017 |
na |
na |
na |
article |
496b4214-5891-404c-8237-c2a1e09db6d5 |
11 |
BarbKess |
Describes how to configure SQL Server PDW to use the remote table copy feature to copy tables to SMP SQL Server databases on non-appliance servers.
This topic describes one of the configuration steps for configuring remote table copy. For a list of all the configuration steps, see Remote Table Copy.
In order to configure SQL Server PDW to use remote table copy, you must:
-
Have a Analytics Platform System administrator account with the ability to log directly into the appliance_domain-AD01 and appliance_domain-AD02 nodes.
-
Know the host name or IP name of the destination server.
The CREATE REMOTE TABLE statement, used for remote table copies, specifies the destination server by using either the IP address or the IP name of the SMP Windows system. To use the IP name, you need to add entries for successful name resolution to the DNS server.
The following steps outline how to update the DNS server.
-
Log on to the active AD node (normally appliance_domain-AD01).
-
Open the DNS Manager. This is located under Administrative Tools in the Start menu.
-
Use the DNS Manager to add the IP name.