I had a similar challenge with data in a SQL server database. I got round this by creating a connection to the external data using SAS Management Console. It was a bit of a convoluted process where as I need to create a number of items such as:   An authentication domain (I had to do this in order to store the password for the SQL Server user). Create a database server. Create a data library. Finally register the tables.   Once i'd done this I am able to schedule a regular refresh from the source in data preparation or simply reload by right mouse clicking on the tablein the admin screen.   Below is a link to help with ODBC. You may be able to find something similar for Hadoop data stores as I can see there are Hadoop Severs and Hadoop via Hive Libraries in SAS Management console.   http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/viewer.htm#a003098426.htm       ... View more

Lorrie, our deployment doesn't inlcude HDFS. The re-load on start flags are set in the management console for the LASR library, therefore I have assumed that data must be staged on the LASR server as a BASE SAS table in order to re-load on start. My data is held externally and pulled in via ODBC initially. ... View more

Thanks for the pointers Lorrie. Having tried this I am struggling with the location to create the staging table(s). You can see below the libraries I have from the default installation. When I looked to select the library for the staging table the only two options I could select were the Visual Analytics Public Data Provider and Visual Analytics Public LASR libraries.The latter gave me an error ("The application does not support SAS LASR Analytic Server Staging Libraries") when I attempted to select this.Am I missing a library to store the staging tables? Regards, Dave. ... View more