9.1.3 Change For Metadata-Based Library Pre-assignment

Overview

When libraries are pre-assigned by using metadata, SAS 9.1 and 9.1.2 use the Metadata LIBNAME Engine to obtain library and table metadata. In SAS 9.1.3, this functionality has been changed—instead of the Metadata LIBNAME Engine, SAS now uses the library engine that is specified in the metadata. As a result, table metadata is no longer available through libraries that are preassigned this way.

In most cases, you do not need to change your configuration in order to preserve functionality from earlier releases; most SAS clients access table metadata by connecting to the SAS Metadata Server directly. However, if your SAS configuration uses table metadata through the library engine (for example, to control security), then you will need to change your library pre-assignment as described in the following section.

Preserving Table Metadata Functionality from Earlier SAS 9.1 Releases

For SAS 9.1 and SAS 9.1.2, the library pre-assignment process is as follows:

1. Define the library in SAS Management Console and check the Library is pre-assigned box.

2. For the server, specify the METAAUTOINIT object server parameter (on by default for SAS OLAP Servers).

3. Secure the table objects that you want to control.

4. Start the server. The Metadata LIBNAME Engine is automatically used to assign the library and read table metadata.

To use table metadata through the library engine in SAS 9.1.3, you must retrieve the library metadata by using a metadata LIBNAME statement in an autoexec file. The following tasks describe how to use the metadata LIBNAME statement:

Update an Existing Library Pre-assignment to Use the Metadata LIBNAME Engine

1. In the autoexec file for the server, add a LIBNAME statement that uses the Metadata LIBNAME Engine. Use the following syntax:

   LIBNAME libref-in-metadata META LIBRARY="name-in-metadata"
                              METAREPOSITORY="repository-name";

   libref-in-metadata	matches the Libref property of the library definition in the metadata.
   name-in-metadata	matches the Name property of the library definition in the metadata.
   repository-name	matches the name of the metadata repository where the library definition is stored.

   
   

2. Start the server. The Metadata LIBNAME Engine is used to assign the library and to read table metadata.

Create a New Library Pre-assignment That Uses the Metadata LIBNAME Engine

1. Define the library in SAS Management Console and select Library is pre-assigned.

2. Secure the table objects that you want to control.

3. In the autoexec file for the server, add a LIBNAME statement that uses the Metadata LIBNAME Engine. Use the following syntax:

   LIBNAME libref-in-metadata META LIBRARY="name-in-metadata"
                              METAREPOSITORY="repository-name";

   libref-in-metadata	matches the Libref property of the library definition in the metadata.
   name-in-metadata	matches the Name property of the library definition in the metadata.
   repository-name	matches the name of the metadata repository where the library definition is stored.

   
   

4. Start the server. The Metadata LIBNAME Engine is used to assign the library and to read table metadata.