|
Entity Relationship Diagrams
Multiple diagrams
Crow's foot notation
UML notation
Fully graphical editing
Entities
Relationships
Composite elements
Annotations
Views
Interfaces with methods
|
|
Entity modeling
Multiple attributes
Text attributes
Numeric attributes
Date attributes
Boolean attributes
BLOB/file attributes
Uniqueness constaints
Nullable attributes
Default values
Custom constraints
|
|
Relationship modeling
Stereotypes for all bilateral relations
End-point cardinality
Mandatory end-points
Optional (null) end-points
|
|
Drawing features
Automatic object alignment
Move and resize
Align; center, horizontal, vertical
Distribute; vertically, horizontally
Space equally; vertically, horizontally
Cascade objects
Copy to clipboard
Save as image (png, wmf etc.)
|
|
Solution features
Automatic naming conventions
Cascading changes and names
Refactoring of model
Guaranteed model consistency
Automatic interface composition
Automatic model documentation
Built-in web service test utility
|
|
Collaborative features
Deploy directly in database
Deploy directly on web site
Integrated with Cloud solution
Centralized server development
Allows multiple developers
|
|
SQL utility tool
Browse database tables and views
Analyze column details
General purpose SQL prompt
SQL Server, MySQL, Postgre, Oracle, DB2
|
|
|
Relational database generators
Supports SQL Server
Supports MySQL
Supports PostgreSQL
Generates SQL/DDL database
Incremental database update
Creates and updates tables
Manages column changes
Generates default values
Generates foreign keys
Generates constraints & indexes
Creates views
Inserts model default data
|
|
Application code generators
Generates programming interface
Generates c# code
Generates PHP/mysqli code
Generates PHP/postgres code
Generates SOAP web services
Generates persistance layer
Convention based stereotypes
Access from any language or IDE
Use directly in integration engine
|
|
Interface/method editor
Requires no programming skills
Stereotype based methods
Edit method arguments
Edit method returns set
Edit method filtering criteria
Edit method result set sorting
Supports custom code methods
|
|
Method orchestration
Requires no programming skills
Drag-n-drop to aggregate methods
Detailed aggregation control
Automatically remains consistent
|
|
View editor
Requires no SQL skills
Combine entities and views
Automated joins
Filtering criteria
|
|
Index modeling
Requires no SQL skills
Compose indexes
Supports attributes and relations
Search indexes
Unique indexes
|
|
Import database
Import tables and columns
Import views as entities
SQL Server, MySQL, Postgres, Oracle, DB2
|
|