Databases Reference
In-Depth Information
Registering User Identities
In SAS Data Integration Studio, the metadata for users and groups is used to
support change management, connections to a remote computer with SAS/CONNECT,
and connections to a DBMS with SAS/ACCESS software.
Also, SAS Data Integration Studio users can select the metadata for a user or group
and associate it with the metadata for a table, a job, or any other kind of object that can
be displayed in the Inventory tree. To the metadata for a job, for example, you could
add the metadata for the person who needs to be contacted if the job fails.
Your data warehouse project plan should identify the users and groups that are
required for your data warehouse. For the example data warehouse, metadata for the
following persons and groups must be added to the foundation repository:
an administrator with the generic name Metadata Admin
several SAS Data Integration Studio users with generic names such as etlUser1
and etlUser2
a group for SAS Data Integration Studio users named ETL User Group
The metadata for each person or group specifies certain privileges. For example, the
metadata for Metadata Admin specifies administrative privileges, such as the privilege
to write metadata directly to a foundation repository or a custom repository without
having to use a project repository. The metadata for ETL User Group specifies
privileges for users who work under change management, and etlUser1, etlUser2, and
other users are members of that group.
The SAS Configuration Wizard in the SAS Software Navigator enables you to run a
script that will automatically add metadata for some users and groups. Use SAS
Management Console to add metadata that is not provided by the scripts in the SAS
Software Navigator. 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
.
Creating a Metadata Profile (for Administrators)
After you start SAS Management Console, a window displays that has various
options for maintaining a
metadata profile
. A metadata profile is a client-side
definition of where the metadata server is located. The definition includes a machine
name, a port number, and one or more metadata repositories. In addition, the metadata
profile can contain log on information and instructions for connecting to the metadata
server automatically. You cannot do any work in SAS Management Console, in SAS
Data Integration Studio, or in related applications until you create and open the
appropriate metadata profile.
For the example data warehouse, the following metadata profiles must be created:
at least one metadata profile for an administrator
a metadata profile for each SAS Data Integration Studio user. Users will create
their own metadata profiles, as described in “Creating a Metadata Profile (for
Users)” on page 94.
SAS Data Integration Studio users typically work under change-management control.
However, some tasks in SAS Data Integration Studio, such as deploying a job for
scheduling or generating a stored process for a job, cannot be done under
change-management control. In contrast to most users, a SAS Data Integration Studio
administrator has the following characteristics:
a metadata identity that grants the privilege to write metadata directly to a
foundation repository or to a custom repository without having to use a project
repository
Search WWH ::
Custom Search