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.
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!
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.