The CA ERwin^® Web Portal provides 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 CA ERwin^® Data Modeler.  While only certain users will want to view or create data models, many more users need access to the information in those models, but would like this information presented in an intuitive and easily-accessible way.  The CA ERwin Web Portal allows easy access to information via the web, with a variety of presentation and search formats to cater to a wide range of user types in the organization.

Key Features

Internet-Style Keyword Search: If you can use an internet search tool, you can use the CA ERwin Web Portal.  With a single keyword-based search, you can discover data assets that relate to your core business areas, such as “credit risk” or “customer”. Queries can be “memorized” as links (URLs) which reproduce the results and may be shared with others (e.g., via email) to allow further analysis.

Graphical Impact Analysis: The inter-relationships between data assets are a key part of the value of a data model. With the CA ERwin Web Portal, you can view these interrelationships graphically, using the Lineage Analyzer tool.  Uncover which tables are used by a given query, what columns are used by a domain, how conceptual, logical, and physical models interrelate, and other powerful analysis tools to assess the impact of change in the organization.

Diagram Visualization: A picture is worth a thousand words, and with the CA ERwin Web Portal, you can easily see important data structures through intuitive visual models in various formats (including IE, IDEF, UML, and more). Powerful drill-down capabilities allow you to perform “what-if” analysis from these diagrams to drill-down into textual metadata details to uncover definitions, data structures, related queries, and more.

Interfaces for Business & Technical Users: Whether you are a business or technical user, the CA ERwin Web Portal has an interface for you. Business users are provided with simple tools like internet-style keyword searches and visual analysis with just the right amount of information to keep it simple, while providing necessary and valuable insights around their data assets. Technical users are offered a wide array of search, analysis, and query options on the full set of technical data objects. With the Enterprise Edition, custom interfaces can also be created for specific user types in your organization.

Reporting: Tabular reports are provided for common queries, with the ability to customize which column headings are displayed  and to sort by any column. The hardcopy rendering may be sent to a printer or “published” in some other suitable format such as PDF.

Browsing & Drill-Down: A variety of flexible interfaces are provided to facilitate browsing, lineage, and “drill-down” capabilities including:  dynamic tree expansion, dynamic menus on objects, link navigation between objects, and graphical visualization options..

Easy Roll-Out: With a web-based interface, no local installation is needed for each user, providing easy roll-out to multiple users across the organization.

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

Product Editions

The CA ERwin Web Portal is offered in two editions: the Standard Edition, which is ideal for smaller organizations and/or those looking for ease of configuration and setup, and the Enterprise Edition, which supports a larger number of users and provides advanced customization options.

Platform Support

CA ERwin Web Portal server runs in the following environments:

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

CA ERwin Web Portal supports the following database environments:

• Standard Edition — Microsoft SQL Server 2008 Express (download free edition)
• Enterprise Edition — Integration with existing enterprise database servers including:
  − Oracle 10gR2 to Oracle 12
  − Microsoft SQL Server 2005 / 2008

Web browsers used for the CA ERwin Web Portal should support the Flash plug-in, for example Internet Explorer 8 or 9, Mozilla Firefox 4+, and Google Chrome 6+.