topic Re: Load data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA. in Administration and Deployment

Load data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA.

sergie89 — Thu, 30 Aug 2018 12:55:19 GMT

Hello all,

We would like load data directly from Data Integration Studio (which is hosted on a separate server) to LASR memory on SAS Visual Analytics. We are running VA 7.3 M3 and SAS BI server 9.4M3 all on Linux and are distributed.

We are able to load data from DI to VA in Enterprise Guide. But it's in SAS code. (see https://communities.sas.com/t5/SAS-Communities-Library/Revisiting-Remote-LASR-Loads-Using-SASIOLA/ta-p/373352) and (http://support.sas.com/kb/56/996.html)

What kind of other opertunities do we have and what are the steps for setting it up?

Thanks in advance.

Re: Load data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA.

alexal — Fri, 31 Aug 2018 01:50:15 GMT

@sergie89,

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 data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA.

sergie89 — Fri, 31 Aug 2018 07:39:46 GMT

Hi @alexal,

We already have configured SAS LASR Analytic Server Access Tools and we can push data with SAS Code from Enterprise Guide (which is hosted on a separate server) to LASR memory on SAS Visual Analytics.

But I see some transformations such as "SAS LASR Analytical Server Loader and Unload" in DI. Is it possible to use these transformations in DI for pushing data remotely to LASR memory on SAS Visual Analytics.?

I can also define a new SAS Lasr Analytical Server on the DI-server. Should we configure this first ?

What are the next steps for setting it up?

Re: Load data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA.

alexal — Wed, 05 Sep 2018 12:13:26 GMT

@sergie89,

But I see some transformations such as "SAS LASR Analytical Server Loader and Unload" in DI. Is it possible to use these transformations in DI for pushing data remotely to LASR memory on SAS Visual Analytics.?

I'm not familiar with DI and transformations in it, but I'm pretty sure they are using either "proc lasr" or the data step to load the data. Those require SAS LASR Analytic Server Access Tools if you loading the data to the remote server.

I can also define a new SAS Lasr Analytical Server on the DI-server. Should we configure this first ?

You can do that only if you have a LASR server license on the DI server.

Re: Load data directly from DI (which is hosted on a separate server) to LASR memory on SAS VA.

sergie89 — Mon, 10 Sep 2018 09:44:38 GMT

Hi @alexal,

I'm not familiar with DI and transformations in it, but I'm pretty sure they are using either "proc lasr" or the data step to load the data. Those require SAS LASR Analytic Server Access Tools if you loading the data to the remote server.

Hmm, can you ask one of your colleagues if there is something on paper ?

You can do that only if you have a LASR server license on the DI server.

Yes, we have a license for SAS LASR Analytic Server Access Tools 2.7 on the DI server.

We want to implement this solution (load data directly) because we are working with secure data.