Loading Data to a Data Server

About Adding a Table to a Co-located Data Provider

SAS LASR Analytic Server can load data from Greenplum or Teradata that is co-located on the machines in the cluster. Before loading the data, you must add the data to the data server.

When the co-located data provider is Greenplum or Teradata, the following options are available in the Add Table window. This window is launched by selecting the Add to a Data Server option for a table within the folder tree in the navigation pane:

Fields in the Add to a Data Server Dialog Boxes
Field	Description
Source Table
Name	Specifies the filename of the source table in the metadata.
Library	Specifies the library in the metadata with which the source table is associated.
LASR Table
Name	Enter the filename of the target or output table that should be loaded to Greenplum or Teradata.
Description	This field is optional. Enter a description of the target table. This description is displayed along with the other information for the target table on the LASR Tables tab. It is also displayed in SAS Visual Analytics applications when users launch the Open Data Source window. This window is displayed with a list of data sources that includes this table, and the description provided for this table.
Location	Click Browse and navigate in the folder tree to select the folder where the target table should be placed in HDFS.
Library	Click Browse and select the library that should be associated with the target table. If this is the first time you are loading this table, you can select the same library that is associated with the source table.

Add a Table to a Data Server

To load a table to a data server (co-located data provider) from the Folders navigation pane:

On the LASR Tables tab, expand the Folders navigation pane.
If you know the name of the table, click to display the Search: Folders window and enter the name of the table. If you do not know the table name, navigate the folder path to find the table.
Select the table, and click .
In the Add to a Data Server window, specify the target table name in the Name field below LASR Table. The description is optional.

Note that this description is displayed next to this LASR table when users select a data source in the Open Data Source window within SAS Visual Analytics applications. When you add a description, it provides additional information to the users about this data source.
Click Browse for the Location field, and select the folder where you want the output table to be located.
Click Browse for the Library field, navigate the folder path to find the SAS LASR Analytic Server library, and select the library that should be applied to this table.
Click Submit.