topic Re: Scheduled refresh of loaded table in SAS Visual Analytics on Viya in Developers

Scheduled refresh of loaded table in SAS Visual Analytics on Viya

udden2903 — Sat, 24 Feb 2018 14:38:58 GMT

Hi,

I have loaded a table into CAS from Oracle and built a report in SAS VA. The table is updated at regular intervals in Oracle. How do I create a job in SAS Viya that refreshes the table in CAS so that my report will reflect the most recent data?

Re: Scheduled refresh of loaded table in SAS Visual Analytics on Viya

SASKiwi — Sat, 24 Feb 2018 22:15:54 GMT

Have you looked at these links in the Viya documentation?

http://documentation.sas.com/?docsetId=calscheduling&docsetTarget=p0be15ptyesy4bn0ze76u3gd87mo.htm&docsetVersion=3.3&locale=en

http://documentation.sas.com/?docsetId=calscheduling&docsetTarget=p10pvo0yrvzneyn1ggmffnvevslt.htm&docsetVersion=3.3&locale=en

Re: Scheduled refresh of loaded table in SAS Visual Analytics on Viya

udden2903 — Sat, 24 Feb 2018 22:56:17 GMT

Yes, but the documentation is not very helpful. For example, the section on scheduling jobs using SAS Environment Manager assumes that a job already exists and can be selected from the Jobs menu. I need to know how to create a job before I can schedule it.

Re: Scheduled refresh of loaded table in SAS Visual Analytics on Viya

SASKiwi — Sat, 24 Feb 2018 23:17:30 GMT

According to this link to SAS Data Explorer, you can define data sources for CAS and also create jobs that can be scheduled:

http://documentation.sas.com/?docsetId=datahub&docsetTarget=p1sv89vo4n8f03n0zvq0k90i8g3t.htm&docsetVersion=2.1&locale=en

I think you can also create SAS programs to do this. I've taken this approach with VA 7.4 but I would think it would work equally as well with Viya which we don't have yet.