BookmarkSubscribeRSS Feed
Calcite | Level 5

Hi guys,

Can anyone share any documentation on how to setup an auto-load for the ODBC SQL server TABLES to the LASR. server ?

I manage to import the SQL TABLE to LASR server manually using the "Manage Environment - Manage Table" function. But whenever my SQL TABLE have some data append or changes from the source  , it will not auto reload the table in the LASR until you manually reload it again . 

The purpose that i want to archive is to ensure the latest ODBC tables data can be show in my SAS VA report .

Lapis Lazuli | Level 10

Hi Stanley,

You created a direct load of the data into the LASR server, and that is a single load.

If you create a "data query" to import the data into the LASR server, you can schedule the update to refresh the data.  (Job scheduler)

This might already solve your update/reload problem.  (If a certain update frequency is ok for you) (for me it works fine)

Technically you could create SAS script for this. (Never done this by myself)

Greetings  Peter

Calcite | Level 5

SAS Macros would be a viable option in this case. Also there is an interesting functionality available in Visual Data Builder, once the relations are defined, you can schedule the job in the Data Builder itself where you can select how often you want to query the source data and run the job. It gives you multiple options to schedule the job run and your in-memory tables would be refreshed with the fresh data available. you don't have to do it manually every time provided all your ETL layer is done.


Calcite | Level 5

Have you ever find the answer to your question? I am facing the same issue here, I need to miror a table between SQL Server and LASR table.





Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 4 in conversation