Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Autoloading database tables generating from microsoft sql server to sas va

Reply
New Contributor
Posts: 2

Autoloading database tables generating from microsoft sql server to sas va

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

Super User
Posts: 981

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

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.
Respected Advisor
Posts: 2,913

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

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.

Post a Question
Discussion Stats
  • 2 replies
  • 125 views
  • 0 likes
  • 3 in conversation