As data volumes continue to grow, companies must manage and maintain their data while facing increasingly complex challenges such as mergers and acquisitions, budget reductions and evolving technologies. Maintaining a competitive edge in any market requires faster, better decisions based on accurate data. In order to build high-performance business applications and data warehouses, organizations need to build a solid database foundation while at the same time they must also control the total cost of ownership over the entire data life cycle.
CA Erwin Data Modeler enables you to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data. CA Erwin streamlines the design process by providing an easy-to-use graphical environment that simplifies database design and maintenance, automates many time-consuming tasks and enhances communication across your development organization, increasing both efficiency and data quality, while at the same time reducing costs.
CA Erwin understands how to manage complex data environments. Organizations like yours are using CA Erwin Modeling to manage their enterprise data management initiatives - managing complexity, increasing quality, and reducing maintenance and development costs. CA Erwin is a key component of any organization's enterprise information management infrastructure and a natural choice when it comes to designing and managing your information assets.
CA Erwin Data Modeler Standard Edition increases productivity by providing an easy-to-use graphical environment that simplifies database design and automates many time-consuming tasks, accelerating the creation of high-quality, high-performance transactional and data warehouse databases. The ability to visualize large quantities of data objects in a graphical format helps promote effective communication between the business and technical stakeholders, ensuring that business requirements align with technical database implementations. With a visual design, database developers can address design issues and concerns prior to any significant resource investments, helping your organization respond faster to evolving business needs by highlighting the impact of change on information assets and allowing you to respond quickly and the ever-changing and quickly growing data environment.
Visualization of complex data structures
Erwin provides a simple, graphic display to visual complex database structures in an easy-to-manage interface.
Design layer architecture
Erwin offers unique flexibility to create multiple model layers, from logical to physical, to even higher-level models. Users can create logical and physical model 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. Erwin supports the definition and maintenance of standards through reusable model templates.
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-eye" navigation allow you to easily visualize large models.
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, thereby 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.
Reporting and printing
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 and 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.
The bulk editor provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface. Your volume updates have now become easier, with more flexible export and reporting options as well.
Maximized drawing palette with on-demand UI
The ability to invoke toolbars and editors on-demand saves valuable drawing space - giving you a full screen to work with for large volumes of information.
One-click auto layout for model diagrams
The auto layout feature saves you from wasting valuable time redrawing models for readability - Erwin can do it automatically with a single click.
Definitions and metadata are the crux of your data model - make sure they're spelled right. Automated spell checking of textual metadata has been added to facilitate the validation of user supplied text.
This product can only be sold to College Students, Accredited Educational Institutions, Administrative Offices & Boards of Education, Public Libraries, and Public Museums. Students are limited to 1 copy of each product per calendar year. Students must supply either a clear copy of their student ID or a enrollment verification letter from the registrar's office, via FAX or e-mail(.jpg). Institutions must supply a signed purchase order. We cannot ship academic orders unless we receive valid credentials. Please click here for instructions.