CA ERwin Data Modeler for Microsoft SQL Azure is a single platform version of the 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.
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 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.
Reusable standards improve an organization's ability to develop and manage their information assets in a cost and time-effective manner.
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.
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, 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.