SAS Data
Integration Studio can import and export relational metadata in any
format that is supported by a SAS Metadata Bridge. By importing and
exporting relational metadata in external formats, you can reuse
metadata from third-party applications, and you can reuse SAS metadata
in those applications as well. For example, you can use third-party
data modeling software to specify a star schema for a set of tables.
The model can be exported in Common Warehouse Metamodel (CWM) format.
You can then use a SAS Metadata Bridge to import that model into SAS
Data Integration Studio.
The Export
Metadata Wizard enables you to export relational metadata from SAS
Data Integration Studio to a file, in any format that is supported
by a SAS Metadata Bridge. The Import Metadata Wizard enables you to
perform the following tasks:
-
Import relational metadata in a
file, in any format that can be accessed with a SAS Metadata Bridge.
-
Compare imported metadata to existing
metadata.
-
View any changes in the Differences
window.
-
Run impact analysis or reverse
impact analysis on tables and columns in the Differences window, to
help you understand the impact of a given change on the target environment.
-
Choose which changes to apply to
the target environment.