Key Features

erwin Data Modeler for Microsoft® SQL Azure™ is a single platform version of our flagship data modeling solution

It can be used on its own to manage Microsoft® SQL Azure™-only environments, or as an add-on to an existing edition of erwin Data Modeler to provide a powerful way to visualize data from multiple sources across the organization, whether on-premise or in the Cloud
Manage both on-premise and cloud-based databases on Microsoft® SQL Azure™ from a single data modeling environment
Support migrations of data structures from on-premise to cloud databases
Database design for the Microsoft® SQL Azure™ cloud database platform using a familiar modeling interface

Visualization of Complex Data Structures

erwin provides a simple, graphic display to visualize complex database structures in an easy-to-manage interface.

Design Layer Architecture

erwin offers 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. 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

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, erwin can automatically generate a database ALTER script, as desired.

Database Design Generation

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. 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 & Publication

The Report Designer’s intuitive point-and-click interface can create HTML and text-based reports for both diagrams and metadata.

Integration & Metadata Exchange with Other Tools

It’s easy to integrate 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.

Read the full Data Sheet (PDF) for a more detailed list of features.

Operating System Support

erwin Data Modeler for Microsoft® SQL Azure™ requires that you have the 32-bit or 64-bit version of one of the following systems of the latest release installed:

  • Microsoft Windows Server 2008 SP2, R2
  • Microsoft Windows 7 SP1
  • Microsoft Windows 8.1
  • Microsoft Windows 10
  • Microsoft Windows Server 2012, R2

Supported Databases

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

  • DB2 LUW
  • MySQL
  • ODBC
  • Oracle
  • SQL Server
  • SAP ASE

If erwin Data Modeler for Microsoft® SQL Azure™ is purchased as an add-on to the 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
  • SAS
  • Microsoft® SQL Server
  • SAP ASE
  • SAP IQ
  • Teradata

Other Products

Standard Edition

The industry-leading data modeling solution that provides a powerful way to visually design and document any data source deployed across the organization. erwin increases efficiency through reuse and standards, while increasing data quality and providing a unified view of strategic data assets.

Learn More

Workgroup Edition

Our industry leading data modeling solution with collaborative governance capabilities for you data definition and modeling processes. It provides change management, conflict resolution, versioning, security and standardization for multi-user modeling. Through a central repository, model assets can be inventoried and re-used across the organization.

Learn More

Navigator Edition

Data models are relevant to many different audiences across the organization. The ability to permit others to visualize and analyze the details of model metadata is critical to successful collaboration of diverse project teams.

Learn More

Web Portal

A simple, customizable, web-based interface that allows both business and technical users across the organization to easily visualize the important metadata information that is stored in erwin Data Modeler and beyond.

Learn More

Data Governance

Building on a foundation of visual and comprehensive erwin data models, organizations can use erwin Data Governance to author and deploy business glossaries, define semantic and data flow lineages, standardize and document data sources and enable self-service data discovery in support of their enterprise data governance program.

Learn More

Safyr Option for ERP

erwin Safyr Option extracts metadata from a variety of ERP applications — including SAP, Salesforce, and Oracle. Translate often-challenging naming conventions in these systems into user-friendly values for modelers to search, browse and subset this metadata prior to creating erwin data models.

Learn More

CloudCore™

Data modeling and enterprise architecture integrated in the cloud for greater collaboration, agility and quality of enterprise data and architecture assets. erwin CloudCore™ combines erwin Modeling and Corso Agile EA in a single, integrated and collaborative platform.

Learn More