You can enable a nightly
transfer of selected tables from the SAS Environment Manager data
mart to the SAS Visual Analytics administrative reporting drop zone.
If autoload is enabled for associated LASR library, the copied tables
are loaded to a SAS LASR Analytic Server. For more information see SAS Visual Analytics: Administration Guide
Note: Although data tables that
are copied to the drop zone can be loaded into SAS Visual Analytics,
predefined reports and analytic processing for the data might not
be available in SAS Visual Analytics.
You should ensure that
the SAS Visual Analytics drop zone location is accessible from the
SAS Environment Manager Enablement Kit Server machine, which is the
location where the ETL processes run. Follow these steps:
-
Log on to SAS Management
Console.
-
Using the
Data
Library Manager plug-in, locate the entry for the
Environment
Manager Data Mart LASR library.
-
Right-click on the library,
and select
Properties.
-
In the
Extended
Attributes tab, note the value of the
VA.AutoLoadLocation attribute.
This is the default path that the SAS Environment Manager ETL processes
will use when copying data from the data mart. Verify that this location
is accessible from both the SAS Environment Manager Enablement Kit
Server machine and from the SAS Visual Analytics server machine.
If you specify a new
location for the VA.AutoLoadLocation attribute,
ensure that the directory contains the subdirectories Append, Formats,
Logs, and Unload.
To enable the data feed
for SAS Visual Analytics, follow these steps:
-
On the machine on which
SAS Environment Manager is installed, change to the
<Levelroot>/Web/SASEnvironmentManager/emi-framework/bin (UNIX)
or
<Levelroot>\Web\SASEnvironmentManager\emi-framework\bin (Windows)
directory.
-
From a command line,
issue the command
emi_init.sh -vafeed ON (UNIX)
or
emi_init.bat -vafeed ON (Windows).
If SAS Visual Analytics
and SAS Environment Manager are not running on the same machine, you
must modify the sasev.properties file to identify the target location
for the data tables that are to be loaded into SAS Visual Analytics.
Modify the vafeed.destDir= property to specify
the location on the SAS Environment Manager machine where the data
tables should be copied. The target directory that you specify must
have a subdirectory named /Formats.
You must then move the data tables from the SAS Environment Manager
machine to the SAS Visual Analytics machine. You can use techniques
such as FTP transfer or NFS mounts to move the data tables.
If the machines that
run SAS Visual Analytics and SAS Environment Manager are also using
different operating systems, you must use PROC CPORT to create a machine-independent
export file of the data and then use PROC CIMPORT to load the data
into the proper format for the SAS Visual Analytics machine. The basic
procedure consists of these steps:
-
The nightly ETL processes
copy the data from SAS Environment Manager to the location specified
by the vafeed.destDir property.
-
Run SAS code containing
PROC CPORT statements to create CPT files for the data sets and catalog
that are to be loaded into SAS Visual Analytics.
-
Move the CPT files to
the SAS Visual Analytics machine.
-
Run SAS code containing
PROC CIMPORT statements to read the CPT files and create the data
sets and catalog on the SAS Visual Analytics machine.
-
Move the data sets and
catalog to the drop zone.
The tables copied from
the data mart to the drop zone are suitable for analysis and reporting
with SAS Visual Analytics. The specific set of tables and their structure
might change over time and in future releases. By default, the following
are the tables that are copied:
ACM.FILEMOUNTS
metric data for the
file mounts in your environment
ACM.HOSTPLATFORMS
metrics for the platform-level
resource monitored by SAS Environment Manager that correspond to operating
systems
ACM.HTTPCHECKS
metric data for the
HTTP response-checking resources created by SAS Environment Manager
Extended Monitoring
ACM.SASAPPSERVERS
metric data for the
SAS application servers
ACM.SASLOGICALSERVERS
metric data for the
SAS logical servers
ACM.METADATASVRS
metric data for the
SAS Metadata Servers
ACM.NETWORKINTERFACE
metric data for the
network interfaces
ACM.TCSERVERMGRS
metric data for individual
SAS web applications
ACM.WEBAPPSERVER
metric data for SAS
Web Application Server instances
ACM.WIPDATADB
metric data for the
databases within the Web Infrastructure Platform Data Server
KITS.EMI_INFO
metrics on the performance
of SAS Environment Manager ETL processes