topic Re: SAS VA Autload Location in Meta Data Folder Structure in SAS Visual Analytics

SAS VA Autload Location in Meta Data Folder Structure

dirks — Wed, 22 Nov 2017 10:01:13 GMT

Hi,

I just set up autoload in VA. I followed this guide: https://blogs.sas.com/content/sgf/2016/04/04/sas-visual-analytics-autoload-configuration-made-easy/

I can put tables into folders and they will be loaded into my Public LASR Library. So far so good, but the table is put in the wrong metadata folder.

How do I control the folder location?

I marked the table in yellow and it should be put in the red underlined folder.

Thanks and regards

Dir

Re: SAS VA Autload Location in Meta Data Folder Structure

JuanS_OCS — Wed, 22 Nov 2017 10:09:29 GMT

Hello @dirks,

On the library properties (SAS Management Console) you can go to the Extended Attributes tab, and the VA.Default.MetadataFolder.

If you change this folder and restart LASR, and then trigger AutoLoad, it should autoload new tables in the new Metadata folder you have set up.

Re: SAS VA Autload Location in Meta Data Folder Structure

dirks — Wed, 22 Nov 2017 10:17:12 GMT

Hello Juan,

thank you!

Does that mean I would have to create a Library for each set of tables?

I have got all my tables in the VA Public LASR Library and under there I have different folder locations for each report/data mart.

Re: SAS VA Autload Location in Meta Data Folder Structure

JuanS_OCS — Wed, 22 Nov 2017 10:20:33 GMT

Hey @dirks!

yes, for that kind of structure, I would recommend you either create different autoload folders for each metadata folder you need or either nto to use autoload, but use sas procedures/code to load the tables on the folders you need.

Re: SAS VA Autload Location in Meta Data Folder Structure

dirks — Wed, 22 Nov 2017 10:23:40 GMT

@JuanS_OCS wrote:
Hey @dirks!

yes, for that kind of structure, I would recommend you either create different autoload folders for each metadata folder you need or either nto to use autoload, but use sas procedures/code to load the tables on the folders you need.

Juan,

isn't the autoload only per Library? Where do I tell it to use a different metadatafolder? Do you know a guide on how to autoload with procedures or code?

Thanks!

Re: SAS VA Autload Location in Meta Data Folder Structure

JuanS_OCS — Wed, 22 Nov 2017 10:27:12 GMT

Indeed, mantra:

1 autoload folder == 1 autoload SAS library == 1 Autload Metadata folder

If you know how to program SAS, it is quite easy what you mention. And if not, I would recommend you to get on-board a SAS programmer.

Re: SAS VA Autload Location in Meta Data Folder Structure

dirks — Wed, 22 Nov 2017 10:38:19 GMT

Got it! Thanks a lot!