CA ERwin^® Data Modeler (CA ERwin DM) for Microsoft^® SQL Azure™ is a single platform version of our flagship data modeling solution, CA ERwin Data Modeler. It can be used on its own to manage MS SQL Azure-only environments, or as an add-on to an existing edition of CA ERwin Data Modeler to provide a powerful way to visualize data from multiple sources across the organization, whether on-premise or in the Cloud.

Key Features

Visualization of Complex Data Structures: CA ERwin provides a simple, graphic display to visualize complex database structures in an easy-to-manage interface.

Design Layer Architecture: CA ERwin offers unique flexibility to create multiple model layers, from logical to physical, to even higher-level models. Users can create logical and physical models that are completely separate, or create logical and physical models that are linked, allowing you to choose the implementation style best suited to your needs.

Standards Definition: Reusable standards improve an organization’s ability to develop and manage their information assets in a cost and time-effective manner. CA ERwin supports the definition and maintenance of standards through reusable model templates, the Domain Editor, the Naming Standards Editor and the Datatype Standards Editor.

Large Model Management: CA ERwin helps you manage large enterprise-level models through subject areas and diagrams. These graphical views and model visualizations facilitate information exchange and collaboration among the different stakeholders in an organization. In addition, advanced features such as auto-layout, on-demand UI components, and “bird’s-eye” navigation allow you to easily visualize large models.

Complete Compare: This powerful feature automates complete bidirectional synchronization of models, scripts and databases, compares one item with the other, displays any differences and permits bidirectional selective update. If model changes are targeted for a database, CA ERwin can automatically generate a database ALTER script, as desired.

Database Design Generation: CA ERwin allows you to create database designs directly from visual models, increasing efficiency and reducing errors. Industry-leading database support includes optimized referential integrity trigger templates and a rich cross-database macro language, allowing modelers to customize triggers, scripts and stored procedures. Customizable templates facilitate the generation of a model’s complete physical design and definitions.

Data Warehouse and Data Mart Design: The performance, usability and value of a data warehouse are determined by its underlying design. CA ERwin supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), optimizing the data warehouse for your performance and analysis needs. It also captures and documents a rich set of information about the warehouse including data sources, transformation logic and data management rules.

“Bulk” Metadata Editing: The Bulk Editor provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface allowing for bulk updates, exports to Excel, and metadata queries. 

Reporting and Printing: Every commercial copy of CA ERwin Data Modeler  includes a copy of SAP Business Objects’ Crystal Reports. Customers can use out-of-the-box reports, or create their own. A generic ODBC interface is available for customers who use other reporting tools. Reports may be generated in a variety of formats, including HTML, PDF, RTF and TXT.

Integration & Metadata Exchange with Other Tools: It’s easy to integrate CA ERwin with other projects and tools with import or export from a wide variety of sources, including BI tools, MDM hubs, other data modeling tools, Extract, Transform, Load (ETL) tools and Unified Modeling Language (UML) tools.

And More: Read the full Product Brief (PDF) for a more detailed list of features.

Platform Support

CA ERwin Data Modeler for Microsoft SQL Azure runs in the following environments:

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

The stand-alone version of CA ERwin Data Modeler for Microsoft SQL Azure supports the following database environments, in addition to MS SQL Azure, with a limit of 25 objects.  Note that there is no limit to the number of objects managed for the MS SQL Azure platform.

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

If CA ERwin Data Modeler for Microsoft SQL Azure is purchased as an add-on to the CA ERwin Data Modeler Standard or Workgroup Edition, the  following database platforms are available, with an unlimited number of objects, in addition to Microsoft SQL Azure.

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