Databases Reference
In-Depth Information
Default Metadata Repository
When you create a metadata profile, you specify a default metadata repository for
that profile. Typically, the administrator who creates metadata repositories simply tells
SAS Data Integration Studio users which repository to select as the default. As a user,
however, you might want to be aware of the effect that the default repository has on
your work in SAS Data Integration Studio. The effect depends on whether you are
working with change-managed metadata repositories.
If you are working with change-managed repositories, the default metadata
repository must be a project repository that you own. You will use the project repository
to check metadata out of and into the repository that is under change management. For
the example data warehouse, the main metadata repository (Foundation) is under
change-management control. Each user will use his own project repository to check
metadata out of and into the foundation repository.
If you are not working with change-managed repositories, you can update objects in
any metadata repository that is visible in the tree view on the SAS Data Integration
Studio desktop, but you can add new objects to the default metadata repository only. If
you try to add an object to a repository other than the default repository, the new object
will be added to the default repository.
Task Summary
SAS Data Integration Studio users follow these steps to create a metadata profile:
1 Start SAS Data Integration Studio. The Open a Metadata Profile window displays.
2 Select Create a new metadata profile . The Metadata Profile wizard displays.
3 Click Next . In the general information window, enter a name for the profile. For
the example data warehouse, the name could be etlUser1 Profile .
4 Click Next . In the Connection Information window, enter a machine address, port,
user name, and password that will enable you to connect to the appropriate SAS
Metadata Server.
5 Click Next . The wizard attempts to connect to the metadata server. If the
connection is successful, the Select Repositories window displays.
6 In the Select Repositories window, select the appropriate repository as the default
metadata repository for this profile. For the example data warehouse, the default
repository for a user would be a project repository that would be used to check
metadata out of and into the foundation repository.
7 Click Finish to exit the metadata profile wizard. You are returned to the Open a
Metadata Profile window.
Opening a Metadata Profile
After a metadata profile has been created, you can open the profile in SAS Data
Integration Studio. You must open a metadata profile in order to do any work in SAS
Data Integration Studio.
Follow these steps to open a metadata profile:
1 Start SAS Data Integration Studio. The Open a Metadata Profile window displays.
2 Select Open an existing metadata profile . The selected profile is opened in
SAS Data Integration Studio.
Another way to open a metadata profile is to start SAS Data Integration Studio, then
select File ￿ Open a Metadata Profile from the menu bar.
If you are working with change-managed metadata repositories, see “Working with
Change Management” on page 113. Assume that the main metadata repository for the
example data warehouse is under change-management control.
 
Search WWH ::




Custom Search