BookmarkSubscribeRSS Feed
Sommeit
Calcite | Level 5

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.

 

 

1 REPLY 1
VincentRejany
SAS Employee
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.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 949 views
  • 0 likes
  • 2 in conversation