Running Visual Data Queries by Command line or Management Console

[vfarmak]

Dear all,

I am writing in reference to the product Visual Analytics.

Is there a way that someone could run via script in the server or in Management Console Visual Data Queries.

I am asking because in case of the Visual Analytics Server's downtime, when it is already up I have to execute every visual data query and we have around 60 queries.

Thank you

[SASKiwi]

Yes, this is reasonably easy to do. We have a batch SAS process which can be scheduled or run from SAS Management Console to reload tables into the LASR server after a reboot or shutdown.

The best approach is to keep copies of all of the VA tables you want to load as SAS datasets on disk. Then you run a standard load process which loads each of the required tables from disk into memory.

[vfarmak]

Thank you for your feedback.

And I understand your point.

However, there is no 1:1 relation from the SAS Dataset to VA Lasr due to the fact that some joins are performed inside the visual data query.

This was done because the times the data need to load from DI to LASR were significant higher than load the datasets on the LASR and then joining by Visual Data Query.

Is there any alternative to run the Visual Data Query from SAS management console?

[SASKiwi]

Visual Data Queries are not something I'm particularly familiar with, given we do all of our VA data preparation outside of VA in Base SAS. However they appear to have a scheduling and batch-mode capability as explained in this doc.