07-07-2017 11:49 AM
We have an Oracle OLAP database that contains all historical data garthered through our daily transactional processings and is updated every morning. We've also built a suite of reports that use the oracle tables as source tables.
What we're noticing is that the LASR tables do not update automatically each morning, we've found that we need to manually open up the administration view and unload/reload each table.
Is there a process or a system of processes we can use that will keep the LASR tables up to date with the Oracle tables?
07-07-2017 04:18 PM
I've come across that procedure, but I wasn't sure where to place that. Do I schedule that in the Enterprise Guide?
07-08-2017 05:58 PM
You can also use other usual processes to update LASR tables like PROC DATASETS and DATA steps. The trick here is to make sure that the table metadata also remains in synch for which I use PROC METALIB.
07-07-2017 11:54 PM
07-11-2017 10:20 AM
This seems to be it.
We're using Python to do control the ETL - is it possible for me to call SAS script from the command prompt? I know that I could do that typically with SAS installed locally on my machine, but with SAS VA I'm unsure.
I don't suppose you or anyone has any insight into that?
Thanks so much for your replies!
07-11-2017 06:29 PM - edited 07-11-2017 06:34 PM
Yes, you can call SAS in batch mode. That's what every single scheduler does so it's BAU.
To call SAS from a command prompt: You need the prompt on the machine where the SAS server sits (i.e. via Putty for a Unix/Linux distribution).
If I'm not mistaken then a VA instance also comes with the related SAS Compute modules licensed and installed and I believe PROC IMSTAT should be available.