topic Re: Autoloading database tables generating from microsoft sql server to sas va in SAS Visual Analytics

Autoloading database tables generating from microsoft sql server to sas va

axavi — Wed, 21 Dec 2016 22:29:57 GMT

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

Re: Autoloading database tables generating from microsoft sql server to sas va

JuanS_OCS — Thu, 22 Dec 2016 08:44:19 GMT

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.

Re: Autoloading database tables generating from microsoft sql server to sas va

SASKiwi — Thu, 22 Dec 2016 20:43:19 GMT

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.