| 		
				
|  | 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 |  |