Auto Updation of incremental data in SAS Viya 3.4

chaudharydeepak — Sat, 02 Mar 2019 06:31:07 GMT

Hello all;

I'm working in SAS Viya 3.4 as I want to know about that what is the process or procedure for making the auto updating of the incremental data for the particular reports in the SAS Viya.

My data is stored in My SQL. I'm daily loading data in my SQL but my report does not update daily automatically, I have to do it manually.

Please to needful;

Immediate reply appreciated.

Thanks & Regards;

Deepak.

Re: Auto Updation of incremental data in SAS Viya 3.4

Eric_D — Wed, 13 Mar 2019 16:48:48 GMT

Hey,

I would personally look to making the refresh a 'Job' and then scheduling it using Environment Manger

There is an older post by Gerry Nelson that discusses (and has a great video):

https://communities.sas.com/t5/SAS-Communities-Library/Autoload-unload-import-of-data-via-scheduled-jobs-in-Visual/ta-p/445322

In terms of what is happening you are refreshing your SQL table, but CAS still has the older version of the table loaded.

If say you know your refresh is completed at 5am, you could schedule the Job to refresh the table every day at 6am.

topic Auto Updation of incremental data in SAS Viya 3.4 in Developers

Auto Updation of incremental data in SAS Viya 3.4

Re: Auto Updation of incremental data in SAS Viya 3.4