Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Load LASR table from another server

Reply
Contributor
Posts: 23

Load LASR table from another server

[ Edited ]

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 Smiley Happy

Trusted Advisor
Posts: 1,839

Re: Load LASR table from another server

Hello @LukeL,

 

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

 

Does it help?

 

Kind regards,

Juan

SAS Employee
Posts: 547

Re: Load LASR table from another server

@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

Contributor
Posts: 23

Re: Load LASR table from another server

Unfortunately...we are still in 9.4 M1 Smiley Sad
Super User
Posts: 4,011

Re: Load LASR table from another server

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.

Contributor
Posts: 23

Re: Load LASR table from another server

Am I asking too much if I ask you for a code example? 😶
Super User
Posts: 4,011

Re: Load LASR table from another server

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
Ask a Question
Discussion stats
  • 6 replies
  • 150 views
  • 2 likes
  • 4 in conversation