Databases Reference
In-Depth Information
Studio users to work with the same metadata repository at the same time—without
overwriting each other's changes.
For the example data warehouse, the following metadata repositories must be
created:
￿ A foundation repository where all metadata about the example warehouse will be
stored. This repository will be under change-management control. The repository
will be named Foundation.
￿ A set of project repositories, one for each SAS Data Integration Studio user. Each
project repository depends on (inherits metadata from) the foundation repository.
Each project repository enables a user to check metadata out of the foundation
repository. After changes are made to checked-out objects, or new metadata objects
are added, the new or updated metadata is checked into the foundation repository.
For the data warehouse example, each project repository will have a name such as
Project: etlUser1.
For details about setting up change-managed repositories for SAS Data Integration
Studio, administrators should see the change management section in the SAS Data
Integration Studio chapter in the SAS Intelligence Platform: Administration Guide .In
general, an administrator uses SAS Management Console to define a change-managed
repository (such as a foundation repository) and one or more project repositories that
depend on the change-managed repository. The administrator designates a SAS Data
Integration Studio user as the owner of each project repository. Administrators with the
appropriate privilege can update a change-managed repository directly, without having
to work with a project repository.
Registering Servers
Server Metadata Required for the Example
The SAS Configuration Wizard in the SAS Software Navigator enables you to run a
script that will automatically add metadata for some servers. Use SAS Management
Console to add metadata that is not provided by the scripts in the SAS Software
Navigator.
The following table summarizes how the servers for the example data warehouse
would be made available to SAS Data Integration Studio users.
 
Search WWH ::




Custom Search