Business Data Network - Importing data structure already existing in Metadata

Sommeit — Tue, 28 Apr 2020 15:29:55 GMT

Question from the newbie in SAS:

- SAS9.4M6

- SAS BDN 3.3

Here my business requirement:

I need to load an enterprise data model in SAS BDN (MSSQL, Oracle, mySQL Hadoop). BDN would become the main platform for data architect to manage the comapny datamodel.

To do so, I need to import all my tables already loaded in Mgt Console:

- Tables: Table Name, term:table, Associated Items(table in meta)

- Columns: Column names, term column, Parent(tables) and associated items (from SAS meta)

All additional attributes will be manage manually by the business (data Steward)

(e.g. Description, Requirement, from term: Data Owner, Data Steward, Data Custodian, ...)

Base on my reseach, I start to believe there is no existing method proposed by SAS to perfor this load. I would need to build my own XML builder to prepare my data model import.

Question:

1- Is there a more mature method to load this data if it already include in SAS metadata?

2- if not, what would be the best way to extract the metadata (with IDs) from a shared data if I would like to develop a script to "stitch" my schema to my SAS meta elements.

Re: Business Data Network - Importing data structure already existing in Metadata

VincentRejany — Fri, 09 Oct 2020 17:11:34 GMT

Hi
SAS Business Data Network is a business glossary not a data catalog.
You SAS libraries and tables are automatically populated as part of SAS lineage. If you still want to import your tables and libraries as terms, you can export your tables for each library through the metadata export and create an excel file to be imported into bdn.

topic Re: Business Data Network - Importing data structure already existing in Metadata in SAS Data Management

Business Data Network - Importing data structure already existing in Metadata

Re: Business Data Network - Importing data structure already existing in Metadata