Hi all. I'm currently engaged in a project using multiple technologies including SAS/DI Studio and a non-SAS Enterprise Metadata Catalog solution has been chosen. Much of the basic data management are done using SAS/DI Studio (+500 jobs) with a typical job comprising 40-60 "objects" (tables, joins, mappings, business rules, etc.). In order to establish E2E data lineage and impact analysis we need to registrer the flows, dependencies, etc. in the "Enterprise Data Catalog" to be used by Business, Data Scientists and Data Engineers based on common Glossary/Terms across the value chain. Have tried to import a SPK exported out of SAS/DI Studio and imported into the Data Catalog, During the import it seems as if lots of objects are imported via the metadata bridge for SAS/DI Studio but of 55 objects in the SAS/DI job only 12 gets surfaced within the Data Catalog. It sounds as if there is a way as the SPK actually contains all the right information but this is not supported by SAS's CWM/XMI export/import bridges. Dispite all the major vendors wishes for a single vendor strategy, this is rarely (if never) the case in an enterprise organisation. Hence there is a need/request to be able to exchange metadata and integrate this in built for purpose Metadata Mgmt/Data Catalog solutions like Collibra, Alation, Waterline, Informatica, Talend, Oracle, SAP, etc. So, since this is not currently supported by SAS (we need this) have anyone had success in exporting a SPK and manipulate the XML-structure to successfully import a SAS/DI Studio job/flow to any of the above technologies? Thanks, Lars
... View more