ERwin® Web Portal
The 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 ERwin Data Modeler and beyond. 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 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. ERwin Web Portal is available in your choice of 3 editions (Standard, Enterprise and Data Governance) that build from a role based data modeling web portal to a full featured data governance solution
Internet-Style Keyword Search: If you can use an internet search tool, you can use the 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 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 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 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.
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.
New in the ERwin Web Portal – Data Governance Edition:
- Business Glossary: ERwin Web Portal provides an ISO 11179 based Business Glossary to capture, define, maintain and implement an enterprise Business Glossary of terminology, data definitions, code sets, domains, validation rules, etc.
- Semantic Mapper: This capability facilitates the classification of business terms and/or the connection of design layer metadata from conceptual through logical to physical data models. This permits users to view semantic data usage and to perform impact analysis not only on term usage but also based on data flow lineage.
- Data Mapper: Allows users to define a data flow mapping specification for their modeling metadata, including a data movement specification and full visualization of both source and target models with “drag and drop” ease enabling users to create a holistic picture for lineage and impact analysis.
- Live Metadata Harvesting of Data Stores: Connects directly to existing databases and Big Data sources which then may be documented and mapped in real-time over the web using the Data Documenter and Data Mapper.
- Universal Data Model Harvesting: This capability allows data models created in tools other than ERwin Data Modeler to be harvested for the purpose of standardization, impact analysis and rigorous data governance.
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 ERwin Web Portal is offered in three editions: the Standard Edition, which is ideal for smaller organizations and/or those looking for ease of configuration and setup, the Enterprise Edition, which supports a larger number of users and provides advanced customization options and the Data Governance Edition, which provides web based metadata authoring, workflow and mapping capabilities critical to enabling an ongoing data governance strategy.
|Standard Edition||Enterprise Edition||Data Governance 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
The Repository Web Application Server is available on:
• Oracle 10g or 11g
|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)||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 ERwin Data Modeler Workgroup Edition (Model Manager)||Integration of the publishing process with ERwin Data Modeler Workgroup Edition (Model Manager)|
|Pre-defined Users and Roles only||Customization of Users and Roles||Customization of Users and Roles|
|No Versioning & Configuration via Web Portal||Versioning & Configuration Management (within Web Portal Repository, separate from Mart)||Versioning & Configuration Management (within Web Portal Repository, separate from Mart)|
|No Object Customization via Web Portal||Object Customization through user-defined properties (separate from ERwin UDPs)||Object Customization through user-defined properties (separate from ERwin UDPs)|
|Business Glossary driven data governance is not available||Business Glossary driven data governance is not available||Business Glossary driven data governance ( Capture, define, maintain and implement an enterprise Business Glossary of terminology, data definitions, code sets, domains, validation rules, etc.)|
|Authoring metadata mappings is not available||Authoring metadata mappings is not available||Authoring metadata mappings( Data flow lineage and semantic lineage mappings can be defined and maintained)|
|1-50 users||25-400+ users||25-400+ users|
ERwin Web Portal server runs in the following environments:
- Windows XP SP3
- Windows 2003 and 2008 Server
- Windows Vista
- Windows 7
- Windows 8.1
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 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+.