Extensive Database Platform Support
Access and manage models for multiple relational and big data platforms, both on premises and in the cloud. Extensive platform support is enabled through native and database-specific ODBC connections.
Forward and Reverse Engineering
Generate physical data models from existing database designs. Construct graphical models from existing database or schema, for both relational and big data platforms. Easily apply design changes with formulated alter code
Universal Mappings
Map between and within conceptual, logical and physical model objects to trace objects upstream or downstream, using the repository, and specify metadata such as definitions, notes, and attachments
Data Dictionary Standardization
Define and enforce standard data elements, naming standards and reference values for use across and between data models
Advanced Compare and Merge
Enable advanced bi-directional comparisons and merges of models and database structures
Business Data Objects
Represent master data and transactional concepts with multiple entities and relationships, such as products, customers, and vendors
Submodel Management
Allow creation of multi-leveled submodels, merge submodel properties across existing models and synchronize submodel hierarchies
Naming Standards
Assign a naming standards template to models, submodels, entities and attributes for automatic application between logical and physical models
Automatic Migration of Foreign Keys
Maintain foreign keys to ensure referential integrity in database designs
”Where Used” Analysis
Display mappings between logical entities and attributes to their implementation across physical designs
Model Completion Validation
Automate model reviews and enforce standards by validating for missing object definitions, unused domains, identical indexes and circular relationships
Visual Data Lineage
Visually document source/target mapping and sourcing rules using a drag-and-drop interface to understand Extraction, Transformation, and Load (ETL) data movement across systems
Source-to-target Mapping
View the relationships between the source and target, how the data flows from one table to another, and how the data is transformed
Dimensional Modeling
Leverage complex star and snowflake schema designs and support importing rich dimensional metadata from BI and data warehouse platforms
Metadata Integration
Import and export metadata from BI Platforms, UML and data modeling solutions, XML Schemas and CWM (Common Warehouse Metamodel) to create a metadata hub
Data Classification
Categorize and label objects according to the level of security and privacy
Permission Management
Enable user, role and group permissions at logical and physical level
Security Attributes
Define data security types and properties to be observed and enforced for compliance
Security Center Groups
Streamline security administration with local or LDAP groups improving productivity and reducing errors
Concurrent Model and Object Access
Allows real-time collaboration between modelers working on data models down to the model object level with token-based check-in/check-out
Version Management
Manages the individual histories of models and model objects to ensure incremental comparison between, and rollback to, desired diagrams
Component Sharing and Reuse
Predefined Enterprise Data Dictionary eliminates data redundancy and enforces data element standards
Agile Change Management
Assign and track tasks associated with data models to align changes to user stories and development workflows.
Automatically create highly readable, highly navigable diagrams with one or a combination of layouts
Automated and Custom Transformation
Streamlines the derivation of one or more physical designs from a logical one and checks for normalization and compliance with the target database
Rich Text Editing
Easily edit text in data object fields, with integrated spell-checking, embedded hyperlinks, and text wrapping.
Extensible Automation Interface
Automate tedious, routine tasks such as coloring tables, enforcing and applying naming standards, globally update storage parameters and integrate with desktop applications
Multiple Reporting Formats
Publish models and reports in a variety of formats including HTML, RTF, XML Schema, PNG, JPEG and DTD Output