CA ERwin® Web Portal
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.
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 and “Where Used” Paths: 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 Data Sheet (PDF) for a more detailed list of features.
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.
|Standard Edition||Enterprise 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||
The Repository Web Application Server is available on:• Oracle 10g or 11g
• SQL Server Express or Enterprise 2005 or 2008
for scalability and performance
|Native product authentication and authorization using pre-defined permission roles only. Single Sign-ON (SSO) not available||Users can be externally managed by a live Enterprise Single Sign-On (SSO) user authentication (e.g. LDAP)|
|No Integration with Workgroup Edition (Model Manager)||Integration of the publishing process with CA ERwin Data Modeler Workgroup Edition (Model Manager)|
|Pre-defined Users and Roles only||Customization of Users and Roles|
|No Versioning & Configuration via Web Portal||Versioning & Configuration Management (within Web Portal Repository, separate from Mart)|
|No Object Customization via Web Portal||Object Customization through user-defined properties (separate from CA ERwin UDPs)|
|1-50 users||25-400+ users|
CA ERwin Web Portal server runs in the following environments:
- Windows XP SP3
- Windows 2003 and 2008 Server
- Windows Vista
- Windows 7
- Windows 8.1
CA ERwin Web Portal supports the following database environments for its repository:
- Standard Edition — Microsoft SQL Server 2008 R2 (any edition) to 2012
Enterprise Edition — Integration with existing enterprise database servers including:
− Oracle 10gR2 to Oracle 12c
− • Microsoft SQL Server 2008 R2 (any edition) to 2012
Web browsers used for the CA ERwin Web Portal should support Adobe Flash v8 or newer, for example Microsoft Internet Explorer 8+, Mozilla Firefox 5+, Apple Safari 5+and Google Chrome 14+.