SAS Data Integration Studio enables you to import and
export metadata for individual objects or sets of related objects.
You can work with two kinds of metadata:
-
SAS metadata in SAS Package format
-
relational metadata (metadata for
libraries, tables, columns, indexes, and keys) in formats that can
be accessed with a SAS Metadata Bridge
By importing
and exporting SAS Package metadata, you can move the metadata for
SAS Data Integration Studio jobs and related objects between SAS Metadata
Servers. For example, you can create a job in a test environment,
export it as a SAS Package, and import it into another instance of
SAS Data Integration Studio in a production environment.
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.
This chapter
focuses on the wizards that are used to import and export individual
objects or sets of related objects in SAS Data Integration Studio.
For a more comprehensive view of metadata management, administrators
should see the metadata management chapters in the
SAS
Intelligence Platform: System Administration Guide. See
also the technical paper, “Metadata Promotion in SAS 9.2”
at:
http://support.sas.com/resources/papers/tnote/tnote_migration.html.