thinking data® Metadata Explorer

 ThotWave’s Metadata Explorer is a tool that enables users to manage their data using a standard web browser. The Metadata Explorer gives data administrators the power to read and modify tabular data using a spreadsheet-like grid, but in a secure, multi-user browser interface. Data sources can be SAS datasets and relational tables - such as Oracle, DB2 and SQL Server.

Applications

• Reference data maintenance tool for expert users
• Data maintenance tool for database administrators
• Preview data imported from other applications
• Enter manual overrides and adjustments data
• Simple data entry applications such as Time and Expense entry system
• Simple reporting interfaces using custom filters for date ranges and other criteria

Features

• Performs inserts, updates and deletes using spreadsheet-like inline editing
• Role-based security model for controlling which users have access to which views
• Read only and editable data views
• Filters views containing a subset of table rows
• Validates column data types including required columns and ability to configure static anddynamic pick lists
• Maintains referential integrity using pick lists derived from dynamic queries
• Accesses tables from multiple databases in one application
• Displays table and column attributes such as underlying data type and integrity constraints
• Ability to limit visible table columns
• On-the-fly sorting of columns
• Makes data accessible and manageable from any web browser

System Requirements

The Metadata Explorer is designed to be highly portable and easy to integrate. It is able to access and manage datafor any JDBC-accessible database, including SAS data sets and relational databases.

• Required: Java SDK, 1.3 or better
• Required: Java web/application server, servlet API 2.3 or better
• Database: JDBC-compatible relational database
• Web Browser: Internet Explorer 5.5 or better