Architecting, installing and maintaining your SAS environment

Sharing metadata tables between two metadata enviroments

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Sharing metadata tables between two metadata enviroments

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.


Accepted Solutions
Solution
‎12-14-2016 07:10 AM
Super User
Posts: 3,104

Re: Sharing metadata tables between two metadata enviroments

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.

View solution in original post


All Replies
Super User
Posts: 3,104

Re: Sharing metadata tables between two metadata enviroments

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.

New Contributor
Posts: 3

Re: Sharing metadata tables between two metadata enviroments

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.

Solution
‎12-14-2016 07:10 AM
Super User
Posts: 3,104

Re: Sharing metadata tables between two metadata enviroments

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.

New Contributor
Posts: 3

Re: Sharing metadata tables between two metadata enviroments

Thanks, looking at the DI jobs this morning I was able to locate the physical files.
Super User
Posts: 5,256

Re: Sharing metadata tables between two metadata enviroments

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.
Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 256 views
  • 0 likes
  • 3 in conversation