Keeping LASR Tables updated when source Oracle tables update

[Djones4822]

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? 

[LinusH]

You should be able to script this by using PROC IMSTAT, which could schedule.

[Djones4822]

I've come across that procedure, but I wasn't sure where to place that. Do I schedule that in the Enterprise Guide? 

[SASKiwi]

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.

[LinusH]

Perhaps you could, but that is far from optimal, since that is on a client.
It's bettervti do it from the Management Console's Scheduling Manager (requires that you have stored the program as a .sas file first).
But given that you probably want to execute it right after the Oracle update you should consider how to build that dependency. Perhaps you could use an external scheduler that you organisation uses?

[Djones4822]

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!

[Patrick]

@Djones4822

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.

http://support.sas.com/documentation/onlinedoc/va/7.3/en/vaicg.pdf 

[Djones4822]

@Patrick that's great info, thanks so much - but it looks like that link is broken? 

[AnnaBrown]

Try this link, Djones4822 (without the http://).

support.sas.com/documentation/onlinedoc/va/7.3/en/vaicg.pdf