Find the Quick Solution to your data management challenges
Pick your challenge from the three options below: 1) best practices, 2) business intelligence, or 3) ERwin trouble. Then watch a 4-minute video about how to solve it.
Security for 2011 Manage your database model repository with project and role-based security. Role-based security enables you to scale data models to the Enterprise with the highest level of model governance
Model Merge and Branch Management Manage parallel development efforts with the simple Merge and Branch utility. This enables the architecture team to manage development, QA, and Productions versions of the same database model.
Enterprise Data Dictionaries Promote and enforce standardization and reuse amongst new and existing projects. The Enterprise Data Dictionary enables an organization to track, promote, and measure reusability of corporate data modeling assets.
Data Mining Your Model Repository Enable the ability to do business intelligence and data mining across all data models in a single repository. Answer questions like "How many types of Customer do we have" or "How many times have we used the term Product" in our databases.
Automatic Submodel Creation Quickly reverse engineer a database and break it into logical submodels automatically. This saves an enormous amount of time in getting a quick understanding of a database that you didn't design but need to redesign or consolidate.
Stuck on ERwin?
Overview of DB Change Manager 6.0 XE2 General Overview of product functionality including: Schema Compare and Synchronization, Data Compare and Synchronization, Database Configuration Settings Compare and Synchronization, Schema Archive, Configuration Settings Archive and more!
DB Change Manager 6.0 XE2 integration with ER/Studio Review of process by which ER/Studio users can set up a process to monitor a database for expected or unexpected changes. By automating this process via the command line and associating an email notification with each execution of the monitoring process, ER/Studio users can determine what if any changes must be updated in their ER model.
Migrating from ERwin Are you frustrated with your legacy tool and hoping to get onto a modern tool without losing your stride? Watch how easily and how well you can switch from that old ERwin to a better solution without losing any existing work.
Object Definitions You need to have business definitions for the thousands of objects in your data model so the model will make sense. You can't train everyone to use a data modeling tool, but you still need them to understand what they see in your models. This is the solution.
Automated Reporting Do you need to be able to communicate with business analysts, with project managers, and with subject-matter experts? Learn how your users can explore your organization's metadata and create for themselves the report that they need, without the data architect having to do anything.
Business Intelligence Pain
Security level attachments You need to document where you are storing PII or PCI information. Watch how to create and distribute that documentation, which is very important for auditing and verification. Whether for data classification or security classification, this gives you the ability to document security implications, allowing your users to provide documentation of the security impact of data objects. You'll have the ability at the table or column level to show the security impact of, for example, PII or PCI.
Sub-modeling, attribute level You have a data warehouse with huge tables, but for your next business intelligence report, you only need four out of 130 columns. Watch how to choose exactly which columns are displayed in a submodel so you can produce diagrams customized for a particular audience. Name handling and the ability to take the general use case, such as abbreviations instead of words, and side-by-side expanded name, allow users to understand the field that is showing.