Databases Reference
In-Depth Information
a metadata profile that specifies the login and password from the administrator's
metadata identity. The profile also specifies a foundation repository or a custom
repository as the default repository.
For details about entering metadata for users and administrators in a
change-management context, see the change management section in the SAS Data
Integration Studio chapter in the
SAS Intelligence Platform: Administration Guide
.
Registering Libraries
Overview of Libraries
In SAS software, a library is a collection of one or more files that SAS recognizes and
that SAS references and stores as a unit. SAS Data Integration Studio uses a
combination of server metadata and library metadata to access the sources and targets
that are referenced in SAS Data Integration Studio jobs. Accordingly, one of the first
tasks for an administrator might be to specify metadata for the libraries that contain
data stores or other resources.
Both SAS Management Console and SAS Data Integration Studio enable you to enter
metadata for libraries. A typical approach would be for administrators to use SAS
Management Console to add metadata for an initial set of libraries. SAS Data
Integration Studio users would then use source designer wizards or target designer
wizards to add metadata about specific tables in a library. Later, administrators and/or
users could add metadata for other libraries as needed.
Entering metadata for a library does not, in itself, provide access to tables in the
library. You must also specify metadata for all tables that you want to access in the
library, as described in “Registering Sources and Targets” on page 97.
Which Libraries Are Needed?
Administrators should ask questions such as these to determine which libraries are
needed for a given data warehouse:
In what format are the source tables and target tables? Are they SAS files,
Microsoft Excel files, DBMS tables, flat files, enterprise application files, or files in
which values are separated with commas or other characters?
If the tables are in SAS format, do the tables use column formats that are defined
in a SAS format library?
If the tables are in SAS format, will SAS/SHARE software be used to provide
concurrent update access to the tables?
If the tables are not in SAS format, how do you plan to access these tables? With a
database library (SAS/ACCESS software for relational databases)? With an ODBC
library (SAS/ACCESS for ODBC)? With the external file interface? With an
enterprise application library (such as a library that uses SAS/ACCESS to R/3)?
Answers to questions such as these determine the type of library metadata that you
need to enter.
Enter Metadata for a Library
The New Library wizard in SAS Management Console and SAS Data Integration
Studio enables you to enter metadata about many different kinds of libraries. For
details about entering metadata for different kinds of libraries, administrators should
see the managing libraries chapter in the
SAS Management Console: User's Guide
.
Search WWH ::
Custom Search