Klik hier voor Nederlands >

PW Metadata Explorer

Search, browse and explore SAS metadata from a web browser in a user-friendly interface. The PW Metadata Explorer is built using SAS technology and available in the public domain. Through it all information in the SAS metadata can be accessed, including the elements surfaced through the SAS desktop clients.

Benefits

Simple Interface

Search and explore metadata without the need to write code and queries. The user-friendly interface relies on modern web techniques for an optimal user experience. Information on metadata objects like jobs, transformation steps and columns and tables are presented in a structured way.

No client installation required

The PW Metadata Explorer is a web application, available to everyone with appropriate authorizations on the SAS metadata. This makes the metadata available to everybody, without the need for a SAS client and without any installation of software on local machines.

Expose all details

Search for a specific object using a filter or list all objects of a specific type. List all attributes and associations for a specific object and browse through the entire metadata, following the associations.

Extended information

Details for columns and jobs are extended with addition information. When the results for columns are shown the table it belongs to is shown as well. When viewing jobs, a more detailed view is available with additional information, showing the tables that are read and written in each job step.

Features

Search metadata

Search metadata with simple or complex queries.

Browse metadata

Explore all metadata through associations.

Secure

PW Metadata Explorer relies on the SAS Mid-Tier for authentication and authorization. Users will only see the metadata objects they can see according to their authorization set in the SAS Metadata

Technical

Requirements

  • Server
    • SAS 9.4
    • SAS Stored Process Server
    • SAS Stored Process Web Application
  • Client
    • HTML5 Compatible Browser

Installation

  • Download this zip file >
  • Unzip everything to a Source code repository.
  • Make sure that the SAS tables and template store can be overwritten by the account the runs the Stored Processes.
  • Define a Stored Process on the file PW_MDE_UI.sas, with streaming output.

Execution

Start the application from a web browser through the Stored Process Application
http://your_server:7980/SASStoredProcess/do
(you might have to use https: or another port number), or directly through

http://your_server:7980/SASStoredProcess/do?_program=/your/metadata/path/PW Metadata Explorer

On first execution some supporting files may have to be updated. A message will be displayed, and the Stored Process will take care of that.

A more extensive description of the installation steps is included in the zip file.


Copyright (C) 2019  PW Consulting

This program is (these programs are) free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program.  If not, see https://www.gnu.org/licenses/

DOWNLOAD HERE THE PW METADATA EXPLORER >

PW Consulting

PW Consulting