Loading Data to a Co-Located Provider

About Distributing Data to a Co-Located Provider

An important feature of SAS Visual Analytics Administrator is the ability to distribute data to a co-located data provider. There are two ways to distribute data to a co-located data provider.

From the Folders navigation pane, navigate the folder path, and select the table that you want to load. Right-click and select Add to HDFS. Enter the required information in the fields for specifying HDFS parameters. For deployments that use Teradata or Greenplum, right-click and select Add to data server. The menu choice depends on the co-located data provider.

For deployments that use a third-party vendor database as a co-located data provider, a default library for the database is registered in metadata during installation and configuration. This library is located in SAS metadata at

/Products/SAS Visual Analytics Administrator/SAS
                     Visual Analytics Distributed Data

. This library is configured with options that are specific to operating with a distributed database. When you create an add to data server job, remember to save the job so that the output table is registered in metadata with the distributed data library.

Load from HDFS

SAS LASR Analytic Server can load data from the Hadoop Distributed File System (HDFS) that is co-located on the machines in the cluster. Before loading the data, you must add the data to HDFS.

To load a table to HDFS 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 HDFS 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.