Metadata Editor
Pentaho Metadata Editor (PME) is a desktop application that's part of the Pentaho suite of business intelligence tools. It allows users to create and manage metadata layers that bridge the gap between raw data sources and business users.
Here are the key features and functions of Pentaho Metadata Editor:
Business Model Creation:
Enables users to create business-friendly data models that abstract the technical complexity of underlying databases
Allows defining business categories, tables, columns, and relationships in user-friendly terms
Metadata Management:
Provides tools to define business logic, calculations, and formulas
Supports creating and managing custom SQL queries
Enables setting up security and access controls for different user groups
Data Source Integration:
Connects to various data sources including relational databases, flat files, and other data warehouses
Supports mapping physical database structures to logical business models
Handles multiple schemas and complex relationships between tables
Business View Customization:
Allows renaming technical database fields to business-friendly terms
Supports creation of calculated fields and custom formulas
Enables setting up default aggregations and formatting rules
Localization Support:
Provides capabilities to define business models in multiple languages
Supports internationalization of column names and descriptions
Security Features:
Enables role-based security implementation
Allows setting up row-level security
Provides options for controlling access to specific columns and tables
Report Integration:
Creates metadata models that can be used directly in Pentaho Report Designer
Supports the development of standardized reporting templates
Enables consistent data definitions across different reports
The primary purpose of PME is to create a semantic layer that makes complex database structures more accessible to business users while maintaining data consistency and security across the organization.
Last updated
Was this helpful?