Feeding Data from the Data Mart into SAS Visual Analytics

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.
To enable the data feed for SAS Visual Analytics, follow these steps:
  1. 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.
  2. From a command line, issue the command emi_init.sh -vafeed ON (Unix) or emi_init.bat -vafeed ON (Windows).
The tables copied from the SAS Environment Manager 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.IOMSERVERS
metric data for the SAS IOM servers, such as SAS Stored Process Server and SAS Pooled Workspace Server
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
ARTIFACT.ARTIFACTUSAGEDETAILS
usage information for SAS artifacts (such as libraries, directories, and stored processes)
ARTIFACT.ARTIFACTUSAGESESSIONS
usage information at the session level
ARTIFACT.AUDIT_TRANSACTIONS
audit information for metadata transactions
ARTIFACT.AUDIT_GROUP
audit information for metadata changes related to identity groups
ARTIFACT.AUDIT_ADMUSER
audit information for the administrative user activities
ARTIFACT.AUDIT_ACCESSC
audit records for object access events
ARTIFACT.AUDITACCESSCONTROLDETAIL
audit information about changes made to the access control limits and rules for particular metadata objects
KITS.EMI_INFO
metrics on the performance of SAS Environment Manager ETL processes
KITS.LASR_INFO
metrics for the SAS LASR server; this table exists only if the SAS LASR solution kit has been enabled
KITS.SASJOB_INFO
contains metrics extracted from SAS log files that have been placed in a specified landing zone
For information on the contents of these tables, see Data Mart Table Reference.
Last updated: February 22, 2018