Autoloading database tables generating from microsoft sql server to sas va

[axavi]

Hi,

I read in one of the sas documentation that there is no option for autoloading database tables directly to sas va. Is that true?

We have data table that gets updated every day, the only option we are using is to reload manually in sas va. Are there any way, to automate this process.

Any help or information?

Thanks

[JuanS_OCS]

Hi.
Not with autoload, but you can use tge va data builder app.

In any case, if you have another SAS server, i would always extract and transform the database data from a different server and just drop the uncompressed sas dataset to va to be loaded with autoload.

Best,
Juan

##- Please type your reply above this line. Simple formatting, no attachments.

[SASKiwi]

In addition to @JuanS_OCS's excellent advice, you can schedule a SAS VA load job to run at a particular time each day in SAS Management Console.