The Challenge of Locating and Utilizing Enterprise Data
Smarter companies realize that success and competitive advantage comes from being able to fully access, correctly interpret, and completely utilize large volumes of enterprise data.
Data management professionals face three distinct challenges:
- Responding quickly to regularly changing business demands for accurate, timely data
- Delivering easy to manage enterprise-level standards and data transparency
- Clearly and effectively communicating data throughout an organization
We are surrounded by data. Being able to recognize what can be of service to us, and having confidence in its quality, allows us to explore and leverage it more readily.
ER/Studio Portal provides real-time metadata information access via advanced ad-hoc query and reporting while serving as a powerful administrative and security console.
ER/Studio Portal is a powerful online metadata query and reporting tool that combines portal and search technologies. With a few clicks, users can easily access data model definitions and objects stored in the ER/Studio Repository. By providing real-time access and configurable reports of all data models and repository metadata, the Portal facilitates improved metadata consistency and better collaboration.
ER/Studio Portal provides an easy-to-use interface with structured hierarchical information browsing and navigation through detailed drill-downs. With more than 20 out-of-the-box reports, users can quickly execute a report on an entity, submodel, or model and drill down to the detailed report for each object type.
Data management professionals can give business users maximum data transparency, while driving the transformation of raw data in to valuable, decision-supporting information.
| User Searching and Browsing |
| Structured Browsing and Navigation |
Web-based navigation of repository diagrams including enterprise data dictionaries and nested models within project folders |
| Simple Searching |
Search text properties of all object types and diagrams including partial matches |
| Advanced Searching |
Wildcard searching with ability to limit object types or projects |
| Business Reports |
Pre-installed reports geared towards business analysts looking for business names, definitions and object whereabouts |
| Technical Reports |
Pre-installed reports for implementation details such as data types, column names and width, object relationships, data lineage and security classification |
| Saved Reports |
Execute and save reports and searches in background |
| Report Interaction and Organization |
| Document and Provide feedback on Reports |
Comment on reports to communicate observations and improve comprehension |
| Organize Reports |
Add custom labels to multiple reports to categorize and organize them |
| Security |
| Secure Login |
Authenticate users prior to running queries and reports |
| Role based permissions |
Grant permissions for an action sequence based on user, group or role |
| Administrator Services |
| Administrator Page |
Centrally maintain access controls, schedules, subscriptions and BI Server settings |
| Automatic Data Synchronization |
Most recent version of the diagram will be sent to the reporting portal at administrator scheduled updates |
| Diagram Filtering |
Ability to filter content by diagram that flows from the ER/Studio Repository to the reporting database |
| Portal UI Customization |
Customize portal style, layout, content schemes, banners, menu bars including colors, images, titles and fonts |
| Custom Reporting |
Administrators can generate model, dictionary or data lineage business reports while choosing content items, format, sorting, aggregation, and filter criteria. Saved reports can be rerun by other users |
| Out-of-the-Box Template Reports |
ER/Studio-themed templates to create custom business, technical and impact analysis reports |
| DBMS Support |
IBM DB2 (8.x, 9.x), Microsoft SQL Server (2000…2012), Oracle (10g, 11g) |
System Requirements
- ER/Studio Repository
- 300MB Storage
- 3GB RAM
- Windows 2003 (32-bit) to Windows 7 (32-bit, 64-bit)
- Browser: Firefox 2.0 (or later), Microsoft Internet Explorer 6.0 (or later), Netscape 7.2 (or later) or Safari 1.0
Benefits Summary
- Real-Time Metadata Information and Access
- Advanced Ad-hoc query and Reporting
- Powerful Administrative and Security Console
Ready to learn more about ER/Studio?
Contact us at 1-888-233-2224 or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
For database professionals, ask us about DB PowerStudio, the essential heterogeneous tool kit for Oracle, SQL Server, DB2, and Sybase.
"We switched from CA ERwin to ER/Studio, because the ER/Studio suite gave us the opportunity to move modeling from a task that needed to be completed to a strategic advantage that helps us drive the business." – Fortune 50 Financial Institution, Data Warehouse Director
|