topic Re: Load LASR table from another server in SAS Visual Analytics

Load LASR table from another server

LukeL — Tue, 08 May 2018 09:24:24 GMT

Hi all.

In our enviroments we have two separated server, one for portal and backend BI operations, and one for VA (with its own metadata server and full stack). The two server access to a parallel shared file system.

In the VA machine we have no scheduler or DI, so what we would like to do is to use the first server, that has not the SASIOLA engine installed, to load the table that the VA server see as "data" into the lasr. Is it possiible? I was thinking of using something like the rsubmit, to use on a user input code in a DI job, but have not been able to do it for now.

Thanks 🙂

Re: Load LASR table from another server

JuanS_OCS — Tue, 08 May 2018 09:34:51 GMT

Hello @LukeL,

yours is an excellent question. Here my ideas for you:

Activate an use the Autoload in VA: if your Autoload is a shared folder, your DI etl processes could drop tables into the autoload folder and the VA would pick the new changes as soon as the scheduled autoload task is triggered. If you want to increase performance, you can use also the Unload and Append subfolders.
With EG, there is a functionality to Load data to LASR, which you can schedule as well.
https://blogs.sas.com/content/sgf/2015/08/11/loading-lasr-remotely-with-di-studio-sasconnect/
http://bi-notes.com/2015/10/oh-snap-upload-data-to-the-lasr-server-just-like-that/

Does it help?

Kind regards,

Juan

Re: Load LASR table from another server

alexal — Tue, 08 May 2018 11:09:09 GMT

@LukeL,

Beginning with the third maintenance release for SAS® 9.4, SAS® Integration Technologies includes the SAS LASR Analytic Server Access Tools. The SAS LASR Analytic Server Access Tools include two engines: the SASIOLA engine and the SASHDAT engine. These engines make it possible to copy data from an environment without a SAS LASR Analytic Server to a remote SAS LASR Analytic Server or Hadoop Distributed File System (HDFS).

http://support.sas.com/kb/56/996.html

Re: Load LASR table from another server

LukeL — Tue, 08 May 2018 11:25:49 GMT

Unfortunately...we are still in 9.4 M1 😞

Re: Load LASR table from another server

SASKiwi — Tue, 08 May 2018 20:28:42 GMT

SAS/CONNECT is a great solution for this scenario, but it needs to be installed on both your BI and VA servers. We use this method ourselves.

Re: Load LASR table from another server

LukeL — Tue, 08 May 2018 20:31:38 GMT

Am I asking too much if I ask you for a code example? 😶

Re: Load LASR table from another server

SASKiwi — Wed, 09 May 2018 05:16:45 GMT

What code do you need? The steps are:

SIGNON to VA server from BI Server
RSUBMIT load code to VA server
ENDRSUBMIT to close load step
SIGNOFF to close VA session