topic Re: Sharing metadata tables between two metadata enviroments in Administration and Deployment

Sharing metadata tables between two metadata enviroments

Abashore — Thu, 08 Dec 2016 20:18:15 GMT

We currently have separate SAS environments each with their own metadata server:

Environment A which consists of Office and Visual Analytics (SAS 9.4 TS1M3)
Environment B which consists of Financial Management and Data Integration (SAS 9.4 TS1M2 but upgrading soon)

Both of these have been used my separate groups inside our organization and recently they have become interested in sharing some of the metadata tables residing in Environment B with Environment A to be used in Visual Analytics.

Is there any way to share this data besides manually exporting and importing into the other environment? Ideally we'll probably look into combining the environments but are looking for options in the short term.

Re: Sharing metadata tables between two metadata enviroments

SASKiwi — Thu, 08 Dec 2016 23:41:18 GMT

What about the physical SAS tables that your metadata definitions describe? Are these being shared too? It would not make a lot of sense to share metadata definitions if they referred to non-shared SAS tables.

Re: Sharing metadata tables between two metadata enviroments

Abashore — Fri, 09 Dec 2016 00:18:53 GMT

These are tables created by DI jobs and I don't think it's actually creating physcial tables on the server's hard drive based on what I've read(?). Please correct me if I am wrong.

Re: Sharing metadata tables between two metadata enviroments

SASKiwi — Fri, 09 Dec 2016 05:58:08 GMT

DI jobs always create physical tables - a metadata table is merely a description (data dictionary) of what is in the physical table. The actual data is always in the physical table.

Re: Sharing metadata tables between two metadata enviroments

LinusH — Fri, 09 Dec 2016 06:50:14 GMT

Beside @SASKiwi accurate note about the physical side of it, I don't think that there's a middle way here. Export/Import is probably your short term solution. But there's a batch facility so you could automate this job.

Re: Sharing metadata tables between two metadata enviroments

Abashore — Fri, 09 Dec 2016 12:40:25 GMT

Thanks, looking at the DI jobs this morning I was able to locate the physical files.