Data Warehousing Concepts in simple words

Introduction to Erwin:

• ERwin is essential in helping your organization maintain its competitive edge by providing the tools to design and implement databases for transactional business, E-commerce, and data warehousing Applications.
• ERwin creates and maintains graphical models that represent databases, data warehouses, and enterprise data models.
• ERwin provides a modeling platform where corporate data requirements and related database designs can be defined, managed, and implemented across a wide variety of database platforms.
• ERwin combines a Windows-based graphical user interface with powerful entity relationship (ER) diagramming tools, custom editors to define physical database objects, a Model Explorer for a text-based view of model objects, and support for the leading SQL and desktop databases.

Erwin’s Benefits:

• Easy-to-use Design Functionality: Database design is made simple through point -and- click creation of a graphical entity-relationship (ER) model of your data requirements and data usage rules.
• Drag-and-drop functionality allows you to quickly create entities and attributes, tables, and columns, and other model objects. Additionally, Erwin’s on-diagram editing facilitates quick and easy design changes.
• Forward Engineering: ERwin generates the physical database schema, including all supported options, from a physical model.
• Reverse Engineering: ERwin lets you capture information in an existing database or DDL script file and then create a physical or logical/physical model based on that information. You can quickly reverse-engineer existing databases for incorporation into new development efforts, and then proceed to add new database objects or even redesign the database structure.
• Manageability: ERwin handles large enterprise models by creating smaller subsets where specific areas can be highlighted. Subsets of large data models are treated as subject areas that are quickly and easily created. To make your designated business data model more accessible.
• Environment Integration: ERwin can design transactional systems, data marts, and data warehouses to be implemented on the same or different platforms. ERwin supports the most popular desktop and SQL database platforms. Because ERwin automatically converts data types and SQL syntax to match the target server you select, you can reuse a data model for different platforms and implementations

You can use Erwin’s application development features to:

• Create a model that contains business requirements as well as the exact design of your physical database.
• Create independent logical and physical models with unique notation and display options.
• Split models of older ERwin versions into separate logical and physical models, derive new models from existing models, and link a model to its source so that changes can be synchronized.

Products from CA – Technologies:

1. Erwin – Data Modeler
2. Erwin – Data Profiler
3. Erwin – Data Model Validator
4. Erwin – Saphir Option for ERP
5. Erwin - Enterprise Product Bundle

Erwin – Data Modeler:

We have all together four editions

1. Community Edition :-

Key Features

• Forward and Reverse Engineering with a 25 object limit
• Complete Compare (read only)
• Bulk Editor
• Visualization, Diagramming, and Display Themes

Platform Support

CA ERwin Data Modeler Community Edition runs in the following environments:

• Windows XP
• Windows 2003 and 2008 Server
• Windows Vista
• Windows 7

CA ERwin Data Modeler Community Edition supports the following database environments:

• Oracle
• SQL Server
• DB2 UDB
• MySQL
• ODBC
• Sybase

1. Standard Edition :-

Key Features:

• Visualization of Complex Data Structures
• Design Layer Architecture
• Standards Definition
• Large Model Management
• Complete Compare
• Database Design Generation
• Data Warehouse and Data Mart Design
• Reporting and Printing
• Integration & Metadata Exchange with Other Tools

Integration & Metadata Exchange with Other Tools:

CA ERwin Data Modeler Standard Edition runs in the following environments:

• Windows XP
• Windows 2003 and 2008 Server
• Windows Vista
• Windows 7

CA ERwin Data Modeler Standard Edition supports the following database environments:

• DB2, including DB2 for i5/OS (System i)
• IDS (Informix)
• MySQL
• ODBC
• Oracle
• Progress
• SQL Server
• Sybase
• Sybase IQ
• Teradata

1. Navigator Edition :

Key Features

CA ERwin Data Modeler NE includes read-only capabilities related to the features found in our Workgroup Edition, focused on: model visualization, “what-if” scenario analysis, model and metadata search, reporting and detailed schema design documentation. Key features include:

• Diagramming, visualization and navigation
• Change impact analysis (read only)
• Mart-enabled for an enterprise-wide view of data assets
• Model subset organization
• Model metadata reporting

1. Work Group Edition

Key Features

CA ERwin Data Modeler WE includes all features included with the Standard Edition plus the following additional features specifically related to workgroup collaboration and governance including:

• Modeler Collaboration Services
• Model Change Management
• Model and Repository Administration

Platform Support

CA ERwin Data Modeler Standard Edition runs in the following environments:

• Windows XP
• Windows 2003 and 2008 Server
• Windows Vista
• Windows 7

CA ERwin Data Modeler Standard Edition supports the following database environments:

• DB2, including DB2 for i5/OS (System i)
• IDS (Informix)
• MySQL
• ODBC
• Oracle
• Progress
• SQL Server
• Sybase
• Sybase IQ
• Teradata

The Repository database can be hosted on the following platforms:

• SQL Server
• Oracle
• Sybase ASE