CA ERwin Web Portal 9.1

New Features

New “High Fidelity” Diagram Visulizer

For “Faithful” rendering of the original model diagrams as developed in ERwin

Retains original object positions and sizes
Properly supports auto size entities
Retains display levels for individual objects and the diagram as a whole
Retains original entity fonts
Retains original attribute data type aligments
Retains other shapes and additional documentation on the diagram
Separates Logical and Physical Diagrams

Please note: One must re-harvest (re-publish) any models already in the Web Portal before these High Fidelity features may be viewed.

Diagram Relationship Analysis

Allows the user to highlight the PK/FK's involved in a relationship and even generate the relationship join expression which may be cut and pasted for immediate use in SQL queries.

New Powerful Search Language

Allowing for sophisticated / advanced search such as:

Any Words: sales order → sales OR order

Exact Phrase: "sales order" → "sales order" exactly
All Words: +sales +order → sales AND order
Exclude Words: sales -order → sales WITHOUT order
Wild Card End: sale* → starting with "sale"
Parent and Child: sales.order → object called "order" with parent called "sales"
Exact Name: .order → object called "order"
Object Type: type:Column → restrict search to objects of type "column"
Property Type: property:name → restrict search to attribute "name"

New Model Browsing Experience

Offering a separate model browse panel simultaneously displayed adjacent to diagrams and lineage

Enhancements

Semantic and Data Flow Lineage & Impact Analysis

Direct access to essential analysis:

Trace Data Lineage (e.g. views to tables)
Trace Data Impact (e.g. tables to views)
Trace Semantic Definition (e.g. physical tables to logical entity)
Trace Semantic Usage (e.g. logical entity to physical tables)

Choice of presentation:

Simple List (of ultimate sources and/or destinations)
Advanced Graph (of semantic and/or data flow)

Choice of direction:

Reverse (for Data Lineage or Semantic Definition)
Forward (for Data Impact or Semantic Usage)

Data Flow Advanced Analysis

Separation of data flow and control flow:
- Data flow (actual movement of data)
- Control flow (conditions and filters)
  - Column Control (which directly impacts values)
  - Row Control (which does not directly impact values such as filters)
Visualization of the different types of lineage by using line colors & thickness conventions:
- gray lines means data flow with no transformation (i.e. pass through)
- black lines means data flow with transformations (e.g. expression)
- thick lines means data flow with transformation processes (e.g. ETL workflows that can be analyzed when clicking on such lines)
- yellow lines means column control flow (e.g. loockups)
- yellow dashed lines means row control flow (e.g. filters)
- blue lines means semantic flow

Search

Search improvements for SQL Server wildcard/word break searches

Any Words:	sales order	→ sales OR order
Exact Phrase:	"sales order"	→ "sales order" exactly
All Words:	+sales +order	→ sales AND order
Exclude Words:	sales -order	→ sales WITHOUT order
Wild Card End:	sale*	→ starting with "sale"
Parent and Child:	sales.order	→ object called "order" with parent called "sales"
Exact Name:	.order	→ object called "order"
Object Type:	type:Column	→ restrict search to objects of type "column"
Property Type:	property:name	→ restrict search to attribute "name"