CA ERwin r9 Web Portal

Product Information

The CA ERwin Web Portal provides a simple, customisable, web-based interface that allows both business and technical users across the organisation to easily visualise 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 organisation.

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 Visualisation: 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 organisation.

Editions

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

Standard Edition

• The Repository Web Application Server runs on the SQL Server Express database and therefore does not require the purchase or use of an existing database.
• Native product authentication and authorisation using pre-defined permission roles only. Single Sign-ON (SSO) not available.
• No Integration with Workgroup Edition (Model Manager).
• Pre-defined Users and Roles only.
• No Versioning & Configuration via Web Portal.
• No Object Customisation via Web Portal.
• 1-50 users.

Enterprise Edition

• The Repository Web Application Server is available on: Oracle 10g or 11g, SQL Server Express or Enterprise 2005 or 2008 for scalability and performance.
• Users can be externally managed by a live Enterprise Single Sign-On (SSO) user authentication (e.g. LDAP).
• Integration of the publishing process with CA ERwin Data Modeler Workgroup Edition (Model Manager).
• Customisation of Users and Roles.
• Versioning & Configuration Management (within Web Portal Repository, separate from Mart).
• Object Customisation through user-defined properties (separate from CA ERwin UDPs).
• 25-400+ users.

System Req.

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+.