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 .
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)
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.
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.
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.