Jumar:Links

Generates business-oriented interfaces to database tables
Jumar:Links for AllFusion ERwin Data Modeler and Business Intelligence opens up the data in production databases and data warehouses to the non-technical user. Using information contained in AllFusion ERwin DM models, it automatically generates logical, business-oriented interfaces to the physical database tables which can then be fed directly into reporting tools.

Jumar:Links can be purchased separately, however, for customers who are interested in using it in conjunction with AllFusion ERwin Data Modeler, a special Bundle - the Business Intelligence Bundle - is available which offers a £500 saving over buying the products separately.

Jumar:Links - Features

Jumar:Links for AllFusion ERwin Data Modeler and Business Intelligence opens up the data in production databases and data warehouses to the non-technical user. Using information contained in AllFusion ERwin DM models, it automatically generates logical, business-oriented interfaces to the physical database tables which can then be fed directly into reporting tools.

The Problem: Users wanting to use reporting tools for querying existing databases usually have to do a considerable amount of work before they can start to design any reports. This is because they are normally faced with a physical database structure, not a logical one. Physical database structures are often very difficult to use because table and column names are not meaningful to business users, and because they may not contain foreign keys. First, the user must understand what tables and columns are needed and how they relate to one another; then they must define logical names or aliases, for the tables and columns; and finally they must define the links or joins between the tables. Only then can they start to actually design the reports they need.

The Solution: An add-in for ERwin that will extract the metadata from a logical/physical model and build an open 'logical' interface to the database, containing pre-defined logical views and associations, in a common format which can be accessed by major reporting tools.