Load LASR table from another server

[LukeL]

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 🙂

[JuanS_OCS]

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

[alexal]

@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

[LukeL]

Unfortunately...we are still in 9.4 M1 😞

[SASKiwi]

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.

[LukeL]

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

[SASKiwi]

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