CA ERwin is an industry-leading data modelling tool that has
been the name trusted in modelling for over 20 years. With
enterprise-class functionality at an affordable price, CA ERwin allows
you to reduce the time and cost spent managing your complex database
environments.
View Video Overview
Key Features
Design Layer Architecture: Aligns data models
with business requirements at the logical level with the database
design at the physical level. CA ERwin Data Modeler maintains a
record of relationships and design decisions, allowing you to
quickly resolve the impact of changes from one design layer to the
next.
Database Design Generation: Forward and
Reverse Engineering capabilities allow you to create an inventory
of existing database structures, and generate new structures from
your model design. Customisable templates facilitate the
generation of a model’s complete physical design and definitions.
Complete Compare: Automates the bidirectional
synchronisation of models, scripts and databases. It compares
items, displays their differences and allows you to select which
differences are moved and in which direction. In addition, should
model changes be moved to a database, CA ERwin Data Modeler can
automatically generate a database ALTER script.
Metadata Integration and Exchange: Provides
wizard-guided import and export capabilities for an out-of-the-box
exchange of model metadata between more than 70 industry-standard
modelling, design and metadata management formats, including the
Unified Modeling Language (UML), Common Warehouse Metamodel (CWM),
Extensible Markup Language (XML), Extract, Transform, Load (ETL),
Enterprise Information Integration (EII), BI tools and various
metadata repository solutions.
Standards Definition: Supports the definition
and maintenance of standards through its domain dictionary, naming
standards editor and data type standards editor.
Reporting and Publication: Offers
flexible, customisable reporting and printing capabilities that
generate in a variety of formats, including HTML and PDF.
Integration with Business Objects Crystal Reports provides
reporting flexibility by allowing you to use the open database
connectivity (ODBC) option to develop customised reports.
CA ERwin Process Modeler provides support for diverse modelling
techniques such as Functional Decomposition (IDEF0), Workflow (IDEF3)
and Dataflow Diagrams (Gane and Sarsons DFD), Activity Based Costing
Analysis and Organisational Modeling.
Key Features
Diverse Process Modeling Techniques and
Notations: Provides integrated reuse and coordination for
business process (IDEF0), workflow (IDEF3) and data flow diagram
(DFD) modelling techniques.
Swim Lane Diagrams: Include an
efficient mechanism for visualising and optimising complex
processes, organising processes across functional boundaries and
enabling you to simultaneously view processes, roles and
responsibilities.
Organisational Charts:
Simplify how business processes are defined and implemented and
support the explicit definition of roles, which classify and
categorise tasks or jobs within a business process.
Cost and Performance Metric Analysis:
Supports activity-based costing (ABC) and is optimised for process
analysis. Comprehensive reporting and a bidirectional interface
with dedicated ABC tools make it easier for companies to implement
an activity-based management strategy.
Simulation Interface: Allows
you to dynamically explore the effect of change by testing
different scenarios before implementation to ensure an optimal
solution. You can also export your CA ERwin Process Modeler
workflow models to Arena, a robust simulation environment, for
real-time analysis.
Process/Data Integration with CA ERwin
Data Modeler: Helps to solve enterprise architecture
analysis problems. The built-in data usage functions and metadata
support in CA ERwin Process Modeler provide detailed, “where used”
mapping of data to process.
CA ERwin Data Profiler helps increase the quality of your
data by performing cross-system analysis and profiling of both
database and legacy systems. Find hidden inconsistencies in data, and
leverage robust statistics to correct data errors in your database or
modelling environment. Cleansed metadata can be exported to CA ERwin®
Data Modeler to create quality data models that match real-world data.
Data Discovery is the process of creating an inventory of data
assets and their interrelationships. The unique combination of data
modelling and data profiling that CA ERwin Modeling offers prompted
Bloor Research to rank CA ERwin as a leader in the Data Discovery
space.
Key Features
Cross-System Overlap Analysis:
Automated cross-compare of all columns across many data sources
(up to 20) in order to establish a baseline of overlapping data.
By leveraging this functionality, you can discover attribute
supersets and subsets, as well as overlapping and unique
attributes, to speed reconciliation of disparate data sources and
effectively identify and document transformation requirements.
Data Synchronisation Analysis:
Validates the uniqueness of a potential global identifier in each
data source and then confirms that data across sources can be
aligned and synchronised using this identifier. This functionality
enables you to prototype and test survivorship rules between
sources before you move the data into a master structure, helping
you ensure quality and consistency across existing sources and
well-aligned target structures.
Column Profiling and Analysis:
Enables the automatic discovery of standard column statistics,
including data type, value frequency, mode, selectivity, format
and more.
Primary Key - Foreign Key Discovery:
Offers fully automated discovery, definition and visualisation of
relationships within a single data source. Inferred relationships
provide critical structural insights into legacy data structures,
as well as points of comparison and confirmation for documented
metadata — allowing your analysts and designers to account for
inherent relationships when building target systems.
CA ERwin Data Modeler Integration:
Enables the creation of data models that can be persisted and
reused within CA ERwin Data Modeler for documentation, impact
analysis and stakeholder visualisation purposes. Based on metadata
inferred from the instance data and profiling results in CA ERwin
Data Profiler, these models help you achieve proper business
alignment, improved end-user understanding and reduced analysis
cycles in subsequent projects.
And More: Read the full
Product Brief (PDF) for a more detailed list of features.
CA ERwin Model Manager provides conflict resolution,
versioning, security and standardisation for multi-user modelling.
Through a central model repository, model assets can be inventoried
and re-used across the organisation.
Key Features
Model change impact analysis: Provides a change
summary showing the impact of changes and the history of the
affected model objects, allowing you to select which changes to
apply to the model repository.
Version management: Lets modellers store,
access and analyse the history of a model and the changes made to
it, lockdown specific versions, run difference reports between
versions and seamlessly roll back models to previous states as
required.
Concurrent model access with optional model
locking: Allows multiple users to concurrently work on a given
model without compromising the integration and integrity of their
parallel efforts.
Sub-modelling and Subject Areas Support:
Provides a focused view that helps individual modellers reduce the
system resources required to upload and download during model
check-in and check-out.
And More: Read the Product Brief (PDF) for a
full list of features.
Platform Support
The Repository database can be hosted on Oracle, SQL Server or
Sybase RDBMS
CA ERwin Data Model Validator verifies the structural integrity of
data models or SQL/DDL code. It helps pinpoint design defects,
recommends corrective actions and automatically generates scripts to
implement selected corrections.
Key Features
Comprehensive Diagnostics and Reporting:
Analyse the schema’s data structure, keys, indexes, field columns
and relationships for violations of relational theory, and
generate a graphical representation of the entire database
structure, including column cross-references and relationship
listings. In addition, diagnostics can be customised to display
the category or severity level of only those areas most important
to your organisation.
Design Discrepancy Isolation: Provides detailed
reports that help increase productivity by accelerating the design
review process via an innovative "show me" facility that isolates
specific design issues in complex database models — eliminating
the task of manually discovering problems or validating a database
or a model subset.
"Teach Me" Facility: Explains the theory behind
relational rules violations and reveals the impact of design
choices or modifications before they occur.
CA ERwin Data Model Navigator provides a cost-effective way to
provide read-only access to models built with CA ERwin® Data Modeler
and CA ERwin® Process Modeler for viewing and analysis.
Key Features
Read-only access: to CA ERwin® Data Modeler and
ERwin® Process Modeler
Navigation and Viewing: provides those who need
to view models, but not update them, full navigation and viewing
of data and process models.
Reporting and Publication: offers flexible,
customisable reporting and printing capabilities that generate in
a variety of formats, including HTML and PDF.
CA ERwin Saphir Option extracts metadata from a variety of ERP
applications — including SAP R/3, SAP BW, Oracle PeopleSoft
Enterprise, Oracle JD Edwards Enterprise One, Oracle Siebel and Oracle
eBusiness Suite. It enables you to translate the often-challenging
naming conventions these system use into more user-friendly values,
allowing modellers to search, browse and subset this metadata prior to
creating CA ERwin data models.
Key Features
Package-Specific Metadata Discovery:
Provides a detailed view into the metadata in your packaged
application — including vendor design artefacts containing any
customisations specific to your ERP instance — providing insight
into the essential elements of this complex business system.
Data Browser: Enables you to
access tables, fields, relationships, data elements, views,
domains and indexes without requiring extensive proprietary
knowledge of the application.
Search and Query Functions:
Helps you to quickly locate all tables containing a specific field
or string of text in their name.
Export to CA ERwin Data Modeler:
Leverage the visualisation, analysis, design and generation
capabilities of CA’s industry-leading data modelling solution into
robust data models.
And More: Read the Product
Tech Brief (PDF) for a more detailed list of features.
Platform Support
CA ERwin® Saphir Option supports the following ERP environments:
For more information please contact the MicroWay sales
team:
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz
