How To: Loading Data in SAS Visual Analytics - Autoloading Tables 

The Autoload functionality in SAS Visual Analytics is particularly useful for dynamic data sources that are constantly updated.

When source tables are located in a specific autoload folder, Visual Analytics periodically (the default scan interval is 15 minutes) scans the folder for any changes to the data.  As changes are discovered, the tables are automatically reloaded into the LASR server.

This article relates to datasets that have already been registered and loaded previously into SAS Visual Analytics.  For more information, please refer to other 'User Tips: Loading Data in SAS Visual Analytics' articles.

1)     In order to schedule an autoload script, a scheduler account must exist that has host privileges, ie. the ability to start a server, load data and run scheduled tasks. 

(For WINDOWS environments: there is a privilege called ‘Log on as Batch Job’ should be enabled on the computer that hosts the SAS object spawner.)

(For UNIX envirnonments: the ability to run ‘cron’ jobs is required.)

This account must also have read/write access to the autoload and script directories and be registered in metadata.

2)     The autoload directory must have host-layer access.

3)     Schedule autoload by logging on as the scheduler account.

4)     Invoke ‘schedule.bat’ or ‘schedule.sh’ .

5)     To check that autoload has been scheduled in windows, find the ‘Task Scheduler’ under ‘Control Panel > Administrative Tools, Task Scheduler’.

6)     Alternatively, in UNIX, run the command crontab – l

7)     Autoload can be stopped by invoking either  ‘unschedule.bat’ or ‘unschedule.sh’ .  This will not stop the LASR server.