I need some help in automating the process of unloading & reloading of tables in LASR Server.The tables are fetched from Hive (Hadoop) and saved in a Library.Then, tables are registered and loaded into LASR Server for further usage.Whenever the tables are refreshed , we had to unload & reload them manually.I explored the Autoload feature,but unfortunately it doesn't help with our current environment.Is there a way that we can automate this process? Any help on this regard is highly appreciated.Thanks.
VA Version: 7.2
Deployment: Non distributed
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.