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

Autoload the ODBC SQL SERVER TABLE TO LASR

Reply
N/A
Posts: 1

Autoload the ODBC SQL SERVER TABLE TO LASR

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 .

Regular Contributor
Posts: 183

Re: Autoload the ODBC SQL SERVER TABLE TO LASR

Posted in reply to stanley82

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

Frequent Contributor
Posts: 85

Re: Autoload the ODBC SQL SERVER TABLE TO LASR

Posted in reply to PeterWijers

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.

satlr

New Contributor
Posts: 2

Re: Autoload the ODBC SQL SERVER TABLE TO LASR

Posted in reply to stanley82

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.

 

Thanks

Ask a Question
Discussion stats
  • 3 replies
  • 1269 views
  • 0 likes
  • 4 in conversation