About Loading Data to the SAS LASR Analytic Server

Table Metadata

Source tables are registered in metadata with Register Tables wizard in SAS Management Console or by using PROC METALIB. Then, you use SAS Visual Analytics Administrator to load tables to memory on the SAS LASR Analytic Server. SAS Visual Analytics Administrator uses table metadata for information about table properties such as column names and data types. Output tables, which are shown as target tables in the Load a Table window, are registered when you click Submit in the Load a Table window.

Requirements for Loading Tables

You can use SAS Visual Analytics Administrator to load or reload tables to the SAS LASR Analytic Server, or to unload tables. The following requirements must be fulfilled:
  • A minimum of one SAS LASR Analytic Server component must exist in the metadata. By default, a SAS Visual Analytics deployment creates one SAS LASR Analytic Server component in the metadata.
  • If you create a SAS LASR Analytic Server component in the metadata, a server connection is automatically created for that server component.
  • A LASR library must be associated with the server connection in the metadata. This task is performed in SAS Management Console with the Data Library Manager plug-in or with SAS Data Integration Studio. By default, a SAS Visual Analytics deployment creates the Visual Analytics Library.
  • The source table must be registered in the metadata. This task is typically performed in SAS Management Console. You must have ReadMetadata permission for the table.
  • You can have only one table with a specific SAS table name that is loaded into a LASR library at one time.
  • The metadata name for a target table must be unique within the metadata folder. This is applicable for tables that are loaded to a distributed SAS LASR Analytic Server.
  • You can have more than one metadata target table that is associated with a specific SAS table name in a LASR library. This is applicable for tables that are loaded to a distributed SAS LASR Analytic Server.
For information about the metadata permissions that are required for tables, see SAS Visual Analytics: Administration Guide.

Using the Load a Table Window

You can access the Load a Table window from the LASR Tables tab or from the Folders window. This window enables you to load or reload tables to the SAS LASR Analytic Server.
Load a Table Window
Load a Table Window
The following table describes the fields:
Fields in the Load a Table Window
Field
Description
Source Table
Name
Specifies the filename of the source table in the metadata that was selected.
Library
Specifies the library in the metadata with which the source table is associated.
LASR Table
Name
Enter the metadata name of the target or output table that should be loaded to the SAS LASR Analytic Server.
Description
This field is optional. Enter a description of the LASR table.
When a user selects to view a list of data sources in the Open Data Source window within SAS Visual Analytics applications, this description is displayed for this LASR table in the list of data sources.
This description is also displayed for this LASR table on the LASR Tables tab within SAS Visual Analytics Administrator.
Location
Click Browse and navigate in the folder tree to select the folder where the LASR table should be placed. The metadata name of the LASR table must be unique within that folder.
Library
Click Browse and select the LASR library that should be associated with this LASR table.

Reloading Tables

You can reload a table when the following is true:
  • The table is in an unloaded state that is indicated by the status Unloaded Table.
  • When you select the table, Reload a Table is available.
The table is reloaded from the original source table.
Copyright © SAS Institute Inc. All rights reserved.