Scheduled refresh of loaded table in SAS Visual Analytics on Viya

[udden2903]

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?

[SASKiwi]

Have you looked at these links in the Viya documentation?

http://documentation.sas.com/?docsetId=calscheduling&docsetTarget=p0be15ptyesy4bn0ze76u3gd87mo.htm&d...

http://documentation.sas.com/?docsetId=calscheduling&docsetTarget=p10pvo0yrvzneyn1ggmffnvevslt.htm&d...

[udden2903]

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.

[SASKiwi]

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&docsetV...

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.